Hello all,
I have a databse where i created a "version" table only with a version, a dispatcher records. I only want to use dispatcher on a db.
I don't know if kamailio is looking for the version tables somewhere else, or it does find it in my database (not named kamailio) but the format is wrong.
I used:
CREATE TABLE `version` ( `table_name` VARCHAR(32) NOT NULL, `table_version` INT UNSIGNED DEFAULT 0 NOT NULL, CONSTRAINT table_name_idx UNIQUE (`table_name`) );
INSERT INTO version (table_name, table_version) values ('version','1'); INSERT INTO version (table_name, table_version) values ('dispatcher','4');
To create an populate the table, but kamailio returns:
mod_init(): could not initiate a connect to the database
but it does connect properly...
any thoughts?
Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337 ᐧ
David,
There should be some additional log messages and/or some more context around this message, although not necessarily immediately around it (due to the parallel nature of Kamailio child processes):
On Mon, Nov 28, 2016 at 07:33:47PM +0100, David Villasmil wrote:
mod_init(): could not initiate a connect to the database
I got
Nov 28 13:38:25 testSVR kamailio[25455]: DEBUG: <core> [db.c:403]: db_table_version(): no row for table alias found Nov 28 13:38:25 testSVR kamailio[25455]: ERROR: dispatcher [dispatch.c:839]: init_ds_db(): invalid table version (found 0 , required 1, 2, 3 or 4)#012(use kamdbctl reinit) Nov 28 13:38:25 testSVR kamailio[25455]: ERROR: dispatcher [dispatcher.c:346]: mod_init(): could not initiate a connect to the database Nov 28 13:38:25 testSVR kamailio[25455]: ERROR: <core> [sr_module.c:968]: init_mod(): Error while initializing module dispatcher (/usr/lib/x86_64-linux-gnu/kamailio/modules/dispatcher.so) ᐧ
Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
On Mon, Nov 28, 2016 at 7:37 PM, Alex Balashov abalashov@evaristesys.com wrote:
David,
There should be some additional log messages and/or some more context around this message, although not necessarily immediately around it (due to the parallel nature of Kamailio child processes):
On Mon, Nov 28, 2016 at 07:33:47PM +0100, David Villasmil wrote:
mod_init(): could not initiate a connect to the database
-- Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 (direct) / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
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
I found my problem, because my custom "dispatcher" table is missing some fields, the loading failed.
No issue :) On Mon, Nov 28, 2016 at 7:56 PM David Villasmil < david.villasmil.work@gmail.com> wrote:
I got
Nov 28 13:38:25 testSVR kamailio[25455]: DEBUG: <core> [db.c:403]: db_table_version(): no row for table alias found Nov 28 13:38:25 testSVR kamailio[25455]: ERROR: dispatcher [dispatch.c:839]: init_ds_db(): invalid table version (found 0 , required 1, 2, 3 or 4)#012(use kamdbctl reinit) Nov 28 13:38:25 testSVR kamailio[25455]: ERROR: dispatcher [dispatcher.c:346]: mod_init(): could not initiate a connect to the database Nov 28 13:38:25 testSVR kamailio[25455]: ERROR: <core> [sr_module.c:968]: init_mod(): Error while initializing module dispatcher (/usr/lib/x86_64-linux-gnu/kamailio/modules/dispatcher.so) ᐧ
Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
On Mon, Nov 28, 2016 at 7:37 PM, Alex Balashov abalashov@evaristesys.com wrote:
David,
There should be some additional log messages and/or some more context around this message, although not necessarily immediately around it (due to the parallel nature of Kamailio child processes):
On Mon, Nov 28, 2016 at 07:33:47PM +0100, David Villasmil wrote:
mod_init(): could not initiate a connect to the database
-- Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 (direct) / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
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
-
Alex Balashov -
David Villasmil