Hi,
Add server name in /etc/hosts and retry. If problem persists please repost
detailed logs.
BR,
Nikos
----- Original Message -----
From: "Aldo Zavala" <a...@cleartalk.net>
To: "Nikos Balkanas" <nbalka...@gmail.com>; <users@kannel.org>
Sent: Tuesday, July 27, 2010 10:37 PM
Subject: Re: ERROR: MYSQL: can not connect to database!
I added the "port = 3306" directive in sqlbox.conf and this is the full
detail log that I get:
------------------------------------------------------------------------------------
sudo /usr/local/sbin/sqlbox -v 0 /etc/sqlbox.conf
2010-07-27 14:34:39 [5455] [0] ERROR: Error while gw_gethostbyname occurs.
2010-07-27 14:34:39 [5455] [0] ERROR: System error 1: Operation not
permitted
2010-07-27 14:34:39 [5455] [0] ERROR: Can't find out official hostname for
this host, using `kannelbsd.cleartalk.net' instead.
2010-07-27 14:34:39 [5455] [0] INFO: Debug_lvl = 0, log_file = <none>,
log_lvl = 0
2010-07-27 14:34:39 [5455] [0] DEBUG: Kannel sqlbox version `svn-r4833'.
Build `Jul 26 2010 16:54:17', compiler `4.2.1 20070719 [FreeBSD]'.
System FreeBSD, release 8.1-RELEASE, version FreeBSD 8.1-RELEASE #0: Mon Jul
19 02:36:49 UTC 2010
r...@mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC, machine amd64.
Hostname kannelbsd.cleartalk.net, IP 127.0.0.1.
Libxml version 2.7.7.
Using OpenSSL 0.9.8n 24 Mar 2010.
Compiled with MySQL 5.1.48, using MySQL 5.1.48.
Using native malloc.
2010-07-27 14:34:39 [5455] [0] INFO: Starting to log to file
/var/log/kannel/sqlbox.log level 0
2010-07-27 14:34:39 [5455] [0] INFO: Added logfile
`/var/log/kannel/sqlbox.log' with level `0'.
2010-07-27 14:34:39 [5455] [0] INFO: MYSQL: Connected to server at
192.168.0.11.
2010-07-27 14:34:39 [5455] [0] INFO: MYSQL: server version 5.1.48, client
version 5.1.48.
Segmentation fault (core dumped)
And this is the detailed log of a sqlbox.conf without the "port = 3306"
directive.
------------------------------------------------------------------------------------
2010-07-27 14:35:35 [5459] [0] INFO: Starting to log to file
/var/log/kannel/sqlbox.log level 0
2010-07-27 14:35:35 [5459] [0] INFO: Added logfile
`/var/log/kannel/sqlbox.log' with level `0'.
2010-07-27 14:35:35 [5459] [0] ERROR: MYSQL: can not connect to database!
2010-07-27 14:35:35 [5459] [0] ERROR: MYSQL: Can't connect to MySQL server
on '192.168.0.11' (61)
2010-07-27 14:35:35 [5459] [0] PANIC: SQLBOX: MySQL: database pool has no
connections!
Thanks,
Aldo Zavala
----- Original Message -----
From: Nikos Balkanas
[mailto:nbalka...@gmail.com]
To: users@kannel.org, Aldo Zavala
[mailto:a...@cleartalk.net]
Sent: Tue, 27 Jul 2010 12:32:47 -0700
Subject:
Re: ERROR: MYSQL: can not connect to database!
Hi,
Please repost relevant sqlbox logs in maximum detail.
BR,
Nikos
----- Original Message -----
From: "Aldo Zavala" <a...@cleartalk.net>
To: <users@kannel.org>
Sent: Tuesday, July 27, 2010 10: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
