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

[Daniel Tryba]

On Mon, Jun 17, 2019 at 05:18:42PM +0200, Laura wrote:
> +------------+------------------+------+-----+---------------------+----------------+
> | Field           | Type                         | Null | Key | Default | Extra   
> +------------+------------------+------+-----+---------------------+----------------+
> | id                 | int(10) unsigned 
> | method         | varchar(16)          
> | from_tag     | varchar(64)           |
> | to_tag         | varchar(64)          
> | callid         | varchar(255)         
> | sip_code     | varchar(3)             
> | sip_reason | varchar(128)         | NO
> | time             | datetime           
> | src_user     | varchar(64)           |
> | src_domain | varchar(128)         | NO
> | src_ip         | varchar(64)          
> | dst_ouser   | varchar(64)           | 
> | dst_user     | varchar(64)           |
> | dst_domain | varchar(128)         | NO
> | info             | varchar(128)       
> | time_a         | datetime             
> 00:00:00 |                              
> | unix_t         | varchar(64)          
> | sign             | int(1)             
> +------------+------------------+------+-----+---------------------+----------------+
> 
> info field is nothing come from any alter table from my side..
 
The table structure you have is based on
https://github.com/kamailio/kamailio/blob/4.4/examples/kamailio/acc-mysql.cfg

info, time_a, unix_t and sign is something someone at you side has added 
 
The config example listed also show how to populate custom fields in the
acc table:

modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd")

So add info and a variable and it should be stored in the table.