dlr-sdb.conf

gnu的专业网关smpp协议支持源代码。

# 
# DLR with LibSDB support configuration
#
# Example defining a LibSDB resource (as an abstraction of a real database)
# and the required table and field values.
#
# As of LibSDB 0.5.0 the following database types are supported with
# the associated URL resource scheme:
# 
#   mysql:host=XXX:db=XXX:uid=XXX:pwd=XXX
#   postgres:host=XXX:db=XXX:port=XXX
#   oracle:uid=XXX:pwd=XXX OR oracle:uid=username/password@instance
#   sqlite:db=/full/path/to/db
#   lago:host=XXX:port=XXX:db=XXX:uid=XXX:pwd=XXX
#   mimer:db=XXX:uid=XXX:pwd=XXX
#   odbc:dsn=postgresql
#   sdbd:host:port:url=XXX
#   text:/path/to/db/ (note trailing slash)
#
# Beware that you have the DB support build in your LibSDB installation
# when trying to use a specific DB type within the URL.
#
# LibSDB is available at http://siag.nu/libsdb/
#

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

# 
# Create the required table for the DLR support in the database 
# with something similar like this, i.e. for MySQL: 
# 
#   CREATE TABLE dlr (
#     smsc varchar(40),
#     ts varchar(40),
#     destination varchar(40),
#     service varchar(40),
#     url varchar(255),
#     mask int(10),
#     status int(10)
#   )
#
# Other DB types may vary. Consult your DB admin for help in creating
# the appropriate table space and connection details for the real DB.
#

group = dlr-dlr
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