#87 Initial database create / startup fails

trunk
closed-fixed
modules (454)
9
2009-02-09
2009-02-08
No

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!

Discussion

  • Norm Brandinger

    Norm Brandinger - 2009-02-08
    • summary: Inital database create fails --> Initial database create fails
     
  • Norm Brandinger

    Norm Brandinger - 2009-02-08

    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!

     
  • Norm Brandinger

    Norm Brandinger - 2009-02-08

    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.

     
  • Norm Brandinger

    Norm Brandinger - 2009-02-08
    • summary: Initial database create fails --> Initial database create / startup fails
     
  • Norm Brandinger

    Norm Brandinger - 2009-02-08

    The table version issue was created from: authdb_mod.c

     
  • Norm Brandinger

    Norm Brandinger - 2009-02-08

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

     
  • Bogdan-Andrei Iancu

    • assigned_to: nobody --> bogdan_iancu
    • priority: 5 --> 9
    • status: open --> open-accepted
     
  • Bogdan-Andrei Iancu

    • status: open-accepted --> closed-fixed
     
  • Bogdan-Andrei Iancu

    Hi Norm,

    Thank you for the report - all the issues should be fixed by now. Please update and test.

    Best regards,
    Bogdan

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks