Hi,
Please post output of:
ldd /usr/local/sbin/sqlbox
BR,
Nikos
----- Original Message -----
From: "Aldo Zavala" <[email protected]>
To: "Nikos Balkanas" <[email protected]>; <[email protected]>
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
[email protected]:/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:[email protected]]
To: [email protected], Aldo Zavala
[mailto:[email protected]]
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" <[email protected]>
> To: "Nikos Balkanas" <[email protected]>; <[email protected]>
> 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
> [email protected]:/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:[email protected]]
> To: [email protected], Aldo Zavala
> [mailto:[email protected]]
> 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" <[email protected]>
> > To: <[email protected]>
> > 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:[email protected]]
> > To: [email protected]
> > 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
> >
> >
>
>
