21 Feb
2012
21 Feb
'12
5:56 p.m.
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(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