FR 3.0.8 sql

[Marcin]

I think i've managed it :)
#v+
        redundant {
                sql_last_online
                ok

        }
#v-

it's so simply :)


2015-04-01 10:14 GMT+02:00 Marcin <marcin at nicram.net>:

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


-- 
Pozdrawiam
Marcin / nicraM