[patch] SQLBOX

"Rene Kluwen" <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
For the patch: http://www.chimit.nl/kannel/sqlbox_patch.tar

I know this needs more documentation, but this patch has been kept from the
mailing list so long already that I didnt want to refrain it from you
anymore.

For me also the standard excuse holds that I have been so busy lately that I
have not been able to keep up with the list anymore.

Anyhow... Here, a working version of the SQLBOX is attached. In the tar
ball, there are a number of files that have been split up and a
sqlbox_patch.diff that has to be applied.

The patch includes Postgres, MySQL and MS-SQL support (also for DLR's) for
anybody that feels the need to use it.
MS-SQL client libraries are either sybase or free-tds (./configure
autodetects).

Here follows some documentation that in fact (I admit) should be included in
the patch against the doc tree:
There is one extra configure option in group = smsbox, which is:

# bearerbox-is-sqlbox indicates if the smsbox is connected to the bearerbox
or an sql box
bearerbox-is-sqlbox = true/false

For the rest, the group = sqlbox contains the following options:

group = sqlbox
# id corresponds to id in group = mysql-connection.
# this is analogous to id in group = dlr-db
id = dlr-db2
# smsbox-id indicates the box where SQL-injected messages appear to be
coming fr
om
smsbox-id = sqlbox2
# bearerbox host to connect to
bearerbox-host = "127.0.0.1"
# smsbox port to be listening on
smsbox-port = 13005
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-level = 10
# ssl-client-certkey-file = ""
# ssl-server-cert-file = ""
# ssl-server-key-file = ""
# ssl-trusted-ca-file = ""
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.