(RADIATOR) Address Allocation from radius with SQL

[Kadir Saruhan]

Hi, i want to allocate ip address from radius. When i run the following
configuration, in logs there is no reply attribute (framed ip address,
dns..).  

Trace 4 debug:
Code:       Access-Request
Identifier: 20
Authentic:        1115644412
Attributes:
        User-Name = "username"
        User-Password =
"z<17><160><165><142><230><3>'OD<141><196><187><169><233><242>"

Mon May  9 18:06:30 2005: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon May  9 18:06:30 2005: DEBUG: Rewrote user name to username
Mon May  9 18:06:30 2005: DEBUG:  Deleting session for username,
172.19.0.50,
Mon May  9 18:06:30 2005: DEBUG: Handling with Radius::AuthSQL
Mon May  9 18:06:30 2005: DEBUG: Handling with Radius::AuthSQL:
Mon May  9 18:06:30 2005: DEBUG: Query is: 'select PASSWORD from users
where USERNAME='username'':
Mon May  9 18:06:30 2005: DEBUG: Radius::AuthSQL looks for match with
username
Mon May  9 18:06:30 2005: DEBUG: Radius::AuthSQL ACCEPT:
Mon May  9 18:06:30 2005: DEBUG: Access accepted for username
Mon May  9 18:06:30 2005: DEBUG: Packet dump:
*** Sending to 172.19.0.50 port 1847 ....
Code:       Access-Accept 


My config:

<AddressAllocator SQL>
 Identifier myallocator
        DBSource        dbi:mysql:RADIUS
        DBUsername      xxxx
        DBAuth          xxxx

        <AddressPool pool1>
                Subnetmask      255.255.255.0
                DNSServer       213.243.1.40
                DNSServer       213.243.1.42
                Range   83.66.0.1 83.66.0.253
        </AddressPool>

</AddressAllocator>




<Realm DEFAULT>

RewriteUsername s/^([^@]+).*/$1/

<AuthBy SQL>

        DBSource        dbi:mysql:hostname=localhost:RADIUS
        DBUsername      doltcell
        DBAuth          DoLTcEll321

        AuthSelect select PASSWORD from users where USERNAME='%n'


</AuthBy>

<AuthBy DYNADDRESS>
        AddressAllocator myallocator
        MapAttribute    yiaddr, Framed-IP-Address
        MapAttribute    subnetmask, Framed-IP-Netmask
</AuthBy>



Kadir Saruhan
DOL System Administrator

ksaruhan at e-kolay.com
Tel: +90 212 498 35 16
Fax:+90 212 677 05 92
   www.e-kolay.net


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20050509/b01cfaeb/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 468_60_virus.gif
Type: image/gif
Size: 17866 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20050509/b01cfaeb/attachment.gif>