Hi, You must set the database port if you are connecting to an external database. Otherwise sqlbox always tries to connect using unix socket.
BR Cezary -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Barry Murphy Sent: 23 May 2010 12:15 To: Alejandro Guerrieri Cc: Users Subject: Re: sqlbox I'm running debian lenny on both sides, though the side with sqlbox is version 5, so I wonder if it's because of a different type of auth method or something... As I mention if I use CLI it works fine from the SQLBox to the Actual mysql server, but the other way around it doesnt. Kannel: group = mysql-connection id = mydlr host = 10.10.1.1 username = 1123 password = 1123 database = 1123 max-connections = 1 group = dlr-db id = mydlr table = dlr field-smsc = smsc field-timestamp = ts field-destination = destination field-source = source field-service = service field-url = url field-mask = mask field-status = status field-boxc-id = boxc smsc:/etc/kannel# cat sqlbox.conf group = sqlbox id = sqlbox-db smsbox-id = asmsbox bearerbox-host = localhost bearerbox-port = 13001 smsbox-port = 13003 sql-log-table = sqlbox_sent_sms sql-insert-table = sqlbox_send_sms log-file = "/var/log/kannel/kannel-sqlbox.log" log-level = 0 group = mysql-connection id = sqlbox-db host = 10.10.1.1 username = 1123 password = 1123 database = 1123 max-connections = 1 Thanks Barry On Sun, 23 May 2010 13:08:45 +0200, Alejandro Guerrieri <[email protected]> wrote: > 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 >> >>
