| Line 1... |
Line 1... |
| 1 |
# -*- text -*-
|
1 |
# -*- text -*-
|
| 2 |
##
|
2 |
##
|
| 3 |
## dialup.conf -- MySQL configuration for default schema (schema.sql)
|
3 |
## query.conf -- MySQL configuration for default schema (schema.sql)
|
| 4 |
##
|
4 |
##
|
| 5 |
## $Id: dialup.conf 983 2012-08-16 13:34:14Z franck $
|
5 |
## $Id: dialup.conf 983 2012-08-16 13:34:14Z franck $
|
| 6 |
|
6 |
|
| 7 |
# Safe characters list for sql queries. Everything else is replaced
|
7 |
# Safe characters list for sql queries. Everything else is replaced
|
| 8 |
# with their mime-encoded equivalents.
|
8 |
# with their mime-encoded equivalents.
|
| 9 |
# The default list should be ok
|
9 |
# The default list should be ok (define in 'expr' module
|
| 10 |
#safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
|
10 |
#safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
|
| 11 |
|
11 |
|
| 12 |
#######################################################################
|
12 |
#######################################################################
|
| 13 |
# Query config: Username
|
13 |
# Query config: Username
|
| 14 |
#######################################################################
|
14 |
#######################################################################
|
| Line 260... |
Line 260... |
| 260 |
'%{%{Acct-Output-Octets}:-0}', \
|
260 |
'%{%{Acct-Output-Octets}:-0}', \
|
| 261 |
'%{Called-Station-Id}', '%{Calling-Station-Id}', \
|
261 |
'%{Called-Station-Id}', '%{Calling-Station-Id}', \
|
| 262 |
'%{Acct-Terminate-Cause}', \
|
262 |
'%{Acct-Terminate-Cause}', \
|
| 263 |
'%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', \
|
263 |
'%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', \
|
| 264 |
'0', '%{%{Acct-Delay-Time}:-0}')"
|
264 |
'0', '%{%{Acct-Delay-Time}:-0}')"
|
| - |
|
265 |
# We add the following patch (freeradius V2 to V3) in order ALCASAR works
|
| - |
|
266 |
# be carefull : 'tolower' need now the 'expr' module
|
| - |
|
267 |
accounting {
|
| - |
|
268 |
reference = "%{tolower:type.%{Acct-Status-Type}.query}"
|
| - |
|
269 |
type {
|
| - |
|
270 |
accounting-on {
|
| - |
|
271 |
query = "${....accounting_onoff_query}"
|
| - |
|
272 |
}
|
| - |
|
273 |
accounting-off {
|
| - |
|
274 |
query = "${....accounting_onoff_query}"
|
| - |
|
275 |
}
|
| - |
|
276 |
start {
|
| - |
|
277 |
query = "${....accounting_start_query}"
|
| - |
|
278 |
query = "${....accounting_start_query_alt}"
|
| - |
|
279 |
}
|
| - |
|
280 |
interim-update {
|
| - |
|
281 |
query = "${....accounting_update_query}"
|
| - |
|
282 |
query = "${....accounting_update_query_alt}"
|
| - |
|
283 |
}
|
| - |
|
284 |
stop {
|
| - |
|
285 |
query = "${....accounting_stop_query}"
|
| - |
|
286 |
query = "${....accounting_stop_query_alt}"
|
| - |
|
287 |
}
|
| - |
|
288 |
}
|
| 265 |
|
289 |
}
|
| 266 |
#######################################################################
|
290 |
#######################################################################
|
| 267 |
# Simultaneous Use Checking Queries
|
291 |
# Simultaneous Use Checking Queries
|
| 268 |
#######################################################################
|
292 |
#######################################################################
|
| 269 |
# simul_count_query - query for the number of current connections
|
293 |
# simul_count_query - query for the number of current connections
|
| 270 |
# - If this is not defined, no simultaneouls use checking
|
294 |
# - If this is not defined, no simultaneouls use checking
|
| Line 298... |
Line 322... |
| 298 |
postauth_query = "INSERT INTO ${postauth_table} \
|
322 |
postauth_query = "INSERT INTO ${postauth_table} \
|
| 299 |
(username, reply, authdate) \
|
323 |
(username, reply, authdate) \
|
| 300 |
VALUES ( \
|
324 |
VALUES ( \
|
| 301 |
'%{User-Name}', \
|
325 |
'%{User-Name}', \
|
| 302 |
'%{reply:Packet-Type}', '%S')"
|
326 |
'%{reply:Packet-Type}', '%S')"
|
| - |
|
327 |
# We add the following patch (freeradius V2 to V3) in order ALCASAR works
|
| - |
|
328 |
post-auth {
|
| - |
|
329 |
query = "${..postauth_query}"
|
| 303 |
|
330 |
}
|