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 <[email protected]> wrote: > No, as long as you using the new 1.9 database name in the db_url parameter. > > > 2013/3/18 Peter Zoltan Keresztes <[email protected]>: >> 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 <[email protected]> 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 [email protected] <[email protected]>: >>>> 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, [email protected] >>>> <[email protected]> >>>> 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 >>>>> <[email protected]> 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, "[email protected]" <[email protected]> >>>>>> 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 >>>>>> <[email protected]> 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 >>>>>>> [email protected] >>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Users mailing list >>>>>> [email protected] >>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Users mailing list >>>>>> [email protected] >>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>>> >>>>> >>>> >>>> >>>> _______________________________________________ >>>> Users mailing list >>>> [email protected] >>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
