Hi,
Have you tried to add the port definition in the mysql-connection group?
port = 3306
BR
----- Original Message -----
From: "Aldo Zavala" <a...@cleartalk.net>
To: <users@kannel.org>
Sent: Tuesday, July 27, 2010 8:14 PM
Subject: Re: ERROR: MYSQL: can not connect to database!
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
