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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[ 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 (Settings changed) 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 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

_______________________________________________
Devel mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/devel