Section 4.16.1. Example: PLMNDatabaseSQL

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 is configurable. When RefreshPeriod is not configured, the PLMN parameters are loaded only once when Radiator starts.

The following values from the database are automatically used by Radiator. When the value is set to NULL in the database, the default value or value in the configuration file is used. A customised query can fetch additional values for AuthorisedHook and other hooks.

plmn_id: Is the IMSI prefix the values apply to
sccp_called_gt: Overrides the value for SCCP parameter PeerGlobalTitle for SIGTRAN messages
destination_realm: Sets the Destination-Realm for Diameter messages
authentication_method: One of SWx, S6a, Cx or Wx. Only applicable for Diameter.
location_update_method: One of UpdateLocation or UpdateGprsLocation for SIGTRAN overriding MAP parameter UpdateLocationOperation. One of SWx or S6a for Diameter overriding WxClient parameter UpdateLocationInterface. Location update can be skipped with immediate success when the value is set to none.
rat_type: Overrides WxClient parameters S6aRATType and SWxRATType.

<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

   GetQuery SELECT plmn_id, sccp_called_gt, destination_realm \
                   authentication_method, location_update_method, \
                   rat_type FROM plmn_params
   GetQueryColumnDef  0,plmn_id
   GetQueryColumnDef  1,sccp_called_gt
   GetQueryColumnDef  2,destination_realm

   GetQueryColumnDef  3,authentication_method
   GetQueryColumnDef  4,location_update_method

   GetQueryColumnDef  5,rat_type

   # Reread PLMN information every two hours
   RefreshPeriod 7200
</IMSICrypt>

<MAP>
   # Other MAP configuration parameters
   PLMNDatabase plmndb-sql
</AuthBy>