[OpenSIPS-Users] open sips 1.9 issue

[Laszlo]

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
>