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 -- С уважением Лукьяненко Роман -- С уважением Лукьяненко Роман
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
