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.c…
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.