maybe this isn't that creative, but i cannot seem to get the logic to 
work.  I have an AUTHBY RADIUS that works perfectly.  However, it is too 
slow.  To make it faster Hugh told me to try the AUTHBY SQLRADIUS idea, and 
so here I am.

I need an AUTHBY SQLRADIUDS / HostSelect that will be able to handle the 
AUTHBY RADIUS below:

        <AuthBy RADIUS>
                Identifier CheckRemoteRadius
                IgnoreAccounting
                IgnoreReplySignature
                ServerHasBrokenAddresses
                RejectEmptyPassword
                NoForwardAccounting
                NoDefault
                        
                 #USERNAME = username
                 #PASSWORD = password
                <Host xxx.xxx.xxx.xxx>
                        Secret xxxx
                        AuthPort 1812
                        Retries 3
                        RetryTimeout 20
                </Host>
                # FAILOVER SERVER
                <Host xxx.xxx.xxx.xxx>
                        Secret xxxx
                        AuthPort 1812
                        Retries 3
                        RetryTimeout 20
                </Host>
        ReplyHook file:"/usr/local/radiator/hooks/AllocateIPAddressOnReplyFromProxy"
        # FILTER NAME: STATIC-ALLOW
        AllowInReply Framed-IP-Address,Session-Timeout,Ascend-Data-Filter,Idle-Timeout
        AddToReply 
Service-Type=Framed-User,Framed-Protocol=PPP,Framed-Netmask=255.255.255.255
        </AuthBy>

I have been able to get some information from the radiator documentation 
and I have gotten this far:

<AuthBy SQLRADIUS>
         Identifier CheckRemoteRadius
         IgnoreAccounting
         IgnoreReplySignature
         ServerHasBrokenAddresses
         RejectEmptyPassword
         NoForwardAccounting
         NoDefault
         NumHosts 4
         HostSelect select TARGET_%0_AUTH, SHARED_SECRET, PORT, RETRIES, 
TIMEOUT from PROXY2 where TARGET_%0_AUTH<>"" and DNIS=
substring('%{Called-Station-Id',7,4) and REALM='' and STATUS=1;
         replyHook 
file:"/usr/local/radiator/hooks/AllocateIPAddressOnReplyFromProxy"
</AuthBy>

However, I run across a couple problems:
1) When I restart radius I get this error: WARNING: No Hosts defined for 
Radius::AuthSQLRADIUS at /etc/radius.cfg line 120.  Did I forget 
something?  I am assuming I Need to tell the AUTHBY SQLRADIUS what database 
to use...
2) Can I dynamically load the IP address that is allocated based on the 
replyHook?  Currently the IP address is allocated via the Handler.  I need 
a way to pick the IP address out of different pools in the AUTHBY SQLRADIUS.
3) Can I dynamically load the AllowInReply and AddToReply attributes?  As 
you see in the first AUTHBY RADIUS the attributes are there.  However, in 
the AUTHBY SQLRADIUS they are not.  They would need to be assigned by the DNIS.

Any help would be greatly appreciated.

katen


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to