For a full example, see
goodies/plmndb.cfg
.
PLMNDatabaseSQL
supports a number of SQL
configuration parameters that are common to all Radiator's SQL based
modules. These are documented in the Radiator reference manual.
At a
minimum DBSource
and other SQL access parameters must
be configured. SQL query that fetches the PLMN information and the
interpretation of the query results are currently not configurable. When
RefreshPeriod
is not configured, the PLMN parameters
are loaded only once when Radiator starts.
<PLMNDatabaseSQL>
# Identifier is used by MAP and PeerSP clauses to refer to this
# clause when looking up PLMN information for an IMSI.
Identifier plmndb-sql
DBSource dbi:mysql:plmndb
DBUsername mikem
DBAuth fred
# Reread PLMN information every two hours
RefreshPeriod 7200
</IMSICrypt>
<MAP>
# Other MAP configuration parameters
PLMNDatabase plmndb-sql
</AuthBy>