This optional clause specifies an external SQL Service Database for
radiusd.
ServiceDatabase SQL has a number of customisable
SQL statements (AddServiceQuery, GetServiceQuery, UpdateServiceQuery,
DeleteServiceQuery, AddSubscriptionQuery, GetSubscriptionQuery,
UpdateSubscriptonQuery and DeleteSubscriptionQuery). These statements are
used to access the entries in the SQL Service Database. The default
statements will work with the example SERVICES and SUBSCRIPTIONS tables in
the example SQL schema in file goodies/hotspot.sql.
If you wish, you can use more or fewer columns in your SQL Service
Database, and you can change the names of the columns or the table. If you
do use a different table schema, you will probably have to change
statements to match your schema.
You can configure the SQL database(s) that
ServiceDatabase
SQL uses by defining one or more DBSource, DBUsername and
DBAuth lines. For more information about SQL configuration and failure
behaviour, see
Section 3.8.
ServiceDatabase SQL understands also the same
parameters as
ServiceDatabase xxxxxx. For more
information, see
Section 3.22. It supports
also all the common SQL configuration parameters. For more information
about the SQL configuration parameters, see
Section 3.8.