rlm_sql: usergroup lookup if User-Profile is defined

[Bjørn Mork]

Hello,

I am wondering if I'm the only one who finds the following default
behaviour a bit confusing:  Given a user defined like this:

 user1 Cleartext-Password := "foo", User-Profile := "profile1"

I would expect "profile1" to always be looked up in the the usergroup
table for this user.  However, this won't happen if "user1" is defined
in that table without Fall-Through.  rlm_sql will lookup "user1" first
and only lookup "profile1" if either "user1" is not found or
Fall-Through is set vy the "user1" groups.


Bjørn

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Status X User

[Alexander Clouter]

Sergio Belkin  wrote:
>
> 2009/10/23 Alexander Clouter :
>
>> Sergio Belkin  wrote:
>>>
>>> Is there a way to get the las time that user got Accept-Accept and
>>> Accept-Reject, of course I can parse log files but I wonder if there a
>>> radius tool that can do it.
>>>
>>  -> SQL
>>
>> SELECT * FROM postauth WHERE user_name = '' AND packet_type = 
>> 'Access-Reject' ORDER BY timestamp DESC LIMIT 1
>>
>> Then for the latter replace 'Access-Accept' with 'Access-Reject'?
>>
> 
> Ooops, I have no mysql
>
That is a *good* thing, use PostgreSQL...

> except that there is a way to dump log files to mysql database :)
> 
> Sorry if the question sounds stupid :)
>
It is, thats why there is documentation...

http://freeradius.org/radiusd/man/rlm_sql.html

Cheers

-- 
Alexander Clouter
.sigmonster says: Read the fine print.

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html