That fixed the 'hostname' related erros actually =) but it's still giving a "Segmentation fault" instead of a "Started thread 1 (sqlbox.c:sql_to_bearerbox)", please see my detailed debug log:
sudo /usr/local/sbin/sqlbox -v 0 /etc/sqlbox.conf 2010-07-27 16:14:04 [76029] [0] INFO: Debug_lvl = 0, log_file = <none>, log_lvl = 0 2010-07-27 16:14:04 [76029] [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 localhost, 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 16:14:04 [76029] [0] INFO: Starting to log to file /var/log/kannel/sqlbox.log level 0 2010-07-27 16:14:04 [76029] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2010-07-27 16:14:04 [76029] [0] INFO: MYSQL: Connected to server at 192.168.8.188. 2010-07-27 16:14:04 [76029] [0] INFO: MYSQL: server version 5.1.48, client version 5.1.48. Segmentation fault (core dumped) Question: Is there a special ./configure parameters for this kind of system? (FreeBSD amd64) ?? Thanks again! 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 13:56:06 -0700 Subject: Re: ERROR: MYSQL: can not connect to database! > 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 > > > > > >
