Ok, So I tried adding :3306 to the IP Addres, still same error. I also tried changing the database name on the kannel dlr connection (which is same user/pass/database/host as the sqlbox) and got a database access denied, so I know the kannel one is connecting and doing sql selects just fine. It's just sqlbox that doesn't like it, though this still doesnt explain why I dont get any entries into my dlr table, only selects happening.
thanks barry On Sun, 23 May 2010 12:36:07 +0100, "Cezary Siwek" <[email protected]> wrote: > 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 >>> >>>
