Hi,<br>I'm using freeradius to assign ip to my vpn clients.<br>so I've configured sqlippool to bind ips to my users and groups.<br>and in pptpd.conf I choose not to assign ip in pptpd.<br>but connections to pptpd fails ( from win xp ) with error: no assigned ip.
<br><br>what's wrong in my configurations?<br><br>my DB state:<br><br>insert into radcheck ( username , attribute , op , value ) values ( 'newuser3' , 'Cleartext-Password' , ':=' , 'newpass3');
<br>insert into usergroup (username , groupname ) values ( 'newuser3' , 'offpart1');<br>insert into radgroupcheck ( groupname , attribute , op , value ) values ('offpart1' , 'Pool-Name' , ':=' , '1515');
<br>insert into radippool ( 'pool_name' , 'framedipaddress' ) values ('1515','<a href="http://10.15.15.3">10.15.15.3</a>');<br><br>it's the output of debug mod:<br><br>rad_recv: Access-Request packet from host
<a href="http://127.0.0.1:34045">127.0.0.1:34045</a>, id=149, length=148<br> Service-Type = Framed-User<br> Framed-Protocol = PPP<br> User-Name = "newuser3"<br> MS-CHAP-Challenge = 0xc2af22b4941ad3a9f8ffba6ca9793eea
<br> MS-CHAP2-Response = 0x220069907d4b717d6e15a59053bead0f51900000000000000000283b13c9c3bd7f543ae7385f6b5749cb18330955aade9ea7<br> Calling-Station-Id = "xx.xx.xx.xx"<br> NAS-IP-Address = <a href="http://127.0.0.1">
127.0.0.1</a><br> NAS-Port = 0<br> Processing the authorize section of radiusd.conf<br>modcall: entering group authorize for request 8<br> modcall[authorize]: module "preprocess" returns ok for request 8
<br> modcall[authorize]: module "chap" returns noop for request 8<br> rlm_mschap: Found MS-CHAP attributes. Setting 'Auth-Type = mschap'<br> modcall[authorize]: module "mschap" returns ok for request 8
<br> rlm_realm: No '@' in User-Name = "newuser3", looking up realm NULL<br> rlm_realm: No such realm "NULL"<br> modcall[authorize]: module "suffix" returns noop for request 8<br>
rlm_eap: No EAP-Message, not doing EAP<br> modcall[authorize]: module "eap" returns noop for request 8<br> users: Matched entry DEFAULT at line 173<br> users: Matched entry DEFAULT at line 185<br> modcall[authorize]: module "files" returns ok for request 8
<br>radius_xlat: 'newuser3'<br>rlm_sql (sql): sql_set_user escaped user --> 'newuser3'<br>radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'newuser3' ORDER BY id'
<br>rlm_sql (sql): Reserving sql socket id: 0<br>radius_xlat: 'SELECT <a href="http://radgroupcheck.id">radgroupcheck.id</a>,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'newuser3' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY <a href="http://radgroupcheck.id">radgroupcheck.id</a>'<br>radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'newuser3' ORDER BY id'
<br>radius_xlat: 'SELECT <a href="http://radgroupreply.id">radgroupreply.id</a>,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username
= 'newuser3' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY <a href="http://radgroupreply.id">radgroupreply.id</a>'<br>rlm_sql (sql): Released sql socket id: 0<br> modcall[authorize]: module "sql" returns ok for request 8
<br>rlm_pap: Found existing Auth-Type, not changing it.<br> modcall[authorize]: module "pap" returns noop for request 8<br>modcall: leaving group authorize (returns ok) for request 8<br> rad_check_password: Found Auth-Type MS-CHAP
<br>auth: type "MS-CHAP"<br> Processing the authenticate section of radiusd.conf<br>modcall: entering group MS-CHAP for request 8<br> rlm_mschap: Told to do MS-CHAPv2 for newuser3 with NT-Password<br>rlm_mschap: adding MS-CHAPv2 MPPE keys
<br> modcall[authenticate]: module "mschap" returns ok for request 8<br>modcall: leaving group MS-CHAP (returns ok) for request 8<br> Processing the post-auth section of radiusd.conf<br>modcall: entering group post-auth for request 8
<br>rlm_sqlippool: Framed-IP-Address already exists<br> modcall[post-auth]: module "sqlippool" returns noop for request 8<br>rlm_sql (sql): Processing sql_postauth<br>radius_xlat: 'newuser3'<br>rlm_sql (sql): sql_set_user escaped user --> 'newuser3'
<br>radius_xlat: 'INSERT into radpostauth (user, pass, reply, date) values ('newuser3', 'Chap-Password', 'Access-Accept', NOW())'<br>rlm_sql (sql) in sql_postauth: query is INSERT into radpostauth (user, pass, reply, date) values ('newuser3', 'Chap-Password', 'Access-Accept', NOW())
<br>rlm_sql (sql): Reserving sql socket id: 3<br>rlm_sql (sql): Released sql socket id: 3<br> modcall[post-auth]: module "sql" returns ok for request 8<br>modcall: leaving group post-auth (returns ok) for request 8
<br>Sending Access-Accept of id 149 to <a href="http://127.0.0.1">127.0.0.1</a> port 34045<br> Framed-IP-Address = <a href="http://255.255.255.254">255.255.255.254</a><br> Framed-MTU = 576<br> Service-Type = Framed-User
<br> Framed-Protocol = PPP<br> Framed-Compression = Van-Jacobson-TCP-IP<br> MS-CHAP2-Success = 0x22533d36413732333834453141433843323544364432373245454244333734303038463238363630453439<br> MS-MPPE-Recv-Key = 0x0d42ffa8adfe8471a692876c86a6b26d
<br> MS-MPPE-Send-Key = 0x5110ed91d6d36bb4c9d44e2a0f6367e1<br> MS-MPPE-Encryption-Policy = 0x00000001<br> MS-MPPE-Encryption-Types = 0x00000006<br>Finished request 8<br>Going to the next request<br>--- Walking the entire request list ---
<br>Waking up in 6 seconds...<br>--- Walking the entire request list ---<br>Cleaning up request 8 ID 149 with timestamp 4760fe8f<br>Nothing to do. Sleeping until we see a request.<br> <br><br>