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" <[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
