Re: [patch] SQLBOX

Hi Rene,

On Wednesday 09 June 2004 20:01, Rene Kluwen wrote:
> Hi Alexander,
>
> Attached is the file that you are looking for.

hmm, do you read ML ;) I have commited it already :)

> Thanks for committing the PG DBPool support already... It made the sqlbox
> patch fail with some people... But that doesnt matter :)... A new patch is
> available already... Including the dlr_pgsql.c as well...

Hmm, I would say: Thank you for the patch!

>
> About dbpool_mssql.c: Will fix both issues... Sorry, this is copy/pasted
> from an existing (home-made) abstraction class.

ok

>
> Meanwhile, I have had some (really valid) questions from users by email and
> I will post them to this list together with the answers later.
>
> Question about the userguide: Which format is it in really and which is the
> preferred way to update?

patch against current cvs is preferred. userguide is in Docbook format.

>
> Warm regards,
>
> Rene Kluwen
> Chimit
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]On
> Behalf Of Alexander Malysh
> Sent: dinsdag 8 juni 2004 12:33
> To: [email protected]
> Cc: Rene Kluwen
> Subject: 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

-- 
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: a.malysh at centrium.de
web: www.centrium.de
msn: olek2002 at hotmail.com
icq: 98063111
___________________________________________

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBAx1atnX3e5W+uJ0ERAj9lAJ43Pk5Rbxxc0wMIii6XB/+uHU0VlgCdH6jW
TOpnXCvXZWGFJXvme/o7vxY=
=Vrru
-----END PGP SIGNATURE-----