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
