[FYI] added LibSDB support for DLR storage

Hi all,

to ease up the integration of different database systems as DLR
information storage spaces I have implemented the LibSDB (simple
database library) support into gw/dlr.[ch].

LibSDB is available at http://siag.nu/libbsd and support many various
database types, including MySQL, PostgreSQL, Oracle, gdbm, (even plain
text files).

I have tested the MySQL resource build in libSDB and it works as the
MySQL native support we already had inside Kannel. If there are people
interested in storing DLR information in PostgreSQL or Oracle
databases, we'd appritiate feedback about this using libSDB.

In order to use libSDB as storage space you have to install libSDB
before trying to configure Kannel with libSDB support, then use 

  $ ./configure --enable-sdb --with-dlr=sdb

options to tell Kannel to use the libSDB support for DLR storage.

A sample configuration file may look like this:

  smskannel-sdb.conf:

  group = core
  ...
  dlr-storage = sdb

  group = sdb-connection
  id = mydlr
  url = "mysql:host=localhost:db=dlr:uid=foo:pwd=bar"

  group = dlr-dlr
  mysql-id = mydlr
  table = dlr
  field-smsc = smsc
  field-timestamp = ts
  field-destination = destination
  field-service = service
  field-url = url
  field-mask = mask
  field-status = status

Beware that the group 'dlr-mysql' has been renamed to 'dlr-db' to
reflect the multi-purpose of the group, hence the definition of the
table name and table field names to be used for various database
systems. If you have configurations using the 'dlr-mysql' group you
will have to switch to 'dlr-db', the variables are still the same.

The libSDB support has been commited to CVS HEAD and comments and test
reports with various databases are highly welcome.

Stipe

[email protected]
-------------------------------------------------------------------
Wapme Systems AG

Vogelsanger Weg 80
40470 Düsseldorf

Tel: +49-211-74845-0
Fax: +49-211-74845-299

E-Mail: [email protected]
Internet: http://www.wapme-systems.de
-------------------------------------------------------------------
wapme.net - wherever you are