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

[SourceForge.net]

Bugs item #2580101, was opened at 2009-02-08 19:36
Message generated for change (Settings changed) made by bogdan_iancu
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: Accepted
>Priority: 9
Private: No
Submitted By: Norm Brandinger (norm_brandinger)
>Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
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 20: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 19:57

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

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

Comment By: Norm Brandinger (norm_brandinger)
Date: 2009-02-08 19: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 19: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