FR 3.0.8 sql
Marcin
marcin at nicram.net
Wed Apr 1 10:14:39 CEST 2015
Hi,
#v+
if (Framed-Protocol == "PPP") {
linelog
sql_last_online
if (fail){
ok
}
}
#v-
#v+
(2) # Executing section accounting from file
/etc/freeradius/sites-enabled/default
(2) accounting {
(2) detail: EXPAND
/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d
(2) detail: --> /var/log/freeradius/radacct/172.21.7.176/detail-20150401
(2) detail:
/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d
expands to /var/log/freeradius/radacct/172.21.7.176/detail-20150401
(2) detail: EXPAND %t
(2) detail: --> Wed Apr 1 10:07:35 2015
(2) [detail] = ok
(2) [unix] = ok
(2) radutmp: EXPAND /var/log/freeradius/radutmp
(2) radutmp: --> /var/log/freeradius/radutmp
(2) radutmp: EXPAND %{User-Name}
(2) radutmp: --> bobpppoe
(2) [radutmp] = ok
(2) if (Framed-Protocol == "PPP") {
(2) if (Framed-Protocol == "PPP") -> TRUE
(2) if (Framed-Protocol == "PPP") {
(2) linelog: EXPAND Accounting-Request.%{%{Acct-Status-Type}:-unknown}
(2) linelog: --> Accounting-Request.Start
(2) linelog: EXPAND /var/log/freeradius/linelog
(2) linelog: --> /var/log/freeradius/linelog
(2) linelog: EXPAND
%T|C|%{Acct-Unique-Session-ID}|%{Framed-IP-Address}|%{Calling-Station-Id}|%{NAS-IP-Address}|%{NAS-Identifier}
(2) linelog: -->
2015-04-01-10.07.35.000000|C|2df2a8590df82d3c84648b7a1b17d357|10.5.4.3|08:00:27:D6:04:2D|172.21.7.176|TestowyMT
(2) [linelog] = ok
(2) sql_last_online: EXPAND %{tolower:type.%{Acct-Status-Type}.query}
(2) sql_last_online: --> type.start.query
(2) sql_last_online: Using query template 'query'
rlm_sql (sql_last_online): 0 of 0 connections in use. You may need to
increase "spare"
rlm_sql (sql_last_online): Opening additional connection (0), 1 of 10
pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Couldn't connect to MySQL server myDB at 127.0.0.1:myDB
rlm_sql_mysql: MySQL error: Can't connect to MySQL server on '127.0.0.1'
(111)
rlm_sql_mysql: Socket destructor called, closing socket
rlm_sql (sql_last_online): Opening connection failed (0)
(2) [sql_last_online] = fail
(2) } # if (Framed-Protocol == "PPP") = fail
(2) } # accounting = fail
(2) Not sending reply to client.
(2) Finished request
#v-
and another reqest is sending by nas.
How to configure, that if sql_last_olnie module can't connect to database,
then still is 'ok' and generally accounting section reply ok?
More information about the Freeradius-Users
mailing list