[OpenSIPS-Users] MySQL 5.6 and MySQL 5.7 Opensips 2.1.1

Роман Александрович Лукьянен Роман Александрович Лукьянен
Thu Nov 26 14:46:44 CET 2015


When you try to create a database using the "opensipsctl" the following
error:

*MySQL password for root:*
*INFO: creating presence tables into opensips ...*
*mysql: [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!*

This problem occurs when you use MySQL5.6 and MySQL5.7

How to create a base of presence?
Of course, this problem is solved by correcting
*/usr/share/opensips/mysql/presence-create.sql*, but would like to have
corrected this error developers



-- 
С уважением Лукьяненко Роман



-- 
С уважением Лукьяненко Роман
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20151126/86b1d32e/attachment.htm>


More information about the Users mailing list