[OpenSIPS-Users] issues creating present table on trunk

Tito Cumpen tito at xsvoce.com
Wed Apr 22 16:14:43 CEST 2015


Hello group,

I am having issues creating the presence tables via opensipsdbctl create
using the trunk version of opensips. Here is the error :

opensipsdbctl create

MySQL password for root:

INFO: test server charset

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

INFO: creating database opensips ...

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

Warning: Using a password on the command line interface can be insecure.

INFO: Core OpenSIPS tables succesfully created.

INFO: creating presence tables into opensips ...

Warning: Using a password on the command line interface can be insecure.

ERROR 1101 (42000) at line 2: BLOB/TEXT column 'extra_hdrs' can't have a
default value

ERROR: Failed to create presence tables!

 I am using  mysql  Ver 14.14 Distrib 5.6.24, for Linux (x86_64) using
EditLine wrapper
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150422/a88cbef8/attachment-0001.htm>


More information about the Users mailing list