DLR support for MS-SQL and Sybase

Yesterday I’ve published a patch that added Kannel’s DBPool support for MS-SQL and Sybase via the FreeTDS library.

Today’s patch uses that functionality to implement the DLR storage on MS-SQL and Sybase DB Engines.

To use this, you need to:

1. Patch Kannel to support FreeTDS (see yesterday’s link).
2. Patch Kannel using this patch, to add support for DLR’s over FreeTDS.
3. ./configure –with-mssql=[optional path] [–other-switches]
4. make
5. sudo make install
6. Configure dlr-storage = mssql
7. Configure the DB connection (see yesterday’s article for details).
8. Configure the dlr-db group (see the userguide for details).

A simple example:

group = core
…
dlr-storage = mssql
…

group = mssql-connection
id = msdlr
username = myuser
password = mypass
server = mssql
database = mydb

#DLR Configuration
group = dlr-db
id = msdlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc

Here is the patch: kannel-dlr-mssql

That’s all. Please try it and let me know.

Regards,

Alex