(RADIATOR) Authentication using the Calling-station-id

[Ashraf Al-Basti]

Dear,
we are but to use the radiator for a whole sale solution with a port 
restriction  option; so i have to authenticate the users using the 
calling-station-id and the realm instead of the username and password.
Is there anyway to do that, i have try the following put it didn't work 
and it goes in a loop if the authentication failed.

<AuthBy SQL>
        AuthSelect select PASSWORD, CHECKATTR from SUBSCRIBERS where 
VCVP = %{Calling-Station-Id}
        DBSource        dbi:Oracle:jip
        DBUsername      test
        DBAuth          ashraf

    </AuthBy>
 in the CHECKATTR i put Realm=abc.com and so
and the it working if match the query and will goes in the loop if failed

Thu May 29 07:09:48 2008: DEBUG: Packet dump:
*** Received from 192.168.1.246 port 1248 ....
Code:       Access-Request
Identifier: 1
Authentic:  <238><184>:<160><137><198><248>r<136><25><235>]<208>#<217>x
Attributes:
        User-Name = "smc at smc.com"
        NAS-IP-Address = 192.168.1.246
        Calling-Station-Id = "5238949"
        User-Password = 
=<184>J<232><188>l<13><224>4<215><22><200><145><209><24><143>

Thu May 29 07:09:48 2008: DEBUG: Handling request with Handler 
'Realm=DEFAULT'
Thu May 29 07:09:48 2008: DEBUG:  Deleting session for smc at smc.com, 
192.168.1.246,
Thu May 29 07:09:48 2008: DEBUG: Handling with Radius::AuthSQL:
Thu May 29 07:09:48 2008: DEBUG: Handling with Radius::AuthSQL:
Thu May 29 07:09:48 2008: DEBUG: Query is: 'select PASSWORD, CHECKATTR 
from SUBSCRIBERS where VCVP = 5238949':
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL looks for match with 
smc at smc.com [smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL REJECT: Check item 
realm expression 'ddd.com' does not match '' in request: smc at smc.com 
[smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Query is: 'select PASSWORD, CHECKATTR 
from SUBSCRIBERS where VCVP = 5238949':
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL looks for match with 
DEFAULT [smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL REJECT: Check item 
realm expression 'ddd.com' does not match '' in request: DEFAULT 
[smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Query is: 'select PASSWORD, CHECKATTR 
from SUBSCRIBERS where VCVP = 5238949':
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL looks for match with 
DEFAULT1 [smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL REJECT: Check item 
realm expression 'ddd.com' does not match '' in request: DEFAULT1 
[smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Query is: 'select PASSWORD, CHECKATTR 
from SUBSCRIBERS where VCVP = 5238949':
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL looks for match with 
DEFAULT2 [smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL REJECT: Check item 
realm expression 'ddd.com' does not match '' in request: DEFAULT2 
[smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Query is: 'select PASSWORD, CHECKATTR 
from SUBSCRIBERS where VCVP = 5238949':
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL looks for match with 
DEFAULT3 [smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL REJECT: Check item 
realm expression 'ddd.com' does not match '' in request: DEFAULT3 
[smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Query is: 'select PASSWORD, CHECKATTR 
from SUBSCRIBERS where VCVP = 5238949':
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL looks for match with 
DEFAULT4 [smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL REJECT: Check item 
realm expression 'ddd.com' does not match '' in request: DEFAULT4 
[smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Query is: 'select PASSWORD, CHECKATTR 
from SUBSCRIBERS where VCVP = 5238949':
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL looks for match with 
DEFAULT5 [smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL REJECT: Check item 
realm expression 'ddd.com' does not match '' in request: DEFAULT5 
[smc at smc.com]
Thu May 29 07:09:48 2008: DEBUG: Query is: 'select PASSWORD, CHECKATTR 
from SUBSCRIBERS where VCVP = 5238949':
Thu May 29 07:09:48 2008: DEBUG: Radius::AuthSQL looks for match with 
DEFAULT6 [


Please advice
Ashraf Al-Basti
 

--
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.