Re: SQLBox Mysql Connection

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