Re: [patch] SQLBOX

Hi Rene,

I have picked PostrgeSQL DBPool support and commited in a slightly modified 
version to cvs.
I believe, you forgot to include 'dlr_pgsql.c' into tar archive?
Please send it as separate patch and I will review/commit it...
Btw. userguide patch would be great too ;)
Thanks in advance!

P.S. 'dbpool_mssql.c' included in tar archive, need some more work to be 
commited:
1) whitespaces (don't use tabs)
2) get rid of 'fprintf' use debug/info/error provided by kannel instead

On Friday 21 May 2004 23:36, Rene Kluwen wrote:
> 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 = ""

-- 
Best regards / Mit besten Grüßen aus Düsseldorf

Dipl.-Ing.
Alexander Malysh
___________________________________________

Centrium GmbH
Vogelsanger Weg 80
40470 Düsseldorf

Fon: +49 (0211) 74 84 51 80
Fax: +49 (0211) 277 49 109

email: [email protected]
web: www.centrium.de
msn: [email protected]
icq: 98063111
___________________________________________

Please avoid sending me Word, Excel or PowerPoint attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html