(RADIATOR) Address Allocation from radius with SQL

[Hugh Irvine]

Hello Kadir -

You will need the following:

	AuthByPolicy ContinueWhileAccept

and you will also need an indication of the PoolHint.

See sections 6.43 and 6.64 in the Radiator 3.12 reference manual 
("doc/ref.html").

There is also an example in "goodies/addressallocator.cfg".

regards

Hugh


On 9 May 2005, at 23:16, Kadir Saruhan wrote:

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

NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive 
(www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

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