[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 = ""