3 # Configuration for the SQL module
5 # The database schemas and queries are located in subdirectories:
7 # sql/DB/schema.sql Schema
8 # sql/DB/dialup.conf Basic dialup (including policy) queries
9 # sql/DB/counter.conf counter
10 # sql/DB/ippool.conf IP Pools in SQL
11 # sql/DB/ippool.sql schema for IP pools.
13 # Where "DB" is mysql, mssql, oracle, or postgresql.
18 # Set the database to one of:
20 # mysql, mssql, oracle, postgresql
25 # Which FreeRADIUS driver to use.
27 driver = "rlm_sql_${database}"
34 ## Database table configuration for everything except Oracle
36 ## If you are using Oracle then use this instead
37 # radius_db = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=your_sid)))"
39 ## If you want both stop and start records logged to the
40 ## same SQL table, leave this as is. If you want them in
41 ## different tables, put the start table in acct_table1
42 ## and stop table in acct_table2
43 acct_table1 = "radacct"
44 acct_table2 = "radacct"
46 ## Allow for storing data after authentication
47 postauth_table = "radpostauth"
49 authcheck_table = "radcheck"
50 authreply_table = "radreply"
52 groupcheck_table = "radgroupcheck"
53 groupreply_table = "radgroupreply"
55 ## Table to keep group info
56 usergroup_table = "radusergroup"
58 ## If set to 'yes' (default) we read the group tables
59 ## If set to 'no' the user MUST have Fall-Through = Yes in the radreply table
62 ## Remove stale session if checkrad does not see a double login
63 deletestalesessions = yes
65 ## Print all SQL statements when in debug mode (-x)
67 sqltracefile = ${logdir}/sqltrace.sql
69 ## number of sql connections to make to server
72 ## number of seconds to dely retrying on a failed database
73 ## connection (per_socket)
74 connect_failure_retry_delay = 60
76 ## Table to keep radius client info
79 ## Set to 'yes' to read radius clients from the database ('nas' table)
83 # Pull in the driver-specific configurations.
85 $INCLUDE sql/${database}/dialup.conf