FreeRADIUS SQl Ippool problem -
Taz Manian
djtazie at hotmail.com
Thu Jun 28 14:03:56 CEST 2012
Hi Guys, Im having a problem with Ippools with freeradius2 and i cant seem to get any username to get an address from the pool.90% of the usernames will have static IP's but i want a few to be in a pool but i really am stumped - i tried putting username at realm
Framed-Pool
:=
EZPOOL into the radreply section and it gives me a reply when i test it # Standard Framed-Pool "EZPOOL" so i know is readying that - i then have a pool set up in
radippool pool_name=EZPOOLFramedIPAddress=192.168.1.200 (i have more) and my radiusd -X reply is : # Executing group from file /etc/raddb/sites-enabled/default
+- entering group PAP {...}
[pap] login attempt with password "1111111"
[pap] Using clear text password "1111111"
[pap] User authenticated successfully
++[pap] returns ok
# Executing section post-auth from file /etc/raddb/sites-enabled/default
+- entering group post-auth {...}
[sql] expand: %{User-Name} -> user at realm
[sql] sql_set_user escaped user --> 'username at realm'
[sql] expand: %{User-Password} -> 1111111
[sql] expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'username at realm', '1111111', 'Access-Accept', '2012-06-28 10:59:37')
rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'username at realm', '1111111', 'Access-Accept', '2012-06-28 10:59:37')
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql (sql): Released sql socket id: 2
++[sql] returns ok
++[exec] returns noop
Sending Access-Accept of id 51 to 192.168.1.100 port 52433
Framed-Pool := "EZPOOL"
Cisco-AVPair := "lcp:interface-config=ip vrf forwarding BLAH"
Cisco-AVPair += "lcp:interface-config=ip unnumbered Loopback1"
Cisco-AVPair += "lcp:interface-config=mtu 1492"
Service-Type := Framed-User
Framed-Protocol := PPP
Finished request 0.
Going to the next request
Waking up in 4.9 seconds.
Cleaning up request 0 ID 51 with timestamp +5
Ready to process requests.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20120628/2843a17d/attachment.html>
More information about the Freeradius-Users
mailing list