Hi Tito,
A quick read on the topic shows that the "sql_mode" (SHOW VARIABLES LIKE
'sql_mode';) has been changed from the default of "", to include this
option: STRICT_TRANS_TABLES.
If STRICT_TRANS_TABLES is enabled, BLOB/TEXT cols can't have default
values :(
So either change the "sql_mode" or edit
"/usr/local/share/opensips/mysql/presence-create.sql"
Best regards,
Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com
On 22.04.2015 17:14, Tito Cumpen wrote:
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
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
