Hello Steve -
>
> I'm having a few problems with the sql session database. Below is my
> config. What I wish to do is have it use '%U' for the username, and as
> such I put in AddQuery and CountQuery as needed. The username still
> shows as '%n' in the table however. In order to track the usernames
> correctly I changed it (temporarily) to '${Class}' which you can see
> below. This change does work correctly, however what I ultimately need
> is all authenticated usernames after all rewrites without realms for the
> session database (I have Class defined for accounting where I do want to
> track realms for my roaming customers who use Megapop for national
> access).
>
> So it appears that the standard run time special characters are not
> recognized by AddQuery? Can someone else duplicate and verify this or is
> it just something with my current configuration? Below is my config
> file.
>
As your queries use special characters elsewhere and all of them work, the
problem cannot be with the special character handling.
However, you have to keep in mind what is happening here. You are doing your
rewrites *only* for authentication, and as the session database is updated
*only* by accounting packets, the usernames are not being rewritten for it.
The reason the Class attribute works is because you are saving the rewritten
username in that attribute (sent to the NAS), which is being returned
subsequently by the NAS in the accounting packets.
In general that is exactly how the Class attribute should be used, so I
suggest you consider using it for all usernames.
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
