Dear Stuart, You have to specify smsbox-id in the smsbox group to the same of that you specified in sqlbox group. As you used smsbox-id = sqlbox2 in the sqlbox group. Please add it to the smsbox group as well.
Good luck! Rayson Lee InnoAge Hong Kong Limited -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Sent: Thursday, March 02, 2006 1:23 AM To: users@kannel.org Subject: Re: SQLBox Mysql Connection Hi, I think I've worked out what was wrong, although I was setting the host for the DB, the sqlbox was always trying to connect to `localhost`. I set up mysql on the same machine and it can now connect. Although, it has led me to a different problem- the sqlbox will create the tables but will not write incoming or outgoing traffic into them. There are no sql errors in the logs. Has anyone experienced a similar problem? Stuart ----- Original Message ----- From: "Rene Kluwen" <[EMAIL PROTECTED]> To: "Stuart" <[EMAIL PROTECTED]> Cc: <users@kannel.org> Sent: Wednesday, March 01, 2006 1:58 PM Subject: Re: SQLBox Mysql Connection > What do your logfile say? > > Rene Kluwen > Chimit > >> Hi, >> >> Thanks for your reply.... >> >> Here's the config for group = smsbox: >> >> # SMSBOX SETUP >> >> group = smsbox >> bearerbox-host = localhost >> bearerbox-is-sqlbox = true >> #sendsms-port = 13013 >> sendsms-port = 13013 >> global-sender = "12345" >> sendsms-url = "/cgi-bin/sendsms" >> #sendsms-chars = "0123456789 +-" >> log-file = "/var/log/kannel/smsbox.log" >> #log-level = 0 >> access-log = "/var/log/kannel/access.log" >> >> I've also set "bearerbox-is-sqlbox = true" in the "smsbox" group. >> >> Stuart >> >> ----- Original Message ----- >> From: "Rene Kluwen" <[EMAIL PROTECTED]> >> To: "Stuart" <[EMAIL PROTECTED]> >> Sent: Wednesday, March 01, 2006 1:23 PM >> Subject: Re: SQLBox Mysql Connection >> >> >>> How about >>> >>> group = smsbox? >>> >>> Do you use the parameter bearerbox-is-sqlbox? >>> >>> Rene Kluwen >>> Chimit >>> >>>> Hi, >>>> >>>> I'm trying to set up sqlbox to log incoming and outgoing messages to / >>>> from >>>> the smbox but cannot get the smsbox to connect to mysql. >>>> >>>> I'm using the same connection settings as I did for dlr with mysql and >>>> that >>>> worked fine. Is there something I'm missing? It's running on SuSe 10 on >>>> a >>>> dual 64-bit Xeon machine. The code make's with no error and I'm using >>>> the >>>> latest cvs of kannel and sqlbox. >>>> >>>> Here is a snippet of the conf file: >>>> >>>> # mysql DLR >>>> group = mysql-connection >>>> id = mydlr >>>> host = db.XXXXX.com >>>> username = XXXXX >>>> password = XXXXX >>>> database = test >>>> max-connections = 4 >>>> >>>> and, >>>> >>>> # SQLBOX SETUP >>>> group = sqlbox >>>> # id corresponds to id in group = mysql-connection. >>>> # this is analogous to id in group = dlr-db >>>> id = mydlr >>>> # smsbox-id indicates the box where SQL-injected messages appear to be >>>> coming from >>>> smsbox-id = sqlbox2 >>>> # bearerbox host to connect to >>>> bearerbox-host = "localhost" >>>> # smsbox port to be listening on >>>> smsbox-port = 13013 >>>> ##smsbox-port-ssl = false >>>> # sql-log-table is the table used to log all sent messages >>>> sql-log-table = sent_sms >>>> # sql-insert-table is the table that is monitored for new messages to >>>> send >>>> sql-insert-table = send_sms >>>> # global sender: If no sender is specified in sql-insert-table then >>>> this >>>> # value is used. >>>> global-sender = 06121 >>>> # log-file = >>>> log-file = "/var/log/kannel/sqlbox.log" >>>> # log-level = 10 >>>> # ssl-client-certkey-file = "" >>>> # ssl-server-cert-file = "" >>>> # ssl-server-key-file = "" >>>> # ssl-trusted-ca-file = "" >>>> >>>> Any help with this would be much appreciated, thanks! >>>> >>>> Stuart >>>> >>>> >>>> >>>> >>> >>> >> >> >> > >
