| 2,7 → 2,6 |
|---|
| ## |
| ## query.conf -- MySQL configuration for default schema (schema.sql) |
| ## |
| ## $Id: dialup.conf 983 2012-08-16 13:34:14Z franck $ |
| |
| # Safe characters list for sql queries. Everything else is replaced |
| # with their mime-encoded equivalents. |
| 158,7 → 157,7 |
|---|
| acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | \ |
| '%{%{Acct-Output-Octets}:-0}' \ |
| WHERE acctsessionid = '%{Acct-Session-Id}' \ |
| AND username = '%{SQL-User-Name}' \ |
| AND username = BINARY '%{SQL-User-Name}' \ |
| AND nasipaddress = '%{NAS-IP-Address}'" |
| |
| accounting_update_query_alt = " \ |
| 172,7 → 171,7 |
|---|
| acctstartdelay, xascendsessionsvrkey) \ |
| VALUES \ |
| ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \ |
| '%{SQL-User-Name}', \ |
| BINARY '%{SQL-User-Name}', \ |
| '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', \ |
| '%{NAS-Port-Type}', \ |
| DATE_SUB('%S', \ |
| 201,7 → 200,7 |
|---|
| acctstartdelay, acctstopdelay, xascendsessionsvrkey) \ |
| VALUES \ |
| ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \ |
| '%{SQL-User-Name}', \ |
| BINARY '%{SQL-User-Name}', \ |
| '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', \ |
| '%{NAS-Port-Type}', '%S', NULL, \ |
| '0', '%{Acct-Authentic}', '%{Connect-Info}', \ |
| 216,7 → 215,7 |
|---|
| acctstartdelay = '%{%{Acct-Delay-Time}:-0}', \ |
| connectinfo_start = '%{Connect-Info}' \ |
| WHERE acctsessionid = '%{Acct-Session-Id}' \ |
| AND username = '%{SQL-User-Name}' \ |
| AND username = BINARY '%{SQL-User-Name}' \ |
| AND nasipaddress = '%{NAS-IP-Address}'" |
| |
| accounting_stop_query = " \ |
| 231,7 → 230,7 |
|---|
| acctstopdelay = '%{%{Acct-Delay-Time}:-0}', \ |
| connectinfo_stop = '%{Connect-Info}' \ |
| WHERE acctsessionid = '%{Acct-Session-Id}' \ |
| AND username = '%{SQL-User-Name}' \ |
| AND username = BINARY '%{SQL-User-Name}' \ |
| AND nasipaddress = '%{NAS-IP-Address}'" |
| |
| accounting_stop_query_alt = " \ |
| 246,7 → 245,7 |
|---|
| acctstartdelay, acctstopdelay) \ |
| VALUES \ |
| ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \ |
| '%{SQL-User-Name}', \ |
| BINARY '%{SQL-User-Name}', \ |
| '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', \ |
| '%{NAS-Port-Type}', \ |
| DATE_SUB('%S', \ |
| 301,7 → 300,7 |
|---|
| # Uncomment simul_count_query to enable simultaneous use checking |
| simul_count_query = "SELECT COUNT(*) \ |
| FROM ${acct_table1} \ |
| WHERE username = '%{SQL-User-Name}' \ |
| WHERE username = BINARY '%{SQL-User-Name}' \ |
| AND acctstoptime IS NULL" |
| |
| #simul_verify_query = "SELECT radacctid, acctsessionid, username, \ |
| 322,7 → 321,7 |
|---|
| postauth_query = "INSERT INTO ${postauth_table} \ |
| (username, reply, authdate) \ |
| VALUES ( \ |
| '%{User-Name}', \ |
| BINARY '%{User-Name}', \ |
| '%{reply:Packet-Type}', '%S')" |
| # We add the following patch (freeradius V2 to V3) in order ALCASAR works |
| post-auth { |