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" <[email protected]>
>Subject: Reply-Message
>To: <[email protected]>
>Message-ID: <1c54f0abdafe4ef7b9f3f9d4ec3ef...@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
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL:
><https://lists.freeradius.org/pipermail/freeradius-users/attachments/20100116/14c5b8db/attachment.html>
>
>------------------------------
>
>Message: 2
>Date: Sat, 16 Jan 2010 13:15:58 -0800
>From: "Tim Sylvester" <[email protected]>
>Subject: RE: Reply-Message
>To: "'FreeRadius users mailing list'"
> <[email protected]>
>Message-ID: <[email protected]>
>Content-Type: text/plain; charset="us-ascii"
>
>You can put an entry for the Reply-Message attribute in the radreply table.
>For example, if you want to send the message "Hi Bob" to user bob, you would
>add this entry to radreply:
>
>
>
>username attribute op value
>
>"bob" "Reply-Message" ":=" "Hi Bob"
>
>
>
>The Reply-Message attribute will be sent back in the Access-Accept packet
>sent back to the NAS. Of course, this assumes that you have FreeRADIUS
>configured to use SQL, which is documented in the raddb/sql.conf file and
>http://wiki.freeradius.org/SQL_HOWTO.
>
>
>
>Tim
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
