[Q] radacct table is empty ...

[Zeus Panchenko]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi,

my FR v.3.0.12 up and running, eap works as expected, users DB is in LDAP

now I'm trying to get accounting data in SQL ( to have all the data written to files
/usr/local/var/log/radius/radacct/X.X.X.X/auth-detail-YYYYmmddand )

but I'm failing to get it working ...

all SQL tables except radpostauth are empty ... I have no idea why

here are details:



- ---[ `ls -al mods-enabled/' quotation start ]-------------------------------------------
...
lrwxrwxr-x 1 radius radius 21 Apr 26 2016 eap -> ../mods-available/eap
...
lrwxrwxr-x 1 radius radius 22 Apr 26 2016 ldap -> ../mods-available/ldap
...
- ---[ `ls -al mods-enabled/' quotation end ]-------------------------------------------



- ---[ sites-enabled/default quotation start ]-------------------------------------------
authorize {
...
eap {
ok = return
}
...
}

authenticate {
eap
}

accounting {
detail
sql
attr_filter.accounting_response
}

session {
sql
}

post-auth {
update {
&reply: += &session-state:
}
sql
}
- ---[ sites-enabled/default quotation end ]-------------------------------------------


/usr/local/var/log/radius/radacct/X.X.X.X/auth-detail-YYYYmmdd files are created and updated ...

what can be the cause why SQL table radacct is empty then?

- --
Zeus V. Panchenko jid:***@im.ibs.dn.ua
IT Dpt., I.B.S. LLC GMT+2 (EET)
-----BEGIN PGP SIGNATURE-----

iF0EARECAB0WIQQYIXL6FUmD7SUfqoOveOk+D/ejKgUCW+R15QAKCRCveOk+D/ej
KoUjAJ9UUxqLHKWpUH5J16/tuWP/2d6d7gCggz9NjGYhjsRj63ZvFtxRIk8t39Q=
=29MD
-----END PGP SIGNATURE-----

-
List info/subscribe/unsubsc

[Alan DeKok]

Post by Zeus Panchenko
my FR v.3.0.12 up and running, eap works as expected, users DB is in LDAP
now I'm trying to get accounting data in SQL ( to have all the data written to files
/usr/local/var/log/radius/radacct/X.X.X.X/auth-detail-YYYYmmddand )
but I'm failing to get it working ...
all SQL tables except radpostauth are empty ... I have no idea why

Because the server isn't receiving accounting packets. This is in the FAQ.

Post by Zeus Panchenko
- ---[ `ls -al mods-enabled/' quotation start ]-------------------------------------------

No, we do NOT need to see the configuration files. When you join this list, you get a message telling you to read this page:

http://wiki.freeradius.org/list-help

That tells you what information we need. And it explicitly says that you should not post configuration files.

Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freer