[SR-Users] Kamailio 4.4.x CDR db accounting

[Laura]

Hi,

very strange..

mysql> desc acc;
+------------+------------------+------+-----+---------------------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------------------+----------------+
| id         | int(10) unsigned | NO   | PRI | NULL | auto_increment |
| method     | varchar(16)      | NO   |     | |                |
| from_tag   | varchar(64)      | NO   |     | |                |
| to_tag     | varchar(64)      | NO   |     | |                |
| callid     | varchar(255)     | NO   | MUL | |                |
| sip_code   | varchar(3)       | NO   |     | |                |
| sip_reason | varchar(128)     | NO   |     | |                |
| time       | datetime         | NO   |     | NULL |                |
| src_user   | varchar(64)      | NO   |     | |                |
| src_domain | varchar(128)     | NO   |     | |                |
| src_ip     | varchar(64)      | NO   |     | |                |
| dst_ouser  | varchar(64)      | NO   |     | |                |
| dst_user   | varchar(64)      | NO   |     | |                |
| dst_domain | varchar(128)     | NO   |     | |                |
| info       | varchar(128)     | NO   |     | |                |
| time_a     | datetime         | NO   |     | 0000-00-00 00:00:00 
|                |
| unix_t     | varchar(64)      | YES  |     | 0.0 |                |
| sign       | int(1)           | YES  |     | 0 |                |
+------------+------------------+------+-----+---------------------+----------------+

info field is nothing come from any alter table from my side..


Il 17/06/19 12:38, Daniel-Constantin Mierla ha scritto:
> Hello,
>
> acc table doesn't have in the default structure any column named "info".
> There are only a few columns related to sip attributes and timestamp,
> the module requiring to extend the table to match the needs of each
> deployment. Look in the kamailio.cfg for acc mod param db_extra and see
> if there is a field named info there.
>
> Cheers,
> Daniel
>
> On 17.06.19 11:56, Laura wrote:
>> Dear guys,
>>
>> I'm looking to understand the "info" field inside the CDR written on
>> acc table for Kamailio 4.4.x..
>>
>> It seem that the field is never written with datas.. Is there a way to
>> write some informations inside it ?
>>
>> Thanks for any reply
>>
>>
>>
>> _______________________________________________
>> Kamailio (SER) - Users Mailing List
>> sr-users at lists.kamailio.org
>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users