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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.