rlm_sql: Password in Accounting Packet

[Marco Stuhl]

Here's the scenario.

I'd like to make one username for all users having/sharing same service (e.g.
users w/ service A all have username 'foo' with unique password for every
user). Now, the problem arises with accounting, or, to be more precise,
session reports that will be available for them to see and check their past
sessions.

Since accounting (SQL schema) is based on unique username, I cannot make the
distinction between users. Also, I've noted (in past FR versions, though)
that it was possible for log files, since FR logged passwords there?


Thanks,
Marco


On 12/15/06, Thibault Le Meur <Thibault.LeMeur at supelec.fr> wrote:
>
>
>
> >>>Is there a way to insert password in radacct table?
> >>>Changing SQL query to insert %{User-Password} has no effect.
>
> >>I don't think your NAS sends a User-Password attribute in the Accounting
> >>Request. How do you want FR to know the User-Password attribute then ?
>
> >I agree on that one; still no workaround?
>
> I don't understand what you're trying to do.
> * If you want to record the user-password, why don't you record it at
> Authentication time (see the postauth section) ?
> * If you want to do this at during the Accounting process, you'll have do
> develop your own module to get the password that matches to the User-Login
> from the Accounting request: you will have to query your internal backend
> to
> get the user's password (if it is available in clear text, which is not
> certain).
>
> Can you be more specific as to why you are trying to do this... because
> there might be workarounds for this.
>
> Thibault
>
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20061215/e35dd3a8/attachment.html>