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

[Timo Reimann]

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