Hi! I'm trying sqlbox, and I can't get it to connect to a remote MySQL server... It's really strange...
I got "dlr-storage = mysql" with the same settings and it connects fine, but sqlbox does not... if I run a local MySQ, using localhost it works fine, but not with a remote one... Here's the error I get: 2007-11-14 08:58:06 [18604] [0] INFO: Added logfile `/var/log/kannel/sqlbox.log' with level `0'. 2007-11-14 08:58:06 [18604] [0] ERROR: MYSQL: can not connect to database! 2007-11-14 08:58:06 [18604] [0] ERROR: MYSQL: Can't connect to MySQL server on '10.10.10.2' (111) 2007-11-14 08:58:06 [18604] [0] PANIC: SQLBOX: MySQL: database pool has no connections! 2007-11-14 08:58:06 [18604] [0] PANIC: /usr/local/kannel/sbin/sqlbox(gw_panic+0x15b) [0x4248ab] 2007-11-14 08:58:06 [18604] [0] PANIC: /usr/local/kannel/sbin/sqlbox(sqlbox_init_mysql+0x34f) [0x40afdf] 2007-11-14 08:58:06 [18604] [0] PANIC: /usr/local/kannel/sbin/sqlbox(sqlbox_init_sql+0xb) [0x40bfbb] 2007-11-14 08:58:06 [18604] [0] PANIC: /usr/local/kannel/sbin/sqlbox(main+0x31f) [0x409dcf] 2007-11-14 08:58:06 [18604] [0] PANIC: /lib64/libc.so.6(__libc_start_main+0xf4) [0x3460c1d8a4] 2007-11-14 08:58:06 [18604] [0] PANIC: /usr/local/kannel/sbin/sqlbox [0x4099a9] Here's the conf: group = sqlbox id = sqlbox-db smsbox-id = smsbox bearerbox-host = localhost bearerbox-port = 13001 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 group = mysql-connection id = sqlbox-db host = 10.10.10.2 username = myUser password = myPass database = kannel max-connections = 1 And this is the conf for DLR which works fine: group = mysql-connection id = mydlr host = 10.10.10.2 username = myUser password = myPass database = kannel max-connections = 1 I even ran a tcpdump on the DB server, and I don't see packets arriving for the sqlbox connection... any ideas??? Thanks in advance, Juan PS: obviously connecting from the kannel host to the remote one via console works (same info as for DLRs which connects ok)
