Hi ,
I am getting the following error in trying to send INVITE message from SIP client. {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} NOTICE: acc [acc.c:281]: acc_log_request(): ACC: transaction answered: timestamp=1558902843;method=INVITE;from_tag=69588468;to_tag=ebd29a60;call_id=4_Do2VIMWLR6Wf5ubiBxgg..;code=200;reason=OK;src_user=1016;src_domain=172.25.22.23;src_ip=172.25.22.40;dst_ouser=1015;dst_user=1015;dst_domain=172.25.22.40 May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field list' (1054) May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: <core> [db_query.c:243]: db_do_insert_cmd(): error while submitting query May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: acc [acc.c:477]: acc_db_request(): failed to insert into database May 27 02:04:10 epc-srv-03 /usr/sbin/kamailio[17229]: {2 3 BYE 4_Do2VIMWLR6Wf5ubiBxgg..} NOTICE: acc [acc.c:281]: acc_log_request(): ACC: transaction answered:
*Can anyone help me understand the reason for this error.*
*I am attaching the used kamailio.cfg file in this message.*
*Thanks and Regards,* *Mohit*
That’s really a warning, not a error. The call should work fine; but if it doesn’t it’s not because of this.
In the default kamailio cfg there is a bunch of ALTER TABLE, connect to the kamailio dB and execute them. They will add some extra fields that are not created by default and that script is trying to insert there.
David
On Mon, 27 May 2019 at 11:53, Mohit Chawla mohit.chawla@azcom.in wrote:
Hi David,
Thanks for the response.
Yes, I have modified the cfg file to execute ALTER TABLE command. But somehow, I am facing the problem in starting the Kamailio after the change.
Please find the enclosed modified Kamailio.cfg with this mail.
Can you please help me in understanding the problem when Kamailio is not starting with above modification.
Thanks and Regards,
Mohit
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of David Villasmil Sent: Monday, May 27, 2019 3:52 PM To: Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] Getting the following error when sending INVITE request for calling
That’s really a warning, not a error. The call should work fine; but if it doesn’t it’s not because of this.
In the default kamailio cfg there is a bunch of ALTER TABLE, connect to the kamailio dB and execute them. They will add some extra fields that are not created by default and that script is trying to insert there.
David
On Mon, 27 May 2019 at 11:53, Mohit Chawla mohit.chawla@azcom.in wrote:
Hi ,
I am getting the following error in trying to send INVITE message from SIP client.
{2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} NOTICE: acc [acc.c:281]: acc_log_request(): ACC: transaction answered: timestamp=1558902843;method=INVITE;from_tag=69588468;to_tag=ebd29a60;call_id=4_Do2VIMWLR6Wf5ubiBxgg..;code=200;reason=OK;src_user=1016;src_domain=172.25.22.23;src_ip=172.25.22.40;dst_ouser=1015;dst_user=1015;dst_domain=172.25.22.40 May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field list' (1054) May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: <core> [db_query.c:243]: db_do_insert_cmd(): error while submitting query May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: acc [acc.c:477]: acc_db_request(): failed to insert into database May 27 02:04:10 epc-srv-03 /usr/sbin/kamailio[17229]: {2 3 BYE 4_Do2VIMWLR6Wf5ubiBxgg..} NOTICE: acc [acc.c:281]: acc_log_request(): ACC: transaction answered:
Can anyone help me understand the reason for this error.
I am attaching the used kamailio.cfg file in this message.
Thanks and Regards,
Mohit
Disclaimer: This email and any files transmitted along with it may contain Azcom confidential and proprietary information. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action based on the contents of the information contained herein is strictly prohibited. If you are not an intended recipient of this transmission and you received it in error, please inform the sender by reply e-mail and destroy this and all other copies of this transmission to which you have access. The sender of this email or Azcom does not accept liability for any errors or omissions in the contents of this message that may occur as a result._______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Can’t read a cfg file now, please set the extension to txt
On Mon, 27 May 2019 at 12:55, Mohit Chawla mohit.chawla@azcom.in wrote:
Hi David,
Yes sure. Thanks very much for your support.
Please find Kamailio.txt with the mail.
Regards,
Mohit
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of David Villasmil Sent: Monday, May 27, 2019 6:47 PM To: Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] Getting the following error when sending INVITE request for calling
Can’t read a cfg file now, please set the extension to txt
On Mon, 27 May 2019 at 12:55, Mohit Chawla mohit.chawla@azcom.in wrote:
Hi David,
Thanks for the response.
Yes, I have modified the cfg file to execute ALTER TABLE command. But somehow, I am facing the problem in starting the Kamailio after the change.
Please find the enclosed modified Kamailio.cfg with this mail.
Can you please help me in understanding the problem when Kamailio is not starting with above modification.
Thanks and Regards,
Mohit
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of David Villasmil Sent: Monday, May 27, 2019 3:52 PM To: Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] Getting the following error when sending INVITE request for calling
That’s really a warning, not a error. The call should work fine; but if it doesn’t it’s not because of this.
In the default kamailio cfg there is a bunch of ALTER TABLE, connect to the kamailio dB and execute them. They will add some extra fields that are not created by default and that script is trying to insert there.
David
On Mon, 27 May 2019 at 11:53, Mohit Chawla mohit.chawla@azcom.in wrote:
Hi ,
I am getting the following error in trying to send INVITE message from SIP client.
{2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} NOTICE: acc [acc.c:281]: acc_log_request(): ACC: transaction answered: timestamp=1558902843;method=INVITE;from_tag=69588468;to_tag=ebd29a60;call_id=4_Do2VIMWLR6Wf5ubiBxgg..;code=200;reason=OK;src_user=1016;src_domain=172.25.22.23;src_ip=172.25.22.40;dst_ouser=1015;dst_user=1015;dst_domain=172.25.22.40 May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field list' (1054) May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: <core> [db_query.c:243]: db_do_insert_cmd(): error while submitting query May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: acc [acc.c:477]: acc_db_request(): failed to insert into database May 27 02:04:10 epc-srv-03 /usr/sbin/kamailio[17229]: {2 3 BYE 4_Do2VIMWLR6Wf5ubiBxgg..} NOTICE: acc [acc.c:281]: acc_log_request(): ACC: transaction answered:
Can anyone help me understand the reason for this error.
I am attaching the used kamailio.cfg file in this message.
Thanks and Regards,
Mohit
Disclaimer: This email and any files transmitted along with it may contain Azcom confidential and proprietary information. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action based on the contents of the information contained herein is strictly prohibited. If you are not an intended recipient of this transmission and you received it in error, please inform the sender by reply e-mail and destroy this and all other copies of this transmission to which you have access. The sender of this email or Azcom does not accept liability for any errors or omissions in the contents of this message that may occur as a result._______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi David,
Not able to send the .txt file directly.
I have zipped the (.txt) file and then sending it to you.
Regards,
Mohit
From: Mohit Chawla [mailto:mohit.chawla@azcom.in] Sent: Monday, May 27, 2019 6:52 PM To: 'Kamailio (SER) - Users Mailing List' Subject: RE: [SR-Users] Getting the following error when sending INVITE request for calling
Hi David,
Yes sure. Thanks very much for your support.
Please find Kamailio.txt with the mail.
Regards,
Mohit
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of David Villasmil Sent: Monday, May 27, 2019 6:47 PM To: Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] Getting the following error when sending INVITE request for calling
Can’t read a cfg file now, please set the extension to txt
On Mon, 27 May 2019 at 12:55, Mohit Chawla mohit.chawla@azcom.in wrote:
Hi David,
Thanks for the response.
Yes, I have modified the cfg file to execute ALTER TABLE command. But somehow, I am facing the problem in starting the Kamailio after the change.
Please find the enclosed modified Kamailio.cfg with this mail.
Can you please help me in understanding the problem when Kamailio is not starting with above modification.
Thanks and Regards,
Mohit
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of David Villasmil Sent: Monday, May 27, 2019 3:52 PM To: Kamailio (SER) - Users Mailing List Subject: Re: [SR-Users] Getting the following error when sending INVITE request for calling
That’s really a warning, not a error. The call should work fine; but if it doesn’t it’s not because of this.
In the default kamailio cfg there is a bunch of ALTER TABLE, connect to the kamailio dB and execute them. They will add some extra fields that are not created by default and that script is trying to insert there.
David
On Mon, 27 May 2019 at 11:53, Mohit Chawla mohit.chawla@azcom.in wrote:
Hi ,
I am getting the following error in trying to send INVITE message from SIP client.
{2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} NOTICE: acc [acc.c:281]: acc_log_request(): ACC: transaction answered: timestamp=1558902843;method=INVITE;from_tag=69588468;to_tag=ebd29a60;call_id=4_Do2VIMWLR6Wf5ubiBxgg..;code=200;reason=OK;src_user=1016;src_domain=172.25.22.23;src_ip=172.25.22.40;dst_ouser=1015;dst_user=1015;dst_domain=172.25.22.40 May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field list' (1054) May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: <core> [db_query.c:243]: db_do_insert_cmd(): error while submitting query May 27 02:04:03 epc-srv-03 /usr/sbin/kamailio[17238]: {2 2 INVITE 4_Do2VIMWLR6Wf5ubiBxgg..} ERROR: acc [acc.c:477]: acc_db_request(): failed to insert into database May 27 02:04:10 epc-srv-03 /usr/sbin/kamailio[17229]: {2 3 BYE 4_Do2VIMWLR6Wf5ubiBxgg..} NOTICE: acc [acc.c:281]: acc_log_request(): ACC: transaction answered:
Can anyone help me understand the reason for this error.
I am attaching the used kamailio.cfg file in this message.
Thanks and Regards,
Mohit
Disclaimer: This email and any files transmitted along with it may contain Azcom confidential and proprietary information. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action based on the contents of the information contained herein is strictly prohibited. If you are not an intended recipient of this transmission and you received it in error, please inform the sender by reply e-mail and destroy this and all other copies of this transmission to which you have access. The sender of this email or Azcom does not accept liability for any errors or omissions in the contents of this message that may occur as a result._______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hello,
Did you execute on your MySQL
ALTER TABLE acc ADD COLUMN src_user VARCHAR(64) NOT NULL DEFAULT '';
ALTER TABLE acc ADD COLUMN src_domain VARCHAR(128) NOT NULL DEFAULT '';
ALTER TABLE acc ADD COLUMN src_ip varchar(64) NOT NULL default '';
ALTER TABLE acc ADD COLUMN dst_ouser VARCHAR(64) NOT NULL DEFAULT '';
ALTER TABLE acc ADD COLUMN dst_user VARCHAR(64) NOT NULL DEFAULT '';
ALTER TABLE acc ADD COLUMN dst_domain VARCHAR(128) NOT NULL DEFAULT '';
ALTER TABLE missed_calls ADD COLUMN src_user VARCHAR(64) NOT NULL DEFAULT '';
ALTER TABLE missed_calls ADD COLUMN src_domain VARCHAR(128) NOT NULL DEFAULT '';
ALTER TABLE missed_calls ADD COLUMN src_ip varchar(64) NOT NULL default '';
ALTER TABLE missed_calls ADD COLUMN dst_ouser VARCHAR(64) NOT NULL DEFAULT '';
ALTER TABLE missed_calls ADD COLUMN dst_user VARCHAR(64) NOT NULL DEFAULT '';
ALTER TABLE missed_calls ADD COLUMN dst_domain VARCHAR(128) NOT NULL DEFAULT '';
The error you’re seeing means kamailio can’t find the field src_user on the table, which means you probably didn’t execute the above on your MySQL.
Regards
David
On Mon, 27 May 2019 at 14:31, Mohit Chawla mohit.chawla@azcom.in wrote:
-
David Villasmil -
Mohit Chawla