SQL log accounting and post_auth
Guillaume Chartrand
guillaume.chartrand at Collanaud.Qc.Ca
Wed Apr 16 21:46:31 CEST 2008
I re and reread man unlang
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}')"
It's the value chap-password who's corrected. So for the fix, please
update the insert for the correct value
Thank
>> For the post_auth it can be userful to other person if it's
integrated to the next update of freeradius.
>noted - fix and updated has been submitted as bug 545
Just for notice, I have again the warning in debug mode when I do the
post_auth queries
rlm_sql (sql): Processing sql_postauth
expand: %{User-Name} -> guillaume
rlm_sql (sql): sql_set_user escaped user --> 'guillaume'
WARNING: Deprecated conditional expansion ":-". See "man unlang" for
details
expand: INSERT INTO radpostauth (username, pass, reply) VALUES
('%{User-Name}',
'%{User-Password:-Chap-Password}','%{reply:Packet-Type}') -> INSERT INTO
radpostauth (username, pass, reply) VALUES ('guillaume',
'Chap-Password','Access-Accept')
expand: /usr/local/var/log/radius/sqltrace.sql ->
/usr/local/var/log/radius/sqltrace.sql
And I don't know what is it. And it's fot the post_auth. The post_auth
have just this
post-auth {
sql
}
Thank again
>alan
>-
>List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
More information about the Freeradius-Users
mailing list