Reject user from SQL-DB

[Phil Mayers]

JB wrote:
> Hi,
> 
> I'm afraid I'm currently not seeing the wood for the trees, please help 
> me out. ;-)
> 
> I'm using stored procedures in MySQL to query for check and reply items 
> for users. I don't need (or want) user groups so there's always a 
> positive Fall-Through attribute returned.

Be aware that unless you are using FreeRadius 2.0, the Fall-Through 
attribute does not affect SQL group processing; see here:

http://marc.info/?l=freeradius-users&m=119010719300080&w=2

> 
> There are quite a few possibilities why a user can get rejected: Wrong 
> login, banned from this location, generally blocked, session 
> time/timespan exceeded and so on...
> As a result of the information gathered in these stored procedures I 
> know whether the user may connect or not.
> My question: What attributes do I have to return from MySQL to reject 
> this user??? Am I getting my wires crossed?

Return:

  attr = 'Auth-Type'
  op = ':='
  value = 'Reject'

> 
> Thanks a lot!
> JB
> 
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html