[OpenSIPS-Devel] [ opensips-Bugs-2580101 ] Initial database create / startup fails

[SourceForge.net]

Bugs item #2580101, was opened at 2009-02-08 17:36
Message generated for change (Comment added) made by norm_brandinger
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2580101&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Norm Brandinger (norm_brandinger)
Assigned to: Nobody/Anonymous (nobody)
Summary: Initial database create / startup  fails

Initial Comment:
Using MySQL. 

Command: opensipsdbctl create

Following error is produced:

Creating core table: avpops
Creating core table: auth_db
Creating core table: pdt
Creating core table: dialog
ERROR 1074 (42000) at line 2: Column length too big for column 'caller_route_set' (max = 255); use BLOB or TEXT instead
ERROR: Creating core tables failed!

----------------------------------------------------------------------

>Comment By: Norm Brandinger (norm_brandinger)
Date: 2009-02-08 18:13

Message:
It looks like another module is referring to VERSION 6 of the subscriber
table: uridb_mod.c

----------------------------------------------------------------------

Comment By: Norm Brandinger (norm_brandinger)
Date: 2009-02-08 17:57

Message:
The table version issue was created from:  authdb_mod.c

----------------------------------------------------------------------

Comment By: Norm Brandinger (norm_brandinger)
Date: 2009-02-08 17:55

Message:
The following error is produced on first startup after a fresh DB install:

ERROR:core:db_check_table_version: invalid version 7 for table subscriber
found, expected 6
ERROR:uri_db:mod_init: Invalid table version.

----------------------------------------------------------------------

Comment By: Norm Brandinger (norm_brandinger)
Date: 2009-02-08 17:40

Message:
siptrace table has a similar problem during creation:

Creating extra table: cpl
Creating extra table: siptrace
ERROR 1074 (42000) at line 2: Column length too big for column 'callid'
(max = 255); use BLOB or TEXT instead
ERROR: Creating extra tables failed!


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2580101&group_id=232389