3 ## sql.conf -- SQL modules
7 ######################################################################
9 # Configuration for the SQL module
11 # The database schemas and queries are located in subdirectories:
13 # sql/DB/schema.sql Schema
14 # sql/DB/dialup.conf Basic dialup (including policy) queries
15 # sql/DB/counter.conf counter
16 # sql/DB/ippool.conf IP Pools in SQL
17 # sql/DB/ippool.sql schema for IP pools.
19 # Where "DB" is mysql, mssql, oracle, or postgresql.
24 # Set the database to one of:
26 # mysql, mssql, oracle, postgresql
31 # Which FreeRADIUS driver to use.
33 driver = "rlm_sql_${database}"
41 # Database table configuration for everything except Oracle
43 # If you are using Oracle then use this instead
44 # radius_db = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=your_sid)))"
46 # If you want both stop and start records logged to the
47 # same SQL table, leave this as is. If you want them in
48 # different tables, put the start table in acct_table1
49 # and stop table in acct_table2
50 acct_table1 = "radacct"
51 acct_table2 = "radacct"
53 # Allow for storing data after authentication
54 postauth_table = "radpostauth"
56 authcheck_table = "radcheck"
57 authreply_table = "radreply"
59 groupcheck_table = "radgroupcheck"
60 groupreply_table = "radgroupreply"
62 # Table to keep group info
63 usergroup_table = "radusergroup"
65 # If set to 'yes' (default) we read the group tables
66 # If set to 'no' the user MUST have Fall-Through = Yes in the radreply table
69 # Remove stale session if checkrad does not see a double login
70 deletestalesessions = yes
72 # Print all SQL statements when in debug mode (-x)
74 sqltracefile = ${logdir}/sqltrace.sql
76 # As of version 3.0, the "pool" section has replaced the
77 # following configuration items:
80 # connect_failure_retry_delay
84 # The connection pool is new for 3.0, and will be used in many
85 # modules, for all kinds of connection-related activity.
88 # Number of connections to start
91 # Minimum number of connections to keep open
94 # Maximum number of connections
96 # If these connections are all in use and a new one
97 # is requested, the request will NOT get a connection.
100 # Spare connections to be left idle
102 # NOTE: Idle connections WILL be closed if "idle_timeout"
106 # Number of uses before the connection is closed
111 # The lifetime (in seconds) of the connection
114 # idle timeout (in seconds). A connection which is
115 # unused for this length of time will be closed.
118 # NOTE: All configuration settings are enforced. If a
119 # connection is closed because of "idle_timeout",
120 # "uses", or "lifetime", then the total number of
121 # connections MAY fall below "min". When that
122 # happens, it will open a new connection. It will
123 # also log a WARNING message.
125 # The solution is to either lower the "min" connections,
126 # or increase lifetime/idle_timeout.
129 # Set to 'yes' to read radius clients from the database ('nas' table)
130 # Clients will ONLY be read on server startup. For performance
131 # and security reasons, finding clients via SQL queries CANNOT
132 # be done "live" while the server is running.
136 # Table to keep radius client info
139 # Read driver-specific configuration
140 $INCLUDE sql/${database}/dialup.conf