[OpenSIPS-Users] issues creating present table on trunk

gsu12797 donald at ipcomms.net
Thu Feb 23 09:38:52 EST 2017


thanks for the thread.   Just wanted to post what i did to fix this error.

Hope it help someone. 



mysql> SET GLOBAL sql_mode = '';
Query OK, 0 rows affected, 1 warning (0.00 sec)


root at opensip:/sbin# opensipsdbctl create
MySQL password for root:
INFO: test server charset
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
INFO: creating database opensips ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
INFO: Using table engine InnoDB.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
INFO: Core OpenSIPS tables successfully created.
Install presence related tables? (y/n): y
INFO: creating presence tables into opensips ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
INFO: Presence tables successfully created.
Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist
b2b cachedb_sql registrant call_center fraud_detection emergency? (y/n): y
INFO: creating extra tables into opensips ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
INFO: Extra tables successfully created.




--
View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/issues-creating-present-table-on-trunk-tp7596682p7606159.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.



More information about the Users mailing list