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(a)azcom.in> 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: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
<sr-users-bounces(a)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(a)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(a)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(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Regards,
David Villasmil
email: david.villasmil.work(a)gmail.com
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
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Regards,
David Villasmil
email: david.villasmil.work(a)gmail.com
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
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Regards,
David Villasmil
email: david.villasmil.work(a)gmail.com
phone: +34669448337