root@opensips.clvn.com.cn:/usr/local/opensips/sbin# ./opensipsdbctl create
mysql password for root:
info: test server charset
error 2003 (hy000): can't connect to mysql server on '192.168.0.18' (111)
error 2003 (hy000): can't connect to mysql server on '192.168.0.18' (111)
warning: failed to get the available and used character sets
解决方法
root@opensips.clvn.com.cn# vim /etc/mysql/my.cnf
#bind-address = 127.0.0.1
重新启动mysql
root@opensips.clvn.com.cn# service mysql restart
mysql stop/waiting
mysql start/running, process 24719
再次执行
root@opensips.clvn.com.cn:/usr/local/opensips/sbin# ./opensipsdbctl create
mysql password for root:
info: test server charset
info: creating database opensips ...
info: core opensips tables succesfully created.
install presence related tables? (y/n): y
info: creating presence tables into opensips ...
info: presence tables succesfully created.
install tables for imc cpl siptrace domainpolicy carrierroute userblacklist b2b registrant call_center? (y/n): y
info: creating extra tables into opensips ...
info: extra tables succesfully created.
问题解决