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
