3 # Configuration for the SQL module
5 # The database schemas are available at:
12 ## Database type you wish to connect to:
13 # driver = "rlm_sql_freetds"
14 # driver = "rlm_sql_iodbc"
15 driver = "rlm_sql_mysql"
16 # driver = "rlm_sql_oracle"
17 # driver = "rlm_sql_postgresql"
18 # driver = "rlm_sql_unixodbc"
20 ## Also see the bottom of this file to modify which SQL dialect you use
27 ## Database table configuration for everything except Oracle
29 ## If you are using Oracle then use this instead
30 # radius_db = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=your_sid)))"
32 ## If you want both stop and start records logged to the
33 ## same SQL table, leave this as is. If you want them in
34 ## different tables, put the start table in acct_table1
35 ## and stop table in acct_table2
36 acct_table1 = "radacct"
37 acct_table2 = "radacct"
39 ## Allow for storing data after authentication
40 postauth_table = "radpostauth"
42 authcheck_table = "radcheck"
43 authreply_table = "radreply"
45 groupcheck_table = "radgroupcheck"
46 groupreply_table = "radgroupreply"
48 ## Table to keep group info
49 usergroup_table = "radusergroup"
51 ## If set to 'yes' (default) we read the group tables
52 ## If set to 'no' the user MUST have Fall-Through = Yes in the radreply table
55 ## Table to keep radius client info
58 ## Set to 'yes' to read radius clients from the database ('nas' table)
61 ## Remove stale session if checkrad does not see a double login
62 deletestalesessions = yes
64 ## Print all SQL statements when in debug mode (-x)
66 sqltracefile = ${logdir}/sqltrace.sql
68 ## number of sql connections to make to server
71 ## number of seconds to dely retrying on a failed database
72 ## connection (per_socket)
73 connect_failure_retry_delay = 60
76 ## Uncomment the appropriate config file for your SQL dialect
78 # $INCLUDE ${confdir}/sql/mssql-dialup.conf
79 $INCLUDE ${confdir}/sql/mysql-dialup.conf
80 # $INCLUDE ${confdir}/sql/oracle-dialup.conf
81 # $INCLUDE ${confdir}/sql/postgresql-dialup.conf