Hi:
Looking for help in this logging event. Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: PROCEDURE kamailio.kamailio_cdrs does not exist (1305) Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_cdrs()] Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: PROCEDURE kamailio.kamailio_rating does not exist (1305) Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_rating('default')]
I assume the database is missing table entries for these two data inserts.
Any help would be useful.
Thanks.
Kevin
Are you using siremis?
-----Original Message----- From: sr-users [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Kevin Greene Sent: Friday, August 26, 2016 6:42 PM To: sr-users@lists.sip-router.org Subject: [SR-Users] Kamailio Errors that I see in the system logs
Hi:
Looking for help in this logging event. Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: PROCEDURE kamailio.kamailio_cdrs does not exist (1305) Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_cdrs()] Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: PROCEDURE kamailio.kamailio_rating does not exist (1305) Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_rating('default')]
I assume the database is missing table entries for these two data inserts.
Any help would be useful.
Thanks.
Kevin
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
Hello,
it looks like you didn't install the siremis database extensions during installation wizard -- there are new db tables and store procedures added in that step.
Cheers, Daniel
On 27/08/16 00:41, Kevin Greene wrote:
Hi:
Looking for help in this logging event. Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: PROCEDURE kamailio.kamailio_cdrs does not exist (1305) Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_cdrs()] Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: PROCEDURE kamailio.kamailio_rating does not exist (1305) Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Aug 26 22:34:17 sipserver /usr/sbin/kamailio[14790]: ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_rating('default')]
I assume the database is missing table entries for these two data inserts.
Any help would be useful.
Thanks.
Kevin
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users