Thanks, this works a treat and its just what I needed. Is there anyway to strip the "\r\n" at the start and end of the Reply-Message before writing the TABLE, as it ends up in the tables as:- "=0D=0AYou are already logged in - access denied=0D=0A=0A" Thx Nev
hi, configure postauth_query in dialup.conf,
postauth_query="UPDATE POSTREPLY SET REPLYMESSAGE='%{reply:Reply-Message}' WHERE USERNAME='%{SQL-User-Name}' "
than , you can query the message from DB SERVER.
BTW: if reject user, then ...
# # Access-Reject packets are sent through the REJECT sub-section of the # post-auth section. # # Post-Auth-Type REJECT { %{sql:UPDATE POSTREPLY SET REPLYMESSAGE='%{reply:Reply-Message}' WHERE USERNAME='%{SQL-User-Name}' } }
Message: 1 Date: Sat, 16 Jan 2010 20:55:45 -0000 From: "Neville" <nev@itsnev.co.uk> Subject: Reply-Message To: <freeradius-users@lists.freeradius.org> Message-ID: <1C54F0ABDAFE4EF7B9F3F9D4EC3EFBAC@NevPC> Content-Type: text/plain; charset="iso-8859-1"
Hi,
Is there any way to get the reply message loaded into a SQL TABLE, which a user can then query on to see the last reply based on there username?
Thx Nev