[OpenSIPS-Users] issues creating present table on trunk

[Liviu Chircu]

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 at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20150422/997b1903/attachment.htm>