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