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
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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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.
-
Daniel Tryba -
Daniel-Constantin Mierla -
Laura