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 > >
