Hello everyone and sorry cause this is gonna be a little bit long , I am having a problem making Freeradius , Dialup Admin and Mysql work correctly .
I am using Freeradius v 0.8.1 and mysql verion 3.23.49 in a RedHat 7.3 Linux . I had no problem setting up radius to work authenticating from "users" file , and from mysql using a very good tutorial from "http://www.frontios.com/freeradius.html"; . After I installed and start using Dialup Admin I can't get it to work. The passwords stored in mysql are encrypted in a strange way . For example using crypt encryption the password stored in the database is this : "$1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0" After learning a little bit about crypt and md5 encryption I can say that this doesn't look correct to me . I run the following little script for the same password and using "st" as salt for the encryption . perl -e 'print crypt( "asd123", "st"),"\n";' stn/LmaCw8SMU I changed a little bit the ./lib/crypt/crypt.php3 in order to give me the correct encrypted password but it still doesn't work . I use the radtest program to check the authentication . Here is the log I get when running radiusd -X : -----------------------RadiusLog---------------------------------- rad_recv: Access-Request packet from host 127.0.0.1:1033, id=211, length=56 User-Name = "szax" User-Password = "asd123" NAS-IP-Address = 255.255.255.255 NAS-Port = 11 modcall: entering group authorize modcall[authorize]: module "preprocess" returns ok rlm_realm: No '@' in User-Name = "szax", looking up realm NULL rlm_realm: No such realm NULL modcall[authorize]: module "suffix" returns noop radius_xlat: 'szax' rlm_sql (sql): sql_set_user escaped user --> 'szax' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'szax' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'szax' ORDER BY id radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'szax' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' rlm_sql_mysql: query: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'szax' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'szax' ORDER BY id' rlm_sql_mysql: query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'szax' ORDER BY id radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'szax' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql_mysql: query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'szax' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id rlm_sql (sql): Pairs do not match for user [szax] rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns notfound modcall: group authorize returns ok auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user auth: Failed to validate the user. Delaying request 0 for 1 seconds Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Waking up in 1 seconds... --- Walking the entire request list --- Sending Access-Reject of id 211 to 127.0.0.1:1033 Waking up in 4 seconds... --- Walking the entire request list --- Cleaning up request 0 ID 211 with timestamp 3efaa83e Nothing to do. Sleeping until we see a request. --------------------------Radius Log--------------------------------- I think that the problem is in this line : "rlm_sql (sql): Pairs do not match for user [szax]" If however I edit the Value field in radcheck table and replace it with a plain text password it works ok . If anyone understand what is going wrong and could give me a hint , I would very much appreciate it cause I am running out of time for this project ... Thanx in advance . -- Nickitas <[EMAIL PROTECTED]> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
