3.24. <ServiceDatabase SQL> Previous topic Parent topic Child topic Next topic

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.