<div dir="ltr">Hi<div>I did setup pptpd with freeradius + mysql <a href="http://poptop.sourceforge.net/dox/radius_mysql.html">http://poptop.sourceforge.net/dox/radius_mysql.html</a>.</div><div>pptpd "poptop" works fine without freeradius, with freeradius and mysql, all seems fine apart from me not knowing what values to enter into the mysql tables of freeradius.</div>
<div><br></div><div>With no entries in database I get </div><div><br></div><div><div>Ready to process requests.</div><div><br></div><div>rad_recv: Access-Request packet from host <a href="http://127.0.0.1:45194">127.0.0.1:45194</a>, id=198, length=67</div>
<div> Service-Type = Framed-User</div><div> Framed-Protocol = PPP</div><div> User-Name = "test"</div><div> Calling-Station-Id = "193.227.186.146"</div><div> NAS-IP-Address = 127.0.0.1</div>
<div> NAS-Port = 0</div><div> Processing the authorize section of radiusd.conf</div><div>modcall: entering group authorize for request 0</div><div> modcall[authorize]: module "preprocess" returns ok for request 0</div>
<div> rlm_realm: No '@' in User-Name = "test", looking up realm NULL</div><div> rlm_realm: No such realm "NULL"</div><div> modcall[authorize]: module "suffix" returns noop for request 0</div>
<div>radius_xlat: 'test'</div><div>rlm_sql (sql): sql_set_user escaped user --> 'test'</div><div>radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'test' ORDER BY id'</div>
<div>rlm_sql (sql): Reserving sql socket id: 4</div><div>rlm_sql (sql): User test not found in radcheck</div><div>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 = 'test' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY <a href="http://radgroupcheck.id">radgroupcheck.id</a>'</div>
<div>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 = 'test' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY <a href="http://radgroupreply.id">radgroupreply.id</a>'</div>
<div>rlm_sql (sql): User test not found in radgroupcheck</div><div>rlm_sql (sql): Released sql socket id: 4</div><div>rlm_sql (sql): User not found <#######################</div><div> modcall[authorize]: module "sql" returns notfound for request 0</div>
<div> modcall[authorize]: module "mschap" returns noop for request 0</div><div>modcall: leaving group authorize (returns ok) for request 0</div><div>auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user</div>
<div>auth: Failed to validate the user.</div><div>Delaying request 0 for 1 seconds</div><div>Finished request 0</div><div>Going to the next request</div><div>--- Walking the entire request list ---</div><div>Waking up in 1 seconds...</div>
<div>--- Walking the entire request list ---</div><div>Waking up in 1 seconds...</div><div>--- Walking the entire request list ---</div><div>Sending Access-Reject of id 198 to 127.0.0.1 port 45194</div><div>Waking up in 4 seconds...</div>
<div>--- Walking the entire request list ---</div><div>Cleaning up request 0 ID 198 with timestamp 4fbc8c9d</div></div><div><br></div><div><br></div><div>When I do add to radcheck -</div><div><br></div><div><div>INSERT INTO `radcheck` (`id`, `UserName`, `Attribute`, `op`, `Value`) VALUES</div>
<div>(11, 'test', 'Chap-Password', '==', 'test');</div></div><div><br></div><div> I get </div><div><br></div><div><div>rad_recv: Access-Request packet from host <a href="http://127.0.0.1:46882">127.0.0.1:46882</a>, id=199, length=67</div>
<div> Service-Type = Framed-User</div><div> Framed-Protocol = PPP</div><div> User-Name = "test"</div><div> Calling-Station-Id = "193.227.186.146"</div><div> NAS-IP-Address = 127.0.0.1</div>
<div> NAS-Port = 0</div><div> Processing the authorize section of radiusd.conf</div><div>modcall: entering group authorize for request 1</div><div> modcall[authorize]: module "preprocess" returns ok for request 1</div>
<div> rlm_realm: No '@' in User-Name = "test", looking up realm NULL</div><div> rlm_realm: No such realm "NULL"</div><div> modcall[authorize]: module "suffix" returns noop for request 1</div>
<div>radius_xlat: 'test'</div><div>rlm_sql (sql): sql_set_user escaped user --> 'test'</div><div>radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'test' ORDER BY id'</div>
<div>rlm_sql (sql): Reserving sql socket id: 3</div><div>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 = 'test' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY <a href="http://radgroupcheck.id">radgroupcheck.id</a>'</div>
<div>radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'test' ORDER BY id'</div><div>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 = 'test' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY <a href="http://radgroupreply.id">radgroupreply.id</a>'</div>
<div>rlm_sql (sql): Released sql socket id: 3</div><div>rlm_sql (sql): No matching entry in the database for request from user [test]</div><div> modcall[authorize]: module "sql" returns notfound for request 1</div>
<div> modcall[authorize]: module "mschap" returns noop for request 1</div><div>modcall: leaving group authorize (returns ok) for request 1</div><div>auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user <#################</div>
<div>auth: Failed to validate the user.</div><div>Delaying request 1 for 1 seconds</div><div>Finished request 1</div><div>Going to the next request</div><div>--- Walking the entire request list ---</div><div>Waking up in 1 seconds...</div>
<div>--- Walking the entire request list ---</div><div>Waking up in 1 seconds...</div><div>--- Walking the entire request list ---</div><div>Sending Access-Reject of id 199 to 127.0.0.1 port 46882</div><div>Waking up in 4 seconds...</div>
<div>--- Walking the entire request list ---</div><div>Cleaning up request 1 ID 199 with timestamp 4fbc8d01</div><div>Nothing to do. Sleeping until we see a request.</div></div><div><div dir="ltr"><div><div><div><div></div>
</div></div></div></div><br>
</div><div><br></div><div>I am lost here, please advice.</div></div>