Here,
sudo ldd /usr/local/sbin/sqlbox
/usr/local/sbin/sqlbox:
librt.so.1 => /usr/lib/librt.so.1 (0x80067e000)
libthr.so.3 => /lib/libthr.so.3 (0x800783000)
libxml2.so.5 => /usr/local/lib/libxml2.so.5 (0x80089b000)
libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x800ae6000)
libmysqlclient_r.so.16 => /usr/local/lib/mysql/libmysqlclient_r.so.16
(0x800ce0000)
libz.so.5 => /lib/libz.so.5 (0x800e58000)
libcrypt.so.5 => /lib/libcrypt.so.5 (0x800f6d000)
libm.so.5 => /lib/libm.so.5 (0x801086000)
libcrypto.so.6 => /lib/libcrypto.so.6 (0x8011a5000)
libssl.so.6 => /usr/lib/libssl.so.6 (0x80143f000)
libc.so.7 => /lib/libc.so.7 (0x801591000)
Thanks,
Aldo Zavala
24/7 (760).890.4221
----- Original Message -----
From: Nikos Balkanas
[mailto:nbalka...@gmail.com]
To: users@kannel.org, Aldo Zavala
[mailto:a...@cleartalk.net]
Sent: Tue, 27 Jul 2010 14:34:57 -0700
Subject:
Re: ERROR: MYSQL: can not connect to database!
> 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
> > >
> > >
> >
> >
>
>
