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
