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
