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 >>> >>> >>> >>> >> >> > > >