[OpenSIPS-Users] open sips 1.9 issue

[Peter Zoltan Keresztes]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130318/66db5b4f/attachment.htm>