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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html