21 Feb
2012
21 Feb
'12
5:50 p.m.
Hi Timo
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.
Sorry to have troubled you and thank you for your support.
Regards
Phillip
On Mon, Feb 20, 2012 at 11:50 PM, Timo Reimann <sr(a)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