If you are trying to connect SQLBox to another host make sure you have define port directive in your SQLBox configuration: …. host = 1.2.3.4 port = 3306 ….
Willy Mularto [email protected] On Mar 15, 2013, at 12:55 PM, Arturo SAnchez <[email protected]> wrote: > Hello All > > You know, I'm experimenting a weird situation. > I want to use sqlbox and connect to LAN DB but I think this is when sqlbox > crashes. > It's a simple remote host = 10.191.219.22X > I can connect from this machine using the mysql client, actually it uses the > same DB for dlr storage > Please let me know if someone has the same problem or how to solve it? > I already added it on /etc/hosts and nothing worked, only works on localhost > though. > > I reviewed sqlbox_mysql.c on struct server_type *sqlbox_init_mysql(Cfg* cfg) > but I don't see nothing weird, maybe is somewhere else that you can just > connect to local socket. > > Thanks in advance > > --------------------- backtrace here ----------- > bash-4.1# /usr/local/kannel/sbin/sqlbox -v 0 /etc/kannel/sqlbox.conf > 2013-03-15 05:47:16 [25770] [0] INFO: Debug_lvl = 0, log_file = <none>, > log_lvl = 0 > 2013-03-15 05:47:16 [25770] [0] DEBUG: Kannel sqlbox version `svn-r5031'. > Build `Mar 14 2013 23:42:51', compiler `4.4.7 20120313 (Red Hat 4.4.7-3)'. > System Linux, release 2.6.32-279.22.1.el6.x86_64, version #1 SMP Wed Feb 6 > 03:10:46 UTC 2013, machine x86_64. > Hostname ip-10-191-219-227.ec2.internal, IP 10.191.219.227. > Libxml version 2.7.6. > Using OpenSSL 1.0.0-fips 29 Mar 2010. > Compiled with MySQL 5.1.67, using MySQL 5.1.67. > Using native malloc. > > 2013-03-15 05:47:16 [25770] [0] INFO: Starting to log to file > /var/log/kannel/kannel-sqlbox.log level 0 > 2013-03-15 05:47:16 [25770] [0] INFO: Added logfile > `/var/log/kannel/kannel-sqlbox.log' with level `0'. > > > 2013-03-15 05:48:19 [25770] [0] ERROR: MYSQL: can not connect to database! > 2013-03-15 05:48:19 [25770] [0] ERROR: MYSQL: Can't connect to MySQL server > on '10.191.219.228' (110) > 2013-03-15 05:48:19 [25770] [0] PANIC: SQLBOX: MySQL: database pool has no > connections! > 2013-03-15 05:48:19 [25770] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(gw_backtrace+0xae) [0x4285ce] > 2013-03-15 05:48:19 [25770] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(gw_panic+0x145) [0x428725] > 2013-03-15 05:48:19 [25770] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(sqlbox_init_mysql+0x34c) [0x40be0c] > 2013-03-15 05:48:19 [25770] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(main+0x30d) [0x40b85d] > 2013-03-15 05:48:19 [25770] [0] PANIC: > /lib64/libc.so.6(__libc_start_main+0xfd) [0x7f2fd22b5cdd] > 2013-03-15 05:48:19 [25770] [0] PANIC: /usr/local/kannel/sbin/sqlbox() > [0x40a4f9]
