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...
It's okay, but when I query my table, I've just realize that with my line, the password field is empty. And before that, when the Warning appears, the password field is always CHAP-PASSWORD so he doesn't insert the real password.
INSERT INTO ${postauth_table} (username, pass, reply) VALUES\ ('%{User-Name}','password','%{reply:Packet-Type}')"
But you're right, it's better with that. Thanks
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html