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