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