Nokia WAP and SMS gateway - Manual (Page 77)

Chapter 5. Setting up a SMS Gateway
In addition to that you must have a dlr-db group defined that specifies the table field names that are
used to the DLR attributes and a sdb-connection group that defines the LibSDB ressource itself.
Here is the example configuration from doc/examples/dlr-sdb.conf using a MySQL ressource:
group = sdb-connection
id = mydlr
url = "mysql:host=localhost:db=dlr:uid=foo:pwd=bar"
group = dlr-db
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
field-boxc-id = boxc
Beware that you have the DB support build in your LibSDB installation when trying to use a specific DB
type within the URL.
DLR database field configuration
For external database storage of DLR information in relational database management systems (RDMS)
you will have tospecify which table field are used to represend the stored data. This is done via the
dlr-db group as follows:
Table 5-11. DLR Database Field Configuration Group Variables
Variable Value Description
group dlr-db This is a mandatory variable
id (m) string
An id to identify which external
connection should be used for
DLR storage. Any string is
acceptable, but semicolon ’;’
may cause problems, so avoid it
and any other special
non-alphabet characters.
table (m) string
The name of the table that is
used to store the DLR
information.
field-smsc (m) string
The table field that is used for
the smsc data.
70