[OpenSIPS-Users] Error creating presence tables with MySQL 5.7

[Liviu Chircu]

Hi, Pat!

A similar thread regarding this issue can be found here [1]

Long story short, you need to make sure your "sql_mode" (mysql> SELECT 
@@GLOBAL.sql_mode;) does not include STRICT_TRANS_TABLES.

Regards,

[1]: https://opensips.org/pipermail/users/2013-August/026565.html

Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com

On 19.11.2016 00:20, Pat Burke wrote:
> When running "opensipsdbctl create" I get the following error message.
>
> Install presence related tables? (y/n): y
> INFO: creating presence tables into opensips_2_2 ...
> mysql: [Warning] Using a password on the command line interface can be 
> insecure.
> ERROR 1101 (42000) at line 2: BLOB, TEXT, GEOMETRY or JSON column 
> 'extra_hdrs' can't have a default value
> ERROR: Failed to create presence tables!
>
> Regards,
> *Pat Burke*
>
>
>
>
> _______________________________________________
> 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/20161123/22623d25/attachment.htm>