Check the archives, I covered this last week in detail for PostgreSQL, but you
are see the same problem in MySQL.


You don't need to have an "Auth-Type" entry in the "users" file or SQL entries.

If you don't include an "Auth-Type" entry, then User-Password = 'cleartextpassword'
and Crypt-Password = 'encryptedpassword' will both work. I have verified this in CVS
so it will be ready for v1.0 for sure.


Ciolo_-^DusT^-_WebMaster wrote:

The following is the output of radiusd -X
I think that maybe the problems can be in Authtype
-----------------------------------------------
rad_recv: Access-Request packet from host xx.xx.xx.xx:3081, id=0, length=45
       User-Name = "Bingo"
       User-Password = "123prova"
modcall: entering group authorize for request 0
 modcall[authorize]: module "preprocess" returns ok for request 0
 modcall[authorize]: module "chap" returns noop for request 0
   rlm_realm: No '@' in User-Name = "Bingo", looking up realm NULL
   rlm_realm: No such realm "NULL"
 modcall[authorize]: module "suffix" returns noop for request 0
radius_xlat:  'Bingo'
rlm_sql (sql): sql_set_user escaped user --> 'Bingo'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'Bingo' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat:  'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'Bingo' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = 'Bingo' ORDER BY id'
radius_xlat:  'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE
usergroup.Username = 'Bingo' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): Released sql socket id: 4
 modcall[authorize]: module "sql" returns ok for request 0
 modcall[authorize]: module "mschap" returns noop for request 0
modcall: group authorize returns ok for request 0
auth: type Local
---------------------------


I think that the problem can be here ... When I use sql db ... which kind of auth: type I have to set? and where I have to set it?



------------------------------
auth: user supplied User-Password does NOT match local User-Password
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 0 to xx.xx.xx.xx:3081
Waking up in 4 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 0 with timestamp 402e30da
Nothing to do.  Sleeping until we see a request.





- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to