Hello Lisa -
I will need to see the rest of the configuration file to see how this
clause is being used.And I must say I can't see how this is going to
work in any case.
thanks
Hugh
At 17:16 +0100 00/11/8, Lisa Goulet wrote:
>Hi All,
>
>The following AuthSelect statement for CLI authorization executes forever,
>can anyone see what I'm doing wrong? I've included part of the config, the
>table being queried and the log messages.
>
>----------------------------------
>
># check blacklist numbers
><AuthBy SQL>
> DBSource dbi:Pg:dbname=radmin;host=xxx.xxx.xxx.xxx
> DBUsername radmin
> DBAuth xxxxxx
> AuthSelect select LOGIN from BLACKLIST \
> where CLI <> '%{Calling-Station-Id}' \
> and LOGIN = 'ALLOWED'
> </AuthBy>
>
>----------------------------------
>
> Table "blacklist"
> Attribute | Type | Modifier
>-----------+-------------+----------
> cli | varchar(20) |
> login | varchar(20) |
>
>------------------------------------
>
> cli | login
>---------+-----------
> 9999999 | FORBIDDEN
> DEFAULT | ALLOWED
>
>-------------------------------------
>
>Wed Nov 8 16:54:39 2000: DEBUG: Radius::AuthRADMIN ACCEPT:
>Wed Nov 8 16:54:39 2000: DEBUG: do query is: insert into RADMESSAGES
>(TIME_STAMP, TYPE, MESSAGE) values (973698879, 4, 'Radiu
>s::AuthRADMIN ACCEPT: ')
>
>Wed Nov 8 16:54:39 2000: DEBUG: do query is: update RADUSERS set
>BADLOGINS=0 where USERNAME='lisa'
>
>Wed Nov 8 16:54:39 2000: DEBUG: Handling with Radius::AuthSQL
>Wed Nov 8 16:54:39 2000: DEBUG: Handling with Radius::AuthSQL
>Wed Nov 8 16:54:39 2000: DEBUG: Query is: select LOGIN from BLACKLIST where
>CLI <> '207505640' and LOGIN = 'ALLOWED'
>
>Wed Nov 8 16:54:39 2000: DEBUG: Radius::AuthSQL looks for match with lisa
>Wed Nov 8 16:54:39 2000: DEBUG: Radius::AuthSQL REJECT: Bad Password
>Wed Nov 8 16:54:39 2000: DEBUG: Query is: select LOGIN from BLACKLIST where
>CLI <> '207505640' and LOGIN = 'ALLOWED'
>
>
>Thanks in advance,
>Lisa
>
>===
>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.
--
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.
