(RADIATOR) Users Blacklists

[wilco heinneman]

Hi *,


Also close, but not quite there ;-)

All of this are only my thoughts, but you Hugh are the expert.


In the select statement of Hugh, you should forget about the quotes 
around "REJECT":

    AuthSelect select REJECT from BLACKLIST \
                where USERNAME='%n'


or do it like Rolando and leave the quotes:

    AuthSelect select "REJECT: This user is on the BLACKLIST" from \
               BLACKLIST where USERNAME='%n'

Then you need only one column in the table BLACKLIST:

USERNAME
someuser
anotheruser



If all of this is right, I could make a check I need:

AuthSelect select "REJECT: You should choose channel one" from \
            RADONLINE_CHANNEL1 where count(*) < 10


This should do the following :
You cannot get Authorized on other Channels if the amount of users on 
Channel 1 is less then 10.










Hugh Irvine wrote:
> Hello Rolando -
> 
> You are close, but not quite there.
> 
> Here is what to do:
> 
> # Check-Users file
> # ENTRADA default para chequear la tabla BLACKLIST
> 
> DEFAULT         Auth-Type = VE_blacklist
> 
> DEFAULT	Auth-Type = Accept
> 
> 
> Your BLACKLIST SQL table should contain this:
> 
> USERNAME	REJECT
> 
> someuser	Auth-Type = "Reject: This user is on the BLACKLIST"
> 
> anotheruser	Auth-Type = "Reject: This user is on the BLACKLIST"
> 
> 
> Here is a snippet of my radius.cfg
> 
> ----------------------
> 
> <AuthBy SQL>
>         Identifier VE_blacklist
>         DBSource        ......
>         DBUsername    ......
>         DBAuth          ......
>         AuthSelect select "REJECT" from BLACKLIST \
>                    where USERNAME='%n'
>         AuthColumnDef 0, GENERIC, check
>         AccountingTable
> </AuthBy>
> 




-- 
--
Met vriendelijke groet / Kind regards

Wilco Heinneman
Technisch Directeur
Zoranet internet diensten b.v.

Hanzelaan 288a
8017 JJ  Zwolle

Tel: +31 (0) 38 4559560
Fax: +31 (0) 38 4551402

========================================
Dit emailbericht is gecontroleerd op
virussen door www.tipi-opensystems.com.
This email hase been checked for viruses
by www.tipi-opensystems.com
========================================


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.