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.cf...
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.