Example: PLMNDatabaseSQL

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>