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 <[email protected]> wrote: > > > 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:[email protected]] > *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:[email protected] > <[email protected]>] *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 <[email protected]> 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:[email protected]] *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 <[email protected]> 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 > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > > -- > > Regards, > > > > David Villasmil > > email: [email protected] > > phone: +34669448337 > > > *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 > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > > -- > > Regards, > > > > David Villasmil > > email: [email protected] > > phone: +34669448337 > > *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 > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > -- Regards, David Villasmil email: [email protected] phone: +34669448337
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
