custom version database/table
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
-- 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/
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
participants (2)
-
Alex Balashov -
David Villasmil