#87 Initial database create / startup fails

[Norm Brandinger]

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!

[Norm Brandinger]

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]

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]

The table version issue was created from: authdb_mod.c

[Norm Brandinger]

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

[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