Dear List<div><br></div><div>After upgrading from V3.1.5 to V3.2. Kamailio crashes with the below error messages:</div><div><br></div><div><div>Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [db.c:392]: invalid number of rows received: 4, dialog_vars</div>
<div>Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: <core> [db.c:419]: querying version for table dialog_vars</div><div>Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: dialog [dlg_db_handler.c:153]: error during dialog-vars version check.</div>
<div>Feb 20 16:43:59 sipproxy /usr/local/sbin/kamailio[11705]: ERROR: dialog [dialog.c:646]: failed to initialize the DB support</div><div>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)</div>
</div><div><br></div><div><br></div><div><br></div><div>My dialog paramaters are as follows:</div><div><br></div><div><div># ----------------- DIALOG MODULE PARAMETERS----------------------------------#</div><div>modparam("dialog", "enable_stats", 1)</div>
<div>modparam("dialog", "hash_size", 4096)</div><div>modparam("dialog", "rr_param", "did")</div><div>modparam("dialog", "dlg_flag", 4)</div><div>modparam("dialog", "timeout_avp", "$avp(i:10)")</div>
<div>modparam("dialog", "default_timeout", 21600)</div><div>modparam("dialog", "dlg_extra_hdrs", "NULL")</div><div>modparam("dialog", "dlg_match_mode", 1)</div>
<div>modparam("dialog", "detect_spirals", 1)</div><div>modparam("dialog", "db_url", "mysql://openser:openserrw@localhost/openser")</div><div>modparam("dialog", "db_mode", 1)</div>
<div>modparam("dialog", "db_update_period", 60)</div><div>modparam("dialog", "db_fetch_rows", 500)</div><div>modparam("dialog", "table_name", "dialog")</div>
<div>modparam("dialog", "from_uri_column", "from_uri")</div><div>modparam("dialog", "from_tag_column", "from_tag")</div><div>modparam("dialog", "to_uri_column", "to_uri")</div>
<div>modparam("dialog", "to_tag_column", "to_tag")</div><div>modparam("dialog", "h_id_column", "hash_id")</div><div>modparam("dialog", "h_entry_column", "hash_entry")</div>
<div>modparam("dialog", "state_column", "state")</div><div>modparam("dialog", "start_time_column", "start_time")</div><div>modparam("dialog", "timeout_column", "timeout")</div>
<div>modparam("dialog", "sflags_column", "sflags")</div><div>modparam("dialog", "bridge_controller", "<a href="mailto:sip%3Acontroller@kamailio.org">sip:controller@kamailio.org</a>")</div>
<div>modparam("dialog", "default_timeout", 7200)</div></div><div><br></div><div><br></div><div><br></div><div><br></div><div>i realised that when i set the </div><div><br></div><div>"modparam("dialog", "db_mode", 0)" kamailio starts fine, seems to be a problem connecting to the database.</div>
<div><br></div><div><br></div><div><br></div><div>Does anyone know what is wrong?</div><div><br></div><div>Thanking you in advance </div><div><br></div><div>Phillip</div><div><br></div>