[OpenSIPS-Users] open sips 1.9 issue
Peter Zoltan Keresztes
zozo6015 at gmail.com
Mon Mar 18 19:12:48 CET 2013
Hello,
One of the nodes of the mysql cluster was out of sync and this issue was because of it.
Thanks for all your helps.
Peter
On 18 Mar 2013, at 12:08, Peter Zoltan Keresztes <zozo6015 at gmail.com> wrote:
> Yes I am using the new database.
> All the fields you were talking about in your previous posts are there the version in the version table is also correct but when I start the opensips the error is still there.
>
> I am totally clueless and unless I will be able to make this work I will have to uninstall this and install the 1.8 which is working fine for me.
> Regards
> Peter
> On 18 Mar 2013, at 12:03, Laszlo <laszlo at voipfreak.net> wrote:
>
>> No, as long as you using the new 1.9 database name in the db_url parameter.
>>
>>
>> 2013/3/18 Peter Zoltan Keresztes <zozo6015 at gmail.com>:
>>> 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
>>>
>>>
>>> _______________________________________________
>>> 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
>
More information about the Users
mailing list