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.
