[OpenSIPS-Users] open sips 1.9 issue

[Peter Zoltan Keresztes]

Does it have anything to do with the dialog part of the configuration?

# dialog
modparam('dialog', 'db_url', 'mysql://root:sp110q@db/votosips_pp')
modparam('dialog', 'dlg_match_mode', 1)
modparam('dialog', 'db_mode', 2)

Regards,
Peter
On 18 Mar 2013, at 11:46, Laszlo <laszlo at voipfreak.net> wrote:

> Also check the table schema of the dialog module, see
> dialog-create.sql under /scripts/mysql
> There are differences between 1.8 and 1.9.
> 
> dlg_id BIGINT(10) UNSIGNED PRIMARY KEY NOT NULL was removed
> 
> id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL
> hash_entry INT(10) UNSIGNED NOT NULL
> hash_id INT(10) UNSIGNED NOT NULL
> 
> was added.
> 
> plus there is a new index:
> CREATE INDEX hash_idx ON dialog (hash_entry, hash_id);
> 
> And in the version table, the table_version is now 8.
> 
> -Laszlo
> 
> 
> 2013/3/18 qasimakhan at gmail.com <qasimakhan at gmail.com>:
>> Also since you copied script from 1.8 you should consider going through this
>> document.
>> 
>> http://www.opensips.org/Resources/DocsMigration180to190
>> 
>> -Qasim
>> 
>> 
>> On Mon, Mar 18, 2013 at 2:34 PM, qasimakhan at gmail.com <qasimakhan at gmail.com>
>> wrote:
>>> 
>>> Set debug level to 6 and then send the logs again.
>>> 
>>> -Qasim
>>> 
>>> 
>>> On Mon, Mar 18, 2013 at 2:14 PM, Peter Zoltan Keresztes
>>> <zozo6015 at gmail.com> wrote:
>>>> 
>>>> Yes, the table/DB name is correct. the same as in config.h in the
>>>> sources.
>>>> #define VERSION_TABLE     "version"             /*!< Table holding
>>>> versions of other opensips tables */
>>>> #define VERSION_COLUMN    "table_version"       /*!< Column name for the
>>>> version value in version table */
>>>> #define TABLENAME_COLUMN  "table_name"          /*!< Column name of the
>>>> table name column in the version table */
>>>> 
>>>> mysql> describe version;
>>>> +---------------+------------------+------+-----+---------+-------+
>>>> | Field         | Type             | Null | Key | Default | Extra |
>>>> +---------------+------------------+------+-----+---------+-------+
>>>> | table_name    | char(32)         | NO   | PRI | NULL    |       |
>>>> | table_version | int(10) unsigned | NO   |     | 0       |       |
>>>> +---------------+------------------+------+-----+---------+-------+
>>>> 2 rows in set (0.00 sec)
>>>> 
>>>> 
>>>> On 18 Mar 2013, at 08:08, "qasimakhan at gmail.com" <qasimakhan at gmail.com>
>>>> wrote:
>>>> 
>>>> Have you confirmed that table/DB name is correct? You can verify your
>>>> version table from config.h in your sources.
>>>> 
>>>> -Qasim
>>>> 
>>>> On Sun, Mar 17, 2013 at 10:32 PM, Peter Zoltan Keresztes
>>>> <zozo6015 at gmail.com> wrote:
>>>>> 
>>>>> Hello,
>>>>> 
>>>>> I have installed an opensips 1.9
>>>>> I have the configuration copied from an 1.8 setup created a brand new
>>>>> database  when I start it I am getting the following errors:
>>>>> Mar 17 09:56:35 freya /usr/local/sbin/opensips[434]:
>>>>> ERROR:core:db_check_table_version: invalid version 0 for table dialog found,
>>>>> expected 8
>>>>> Mar 17 09:56:35 freya /usr/local/sbin/opensips[434]:
>>>>> ERROR:dialog:init_dlg_db: error during table version check.
>>>>> Mar 17 09:56:35 freya /usr/local/sbin/opensips[434]:
>>>>> ERROR:dialog:mod_init: failed to initialize the DB support
>>>>> Mar 17 09:56:35 freya /usr/local/sbin/opensips[434]:
>>>>> ERROR:core:init_mod: failed to initialize module dialog
>>>>> Mar 17 09:56:35 freya /usr/local/sbin/opensips[434]: ERROR:core:main:
>>>>> error while initializing modules
>>>>> 
>>>>> The error is telling about invalid version of the dialog table however
>>>>> if I check the version table the dialog has the value 8 as it supposed to
>>>>> have it.
>>>>> 
>>>>> Thanks
>>>>> Peter
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>> 
>>>> 
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>> 
>>>> 
>>>> 
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>> 
>>> 
>> 
>> 
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> 
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users