Hi Timo <div><br></div><div>Thanks for your prompt response.</div><div><br></div><div>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:</div>
<div><br></div><div><pre class="code sql" style="padding-top:0.5em;padding-right:0.5em;padding-bottom:0.5em;padding-left:0.5em;border-top-width:1px;border-right-width:1px;border-bottom-width:1px;border-left-width:1px;border-top-style:dashed;border-right-style:dashed;border-bottom-style:dashed;border-left-style:dashed;border-top-color:rgb(140,172,187);border-right-color:rgb(140,172,187);border-bottom-color:rgb(140,172,187);border-left-color:rgb(140,172,187);background-color:rgb(255,255,255);line-height:1.1em;font-size:x-small;overflow-x:auto;overflow-y:auto">
<span class="kw1" style="color:rgb(177,177,0)">INSERT</span> <span class="kw1" style="color:rgb(177,177,0)">INTO</span> version <span class="br0" style="color:rgb(102,204,102)">(</span>table_name<span class="sy0" style="color:rgb(102,204,102)">,</span> table_version<span class="br0" style="color:rgb(102,204,102)">)</span> <span class="kw1" style="color:rgb(177,177,0)">VALUES</span> <span class="br0" style="color:rgb(102,204,102)">(</span><span class="st0" style="color:rgb(255,0,0)">'dialog_vars'</span><span class="sy0" style="color:rgb(102,204,102)">,</span><span class="st0" style="color:rgb(255,0,0)">'1'</span><span class="br0" style="color:rgb(102,204,102)">)</span>;</pre>
<div><br></div><div>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.</div><div>Sorry to have troubled you and thank you for your support.</div>
<div><br></div><div>Regards</div><div>Phillip</div><div><br></div><br><div class="gmail_quote">On Mon, Feb 20, 2012 at 11:50 PM, Timo Reimann <span dir="ltr"><<a href="mailto:sr@foo-lounge.de">sr@foo-lounge.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hey,<br>
<br>
<br>
Am 20.02.2012 um 15:10 schrieb Phillman25 Kyriacou:<br>
<div class="im">> After upgrading from V3.1.5 to V3.2. Kamailio crashes with the below error messages:<br>
><br>
> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [db.c:392]: invalid number of rows received: 4, dialog_vars<br>
<br>
</div>This one describes the actual error: "invalid number of rows received".<br>
<div class="im"><br>
<br>
> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [db.c:419]: querying version for table dialog_vars<br>
> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: dialog [dlg_db_handler.c:153]: error during dialog-vars version check.<br>
> Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: dialog [dialog.c:646]: failed to initialize the DB support<br>
> 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)<br>
<br>
</div>[snip!]<br>
<div class="im"><br>
<br>
> i realised that when i set the<br>
><br>
> "modparam("dialog", "db_mode", 0)" kamailio starts fine, seems to be a problem connecting to the database.<br>
><br>
><br>
> Does anyone know what is wrong?<br>
<br>
</div>Did you possibly miss to follow the upgrade guide<br>
<br>
<a href="http://sip-router.org/wiki/install/3.1.x-to-3.2.x" target="_blank">http://sip-router.org/wiki/install/3.1.x-to-3.2.x</a><br>
<br>
particularly the part describing the changes required to the MySQL database (given that you use MySQL)<br>
<br>
<a href="http://sip-router.org/wiki/install/3.1.x-to-3.2.x#sql_commands" target="_blank">http://sip-router.org/wiki/install/3.1.x-to-3.2.x#sql_commands</a><br>
<br>
?<br>
<br>
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.<br>
<br>
<br>
HTH,<br>
<br>
--Timo</blockquote></div><br></div>