[SR-Users] Kamailio v3.2 problem with dialog module.

[Timo Reimann]

Hey Phillip,


Am 21.02.2012 um 07:50 schrieb Phillman25 Kyriacou:
> Thanks for your prompt response.
> 
> I realized what i did wrong now, i had followed the guide you specified below but i believe i may have entered the following command more than once:
> 
> INSERT INTO version (table_name, table_version) VALUES ('dialog_vars','1');
> 
> I found 4 entries in the mysql "version" table for dialog_vars. I then removed the 3 entries and left only one and this worked. Now everything is ok.

Glad you figured out what the problem was!


> Sorry to have troubled you and thank you for your support.

No worries -- by posting both the question and the answer you've done a great service to upcoming generations. ;)


Cheers,

--Timo



> On Mon, Feb 20, 2012 at 11:50 PM, Timo Reimann <sr at foo-lounge.de> wrote:
> Hey,
> 
> 
> Am 20.02.2012 um 15:10 schrieb Phillman25 Kyriacou:
> > After upgrading from V3.1.5 to V3.2. Kamailio crashes with the below error messages:
> >
> > Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [db.c:392]: invalid number of rows received: 4, dialog_vars
> 
> This one describes the actual error: "invalid number of rows received".
> 
> 
> > Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [db.c:419]: querying version for table dialog_vars
> > Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: dialog [dlg_db_handler.c:153]: error during dialog-vars version check.
> > Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: dialog [dialog.c:646]: failed to initialize the DB support
> > Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [sr_module.c:932]: init_mod(): Error while initializing module dialog (/usr/local/lib/kamailio/modules_k/dialog.so)
> 
> [snip!]
> 
> 
> > i realised that when i set the
> >
> > "modparam("dialog", "db_mode", 0)" kamailio starts fine, seems to be a problem connecting to the database.
> >
> >
> > Does anyone know what is wrong?
> 
> Did you possibly miss to follow the upgrade guide
> 
> http://sip-router.org/wiki/install/3.1.x-to-3.2.x
> 
> particularly the part describing the changes required to the MySQL database (given that you use MySQL)
> 
> http://sip-router.org/wiki/install/3.1.x-to-3.2.x#sql_commands
> 
> ?
> 
> Dialog variables were introduced in 3.2. As they are used by default once you enable db_mode, SIP-Router barks at you if missed generating the according tables. Catch up on this and you should be fine.
> 
> 
> HTH,
> 
> --Timo
>