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

2016-11-23 Thread 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 OpenS

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

2016-11-18 Thread Pat Burke
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, GEOMETR