Neville,
my postauth_query is:
postauth_query = "INSERT INTO ${postauth_table} (username, reply,
accttime, message) VALUES ('%{SQL-User-Name}', '%{reply:Packet-Type}',
TO_DATE('
%S','yyyy-mm-dd hh24:mi:ss'),
'%{%{Module-Failure-Message}:-%{%{reply:Reply-Message}:-Your generic
message}}')" ----> Adjust accttime for MySQL
with this you can catch the error message of the module that reject the
user, then the reply message and as last chance a generic message. you
can swap %{Module-Failure-Message} with %{reply:Reply-Message} if your
reply message is more important
to strip "\r\n" in modules/attr_rewrite I added:
attr_rewrite sanereplymessage {
attribute = Reply-Message
# may be "packet", "reply", "proxy", "proxy_reply" or "config"
searchin = reply
searchfor = "\n|\r"
replacewith = ""
ignore_case = no
new_attribute = no
max_matches = 10
## If set to yes then the replace string will be
## appended to the original string
append = no
}
and in sites-enables/default
Post-Auth-Type REJECT {
..
sanereplymessage
sql
..
}
Andrea
Neville ha scritto:
> 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
>
--
----------------------------------------------------------------
Somewhere in the world there's somebody better than me... but I haven't
met him yet.
----------------------------------------------------------------
Ing. Andrea Gabellini
Email: [email protected]
Skype: andreagabellini
Tel: (+378) 0549 886111
Fax: (+378) 0549 886188
Telecom Italia San Marino S.p.A.
Strada degli Angariari, 3
47891 Rovereta
Republic of San Marino
http://www.telecomitalia.sm
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
