SQL log accounting and post_auth

A.L.M.Buxey at lboro.ac.uk A.L.M.Buxey at lboro.ac.uk
Wed Apr 16 22:50:27 CEST 2008


Hi,

> And change the insert line with this line
> postauth_query = "INSERT INTO ${postauth_table} (username, pass, reply)
> VALUES
> ('%{User-Name}','%{%{User-Password}:-%{Chap-Password}}','%{reply:Packet-
> Type}')"

yes. but do you REALLY want to log peoples passwords into a nice
database?  I've changed/obfuscated ours eg in your case...

INSERT INTO ${postauth_table} (username, pass, reply) VALUES\
('%{User-Name}','password','%{reply:Packet-Type}')"

alan



More information about the Freeradius-Users mailing list