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 # number of sql connections to make to server
79 # number of seconds to dely retrying on a failed database
80 # connection (per_socket)
81 connect_failure_retry_delay = 60
83 # lifetime of an SQL socket. If you are having network issues
84 # such as TCP sessions expiring, you may need to set the socket
85 # lifetime. If set to non-zero, any open connections will be
86 # closed "lifetime" seconds after they were first opened.
89 # Maximum number of queries used by an SQL socket. If you are
90 # having issues with SQL sockets lasting "too long", you can
91 # limit the number of queries performed over one socket. After
92 # "max_qeuries", the socket will be closed. Use 0 for "no limit".
95 # Set to 'yes' to read radius clients from the database ('nas' table)
96 # Clients will ONLY be read on server startup. For performance
97 # and security reasons, finding clients via SQL queries CANNOT
98 # be done "live" while the server is running.
102 # Table to keep radius client info
105 # Read driver-specific configuration
106 $INCLUDE sql/${database}/dialup.conf