Sorry, I forgot to post the sqlbox.conf
group = sqlbox id = sqlbox-db smsbox-id = sqlbox #global-sender = "" bearerbox-host = localhost bearerbox-port = 13009 smsbox-port = 13005 smsbox-port-ssl = false sql-log-table = sent_sms sql-insert-table = send_sms log-file = "/var/log/kannel/sqlbox.log" log-level = 0 #ssl-client-certkey-file = "" #ssl-server-cert-file = "" #ssl-server-key-file = "" #ssl-trusted-ca-file = "" group = mysql-connection id = sqlbox-db host = 192.168.0.11 username = root password = root database = kannel Thanks, Aldo Zavala ----- Original Message ----- From: Aldo Zavala [mailto:a...@cleartalk.net] To: users@kannel.org Sent: Tue, 27 Jul 2010 12:13:08 -0700 Subject: ERROR: MYSQL: can not connect to database! > Hi, I am setting up Kannel svn-r4833 with sqlbox and I am getting this > message, please note that MySQL server is in a separated server than Kannel > server. > > - My OS is FreeBSD 8.1 Release amd64 > > [1111] [0] ERROR: MYSQL: can not connect to database! > [1111] [0] ERROR: MYSQL: Can't connect to MySQL server on '192.168.0.11' > (61) > [1111] [0] PANIC: SQLBOX: MySQL: database pool has no connections! > > Note 2: I can access the MySQL server from Kannel server by > /usr/local/bin/mysql -h 192.168.0.11 -uroot -p > > any help is really appreciated!! > > Thanks in advance! > > Aldo Zavala