Guys, I've successfully upgraded schema and binaries for Kamailio, but when I start it, I get:
Jun 25 18:24:34 sbci1pri /usr/local/sbin/kamailio[2611]: ERROR:core:db_check_table_version: invalid version 2 for table carrierfailureroute found, expected 3 (check table structure and table "version") Jun 25 18:24:34 sbci1pri /usr/local/sbin/kamailio[2611]: ERROR:carrierroute:carrierroute_db_init: during table version check. Jun 25 18:24:34 sbci1pri /usr/local/sbin/kamailio[2611]: ERROR:core:init_mod: failed to initialize module carrierroute Jun 25 18:24:34 sbci1pri /usr/local/sbin/kamailio[2611]: ERROR:core:main: error while initializing modules
If I try and set 3 to the version table (for carrierfailureroute) I get the following:
Jun 25 18:42:34 sbci1pri /usr/local/sbin/kamailio[2660]: ERROR:core:db_check_table_version: invalid version 3 for table carrierfailureroute found, expected 2 (check table structure and table "version") Jun 25 18:42:34 sbci1pri /usr/local/sbin/kamailio[2660]: ERROR:carrierroute:carrierroute_db_init: during table version check. Jun 25 18:42:34 sbci1pri /usr/local/sbin/kamailio[2660]: ERROR:core:init_mod: failed to initialize module carrierroute Jun 25 18:42:34 sbci1pri /usr/local/sbin/kamailio[2660]: ERROR:core:main: error while initializing modules
Is there anything I have to do (appart from following the guidelines on http://kamailio.org/dokuwiki/doku.php/install:1.4.x-to-1.5.0)?
Thanks! Uriel
Sorry, tried that and I still get the same error.
I followed the procedures on http://kamailio.org/dokuwiki/doku.php/install:1.4.x-to-1.5.0 to upgrade the old database, maybe there is something missing that carrierroute module is expecting.
Can anyone confirm?
Jun 26 10:03:55 sbci1pri /usr/local/sbin/kamailio[4864]: ERROR:core:db_check_table_version: invalid version 2 for table carrierfailureroute found, expected 3 (check table structure and table "version") Jun 26 10:03:55 sbci1pri /usr/local/sbin/kamailio[4864]: ERROR:carrierroute:carrierroute_db_init: during table version check. Jun 26 10:03:55 sbci1pri /usr/local/sbin/kamailio[4864]: ERROR:core:init_mod: failed to initialize module carrierroute Jun 26 10:03:55 sbci1pri /usr/local/sbin/kamailio[4864]: ERROR:core:main: error while initializing modules
2009/6/25 Raúl Alexis Betancor Santana rabs@dimension-virtual.com
Here it goes:
acc 4 missed_calls 3 gw 9 lcr 2 domain 1 grp 2 re_grp 1 trusted 4 address 3 aliases 1004 location 1004 silo 5 dbaliases 1 uri 1 speed_dial 2 usr_preferences 2 subscriber 6 pdt 1 dialog 3 dispatcher 3 dialplan 1 presentity 3 active_watchers 9 watchers 3 xcap 3 pua 6 rls_presentity 0 rls_watchers 1 imc_rooms 1 imc_members 1 cpl 1 sip_trace 2 domainpolicy 2 carrierroute 3 carrierfailureroute 2 carrier_name 1 domain_name 1 userblacklist 1 globalblacklist 1 htable 1 purplemap 1
2009/6/26 Raúl Alexis Betancor Santana rabs@dimension-virtual.com
On Friday 26 June 2009 22:19:34 Uriel Rozenbaum wrote:
Here it goes:
carrierroute 3 carrierfailureroute 2
It look at it should do, umm .. you should activate DDL debug on you SQL server and check the SQL statement that kamailio is sending to the DB-server
Oki doki... how can I do that? I really don't know how to do it.
2009/6/26 Raúl Alexis Betancor Santana rabs@dimension-virtual.com
On Freitag, 26. Juni 2009, Uriel Rozenbaum wrote:
Hi Uriel,
this is the second time i get a report like this, even if the table versions looks correct. Do you still get the error about the mismatch in the table versions? Can you then please do a "mysqldump openser -u root -p > /tmp/openser.sql" and send me (off-list) the dump file? Then i can try to reproduce this on my machine.
Cheers,
Henning
-
Henning Westerholt -
Raúl Alexis Betancor Santana -
Uriel Rozenbaum