Yes, but you forgot the main thing: Once you crash type:
where
BR,
Nikos
----- Original Message -----
From: "Aldo Zavala" <[email protected]>
To: "Nikos Balkanas" <[email protected]>; <[email protected]>
Sent: Wednesday, July 28, 2010 2:07 AM
Subject: Re: ERROR: MYSQL: can not connect to database!
Sorry, I have never used gdb before, is this the output you need to see?
I added this line "CFLAGS = -g -Wall" to /etc/make.conf, then recompiled
sqlbox with no ./configure arguments and using gmake, then:
sudo gdb
(gdb) exec-file /usr/local/sbin/sqlbox
(gdb) run /etc/sqlbox.conf
Starting program: /usr/local/sbin/sqlbox /etc/sqlbox.conf
(no debugging symbols found)...(no debugging symbols found)...[New LWP
100064]
(no debugging symbols found)...(no debugging symbols found)...(no debugging
symbols found)...(no debugging symbols found)...(no debugging symbols
found)...(no debugging symbols found)...(no debugging symbols found)...(no
debugging symbols found)...(no debugging symbols found)...(no debugging
symbols found)...[New Thread 8018041c0 (LWP 100064)]
2010-07-27 18:05:05 [6300] [0] INFO: Debug_lvl = -1, log_file = <none>,
log_lvl = 0
2010-07-27 18:05:05 [6300] [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 18:05:05 [6300] [0] INFO: Starting to log to file
/var/log/kannel/sqlbox.log level 0
2010-07-27 18:05:05 [6300] [0] INFO: Added logfile
`/var/log/kannel/sqlbox.log' with level `0'.
2010-07-27 18:05:05 [6300] [0] INFO: MYSQL: Connected to server at
192.168.8.188.
2010-07-27 18:05:05 [6300] [0] INFO: MYSQL: server version 5.1.48, client
version 5.1.48.
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 8018041c0 (LWP 100064)]
0x0000000000405556 in ?? ()
Thanks,
Aldo Zavala
----- Original Message -----
From: Nikos Balkanas
[mailto:[email protected]]
To: [email protected], Aldo Zavala
[mailto:[email protected]]
Sent: Tue, 27 Jul 2010 15:43:59 -0700
Subject:
Re: ERROR: MYSQL: can not connect to database!
I didn't tell you to analyze the core, but rather to run sqlbox from
within
gdb. Assuming this is the latest svn, please repost after giving the
command
in gdb:
where
to show the stack trace. How do you run sqlbox? Do you specify the
configuration file?
BR,
Nikos
----- Original Message -----
From: "Aldo Zavala" <[email protected]>
To: "Nikos Balkanas" <[email protected]>; <[email protected]>
Sent: Wednesday, July 28, 2010 1:36 AM
Subject: Re: ERROR: MYSQL: can not connect to database!
here the gdb output:
$ sudo gdb /usr/local/sbin/sqlbox sqlbox.core
GNU gdb 6.1.1 [FreeBSD]
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you
are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for
details.
This GDB was configured as "amd64-marcel-freebsd"...
Core was generated by `sqlbox'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/lib/librt.so.1...done.
Loaded symbols for /usr/lib/librt.so.1
Reading symbols from /lib/libthr.so.3...done.
Loaded symbols for /lib/libthr.so.3
Reading symbols from /usr/local/lib/libxml2.so.5...done.
Loaded symbols for /usr/local/lib/libxml2.so.5
Reading symbols from /usr/local/lib/libiconv.so.3...done.
Loaded symbols for /usr/local/lib/libiconv.so.3
Reading symbols from /usr/local/lib/mysql/libmysqlclient_r.so.16...done.
Loaded symbols for /usr/local/lib/mysql/libmysqlclient_r.so.16
Reading symbols from /lib/libz.so.5...done.
Loaded symbols for /lib/libz.so.5
Reading symbols from /lib/libcrypt.so.5...done.
Loaded symbols for /lib/libcrypt.so.5
Reading symbols from /lib/libm.so.5...done.
Loaded symbols for /lib/libm.so.5
Reading symbols from /usr/local/lib/libcrypto.so.7...done.
Loaded symbols for /usr/local/lib/libcrypto.so.7
Reading symbols from /usr/local/lib/libssl.so.7...done.
Loaded symbols for /usr/local/lib/libssl.so.7
Reading symbols from /lib/libc.so.7...done.
Loaded symbols for /lib/libc.so.7
Reading symbols from /libexec/ld-elf.so.1...done.
Loaded symbols for /libexec/ld-elf.so.1
#0 0x0000000000405556 in main (argc=Variable "argc" is not available.
) at sqlbox.c:704
704 gw_sql_enter(cfg);
[New Thread 8018041c0 (LWP 100109)]
(gdb)
many 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 15:14:08 -0700
Subject:
Re: ERROR: MYSQL: can not connect to database!
> Sorry, you will have to go with gdb. Rebuild everything with debug
> flags:
> CFLAGS = -g -Wall
> and run through gdb.
>
> BR,
> Nikos
>
> ----- Original Message -----
> From: "Aldo Zavala" <[email protected]>
> To: "Nikos Balkanas" <[email protected]>; <[email protected]>
> Sent: Wednesday, July 28, 2010 12:39 AM
> Subject: Re: ERROR: MYSQL: can not connect to database!
>
>
> 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:[email protected]]
> To: [email protected], Aldo Zavala
> [mailto:[email protected]]
> 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" <[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
> > > >
> > > >
> > >
> > >
> >
> >
>
>
