Dear List
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 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)
My dialog paramaters are as follows:
# ----------------- DIALOG MODULE PARAMETERS----------------------------------# modparam("dialog", "enable_stats", 1) modparam("dialog", "hash_size", 4096) modparam("dialog", "rr_param", "did") modparam("dialog", "dlg_flag", 4) modparam("dialog", "timeout_avp", "$avp(i:10)") modparam("dialog", "default_timeout", 21600) modparam("dialog", "dlg_extra_hdrs", "NULL") modparam("dialog", "dlg_match_mode", 1) modparam("dialog", "detect_spirals", 1) modparam("dialog", "db_url", "mysql://openser:openserrw@localhost/openser") modparam("dialog", "db_mode", 1) modparam("dialog", "db_update_period", 60) modparam("dialog", "db_fetch_rows", 500) modparam("dialog", "table_name", "dialog") modparam("dialog", "from_uri_column", "from_uri") modparam("dialog", "from_tag_column", "from_tag") modparam("dialog", "to_uri_column", "to_uri") modparam("dialog", "to_tag_column", "to_tag") modparam("dialog", "h_id_column", "hash_id") modparam("dialog", "h_entry_column", "hash_entry") modparam("dialog", "state_column", "state") modparam("dialog", "start_time_column", "start_time") modparam("dialog", "timeout_column", "timeout") modparam("dialog", "sflags_column", "sflags") modparam("dialog", "bridge_controller", "sip:controller@kamailio.org") modparam("dialog", "default_timeout", 7200)
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?
Thanking you in advance
Phillip