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 <las...@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 <zozo6...@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 <las...@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 qasimak...@gmail.com <qasimak...@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, qasimak...@gmail.com >>>> <qasimak...@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 >>>>> <zozo6...@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, "qasimak...@gmail.com" <qasimak...@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 >>>>>> <zozo6...@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@lists.opensips.org >>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Users mailing list >>>>>> Users@lists.opensips.org >>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Users mailing list >>>>>> Users@lists.opensips.org >>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>>> >>>>> >>>> >>>> >>>> _______________________________________________ >>>> Users mailing list >>>> Users@lists.opensips.org >>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>> >>> _______________________________________________ >>> Users mailing list >>> Users@lists.opensips.org >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users