Your connection string must be wrong, or there's some issue preventing the sqlbox process to connect to the remote host.
I'd check the firewall rules. Another explanation could be related to selinux if you're running on a RHEL/CentOS box and have it enabled. Anyhow, please post your sqlbox configuration (hide the host/user/password). Regards, Alex On Sun, May 23, 2010 at 12:57 PM, Barry Murphy <[email protected]> wrote: > Hi, > > Not sure if this is the right place to post, but hoping it is, if not > please reply offlist direct to me. I've just setup SqlBOX and managed to > have it connect to a localhost mysql server, however when I configure it to > connect to a remote system it isn't working. My Kannel is using the same > MySQL variables though its not complaining, even though it's not actually > inserting anything into the dlr so I'm not 100% sure if it is working or > not. A tcpdump on the remote sql server does show connection attempts, so I > know the TCP is working, the only think I can think of is that sqlbox is > failing. if I use CLI from the host to the remote sql host I can connect, > i.e. 'mysql -h remote.host.com -u -p database', this works fine. > > Any suggestions or ideas would be appreciated. I'd prefer not having to > run so many mysql hosts and rather use our central one that has grunty > CPU's, Disks and backups. > > smsc:/etc/kannel# /usr/local/kannel/sbin/sqlbox > 2010-05-23 22:53:14 [2015] [0] INFO: Debug_lvl = -1, log_file = <none>, > log_lvl = 0 > 2010-05-23 22:53:14 [2015] [0] DEBUG: Kannel sqlbox version `1.4.3'. > Build `May 23 2010 06:03:57', compiler `4.1.2 20061115 (prerelease) > (Debian 4.1.1-21)'. > System Linux, release 2.6.18.8.xs5.5.0.13.442, version #1 SMP Wed Nov 11 > 12:01:55 UTC 2009, machine i686. > Hostname localhost, IP 127.0.0.1. > Libxml version 2.7.7. > Compiled with MySQL 5.0.32, using MySQL 5.0.51a. > Using native malloc. > > 2010-05-23 22:53:14 [2015] [0] INFO: Starting to log to file > /var/log/kannel/kannel-sqlbox.log level 0 > 2010-05-23 22:53:14 [2015] [0] INFO: Added logfile > `/var/log/kannel/kannel-sqlbox.log' with level `0'. > 2010-05-23 22:53:14 [2015] [0] ERROR: MYSQL: can not connect to database! > 2010-05-23 22:53:14 [2015] [0] ERROR: MYSQL: Can't connect to MySQL server > on '120.131.1.2' (111) > 2010-05-23 22:53:14 [2015] [0] PANIC: SQLBOX: MySQL: database pool has no > connections! > 2010-05-23 22:53:14 [2015] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(gw_panic+0xdc) [0x806c96c] > 2010-05-23 22:53:14 [2015] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(sqlbox_init_mysql+0x3bf) [0x8050a6f] > 2010-05-23 22:53:14 [2015] [0] PANIC: > /usr/local/kannel/sbin/sqlbox(main+0x390) [0x804f660] > 2010-05-23 22:53:14 [2015] [0] PANIC: > /lib/libc.so.6(__libc_start_main+0xe5) [0xb7ad5455] > 2010-05-23 22:53:14 [2015] [0] PANIC: /usr/local/kannel/sbin/sqlbox > [0x804f191] > smsc:/etc/kannel# > > Thanks > Barry > >
