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 { |