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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
