IPPool not logging to radius.log on FreeRadius 3.0.12

[Nataniel Klug]

Hello Alan,

Thank you for your quick answer. I am still attached to version 2. In that
version I had this log:

root at CSC-radius-01:~# tail /var/log/freeradius/radius.log
Wed Oct 19 15:35:22 2016 : Auth: Login incorrect: [
edsonverde at certto.com.br/d30m06] (from client TOO-auth-02 port 15785897 cli
00:1A:3F:69:A2:9B)
Wed Oct 19 15:35:22 2016 : Auth: Login incorrect: [
daltron at certto.com.br/d02m04] (from client CSC-auth-07 port 15963333 cli
FC:8B:97:05:C0:0C)
Wed Oct 19 15:35:22 2016 : Auth: Login OK: [pzyo at certto.com.br] (from
client TOO-auth-04 port 16003104 cli 6C:72:20:4E:1C:F3)
Wed Oct 19 15:35:22 2016 : Auth: Login incorrect: [
cavagnollo at certto.com.br/d14m04] (from client CSC-auth-12 port 16085330 cli
00:1A:3F:D0:7E:98)
Wed Oct 19 15:35:22 2016 : Auth: Login incorrect: [
viviane.santana at certto.com.br/d05m01] (from client CSC-auth-07 port
15963334 cli 00:1A:3F:E0:B9:72)
Wed Oct 19 15:35:22 2016 : Info: Allocated IP: 170.150.167.249 from
main_pool   (did TOO-auth-04.C-industrial-a02 cli 6C:72:20:4E:1C:F3 port
16003104 user pzyo at certto.com.br)
Wed Oct 19 15:35:23 2016 : Auth: Login incorrect: [
enjindistri at certto.com.br/d18m08] (from client CSC-auth-06 port 16155297
cli 58:10:8C:04:FC:AA)
Wed Oct 19 15:35:23 2016 : Auth: Login incorrect: [
gaapasan at certto.com.br/d11m02] (from client TOO-auth-04 port 16003106 cli
00:1A:3F:66:B8:18)
Wed Oct 19 15:35:23 2016 : Auth: Login incorrect: [
fipal_jl_jeep at certto.com.br/d26m02] (from client CSC-auth-12 port 16085331
cli 00:1A:3F:E3:F9:4E)
Wed Oct 19 15:35:23 2016 : Info: Released IP 187.19.107.217 (did
CSC-auth-11.C-Lindoeste-a01 cli 00:27:22:D8:E2:D8 user
clodoaldomarcelo at certto.com.br)


When I look into module sqlippool on version 3 it shows me the messages:

sqlippool {
        sql_module_instance = "sql"
        dialect = "mysql"
        ippool_table = "radippool"
        lease_duration = 1920
        pool_key = "%{NAS-Port}"
        messages {
                exists = "Existing IP: %{reply:Framed-IP-Address} (did
%{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user
%{User-Name})"
                success = "Allocated IP: %{reply:Framed-IP-Address} from
%{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id}
port %{NAS-Port} user %{User-Name})"
                clear = "Released IP %{Framed-IP-Address} (did
%{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"
                failed = "IP Allocation FAILED from %{control:Pool-Name}
(did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user
%{User-Name})"
                nopool = "No Pool-Name defined (did %{Called-Station-Id}
cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"
        }
        $INCLUDE ${modconfdir}/sql/ippool/${dialect}/queries.conf
}


Can you point me in the direction to make a linelog module?


Atenciosamente,

*Nataniel Klug* | nataniel.klug at gmail.com

2016-10-19 15:30 GMT-02:00 Alan DeKok <aland at deployingradius.com>:

> On Oct 19, 2016, at 1:00 PM, Nataniel Klug <nataniel.klug at gmail.com>
> wrote:
> >
> > I am running FreeRadius 3.0.12 compiled from source on Debian 8.6. The
> > problem I am facing is that module ippool is not logging allocation,
> > release, etc, to the syslog daemon.
>
>   What makes you think the ippool will log allocation etc. to syslog?
>
> > When I run in debug mode (-Xx), I can see the module ippool sending the
> log
> > message, I just can't see to where:
>
>   Yes, you can see where it's being logged.
>
> > Wed Oct 19 14:54:41 2016 : Debug: (0) sqlippool:    --> Allocated IP:
> > 192.168.0.4 from main_pool (did CSC-755-rt-01 cli E4:8D:8C:EC:90:A2 port
> > 15728701 user testa-sql)
>
>   It's a *debug* message which is only shown in *debug* mode.
>
>   If you want to log allocations, etc. to syslog, you ill need to
> configure a "linelog" module to do that.
>
>   Alan DeKok.
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html