SQLBox Mysql Connection
"Stuart" <[email protected]>
| Newsgroups | gmane.comp.mobile.kannel.devel |
|---|---|
| Message-ID | <001c01c63d2e$133099e0$a611010a@STOO> |
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