-# $Id$
+# -*- text -*-
+##
+## sql.conf -- SQL modules
+##
+## $Id$
+
+######################################################################
#
# Configuration for the SQL module
#
#
driver = "rlm_sql_${database}"
- ## Connection info:
+ # Connection info:
server = "localhost"
login = "radius"
password = "radpass"
- ## Database table configuration for everything except Oracle
+ # Database table configuration for everything except Oracle
radius_db = "radius"
- ## If you are using Oracle then use this instead
+ # If you are using Oracle then use this instead
# radius_db = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=your_sid)))"
- ## If you want both stop and start records logged to the
- ## same SQL table, leave this as is. If you want them in
- ## different tables, put the start table in acct_table1
- ## and stop table in acct_table2
+ # If you want both stop and start records logged to the
+ # same SQL table, leave this as is. If you want them in
+ # different tables, put the start table in acct_table1
+ # and stop table in acct_table2
acct_table1 = "radacct"
acct_table2 = "radacct"
- ## Allow for storing data after authentication
+ # Allow for storing data after authentication
postauth_table = "radpostauth"
authcheck_table = "radcheck"
groupcheck_table = "radgroupcheck"
groupreply_table = "radgroupreply"
- ## Table to keep group info
+ # Table to keep group info
usergroup_table = "radusergroup"
- ## If set to 'yes' (default) we read the group tables
- ## If set to 'no' the user MUST have Fall-Through = Yes in the radreply table
+ # If set to 'yes' (default) we read the group tables
+ # If set to 'no' the user MUST have Fall-Through = Yes in the radreply table
# read_groups = yes
- ## Remove stale session if checkrad does not see a double login
+ # Remove stale session if checkrad does not see a double login
deletestalesessions = yes
- ## Print all SQL statements when in debug mode (-x)
+ # Print all SQL statements when in debug mode (-x)
sqltrace = no
sqltracefile = ${logdir}/sqltrace.sql
- ## number of sql connections to make to server
+ # number of sql connections to make to server
num_sql_socks = 5
- ## number of seconds to dely retrying on a failed database
- ## connection (per_socket)
+ # number of seconds to dely retrying on a failed database
+ # connection (per_socket)
connect_failure_retry_delay = 60
- ## Table to keep radius client info
- nas_table = "nas"
+ # Set to 'yes' to read radius clients from the database ('nas' table)
+ # Clients will ONLY be read on server startup. For performance
+ # and security reasons, finding clients via SQL queries CANNOT
+ # be done "live" while the server is running.
+ #
+ #readclients = yes
- ## Set to 'yes' to read radius clients from the database ('nas' table)
- # readclients = yes
+ # Table to keep radius client info
+ nas_table = "nas"
-#
-# Pull in the driver-specific configurations.
-#
-$INCLUDE sql/${database}/dialup.conf
+ # Read driver-specific configuration
+ $INCLUDE sql/${database}/dialup.conf
}