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