Hi,
Please post output of:
ldd /usr/local/sbin/sqlbox
BR,
Nikos
----- Original Message -----
From: "Aldo Zavala" <a...@cleartalk.net>
To: "Nikos Balkanas" <nbalka...@gmail.com>; <users@kannel.org>
Sent: Wednesday, July 28, 2010 12:21 AM
Subject: Re: ERROR: MYSQL: can not connect to database!
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
>
>
