MySql Authentication problems

This is a discussion on MySql Authentication problems within the FreeRADIUS Users forums, part of the Networking and Network Related category; I am using FreeRadius 1.0.2 with mySql on a Fedora Core3 machine. I am = using the default encryption ...


Go Back   Usenet Forums > Networking and Network Related > FreeRADIUS Users

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-23-2005
James Ecker
 
Posts: n/a
Default MySql Authentication problems

I am using FreeRadius 1.0.2 with mySql on a Fedora Core3 machine. I am =
using
the default encryption method.=20

I have setup FreeRadius to successfully connect to mySql. I can =
successfully
enter new users in through the dialup_admin web page, but when I "Check
Password" the response I get, is "NO It is wrong." When I do the radtest =
the
server responds back to the client with:

Sending Access-Request of id 125 to 192.168.1.104:1812
User-Name =3D "test"
User-Password =3D "test"
NAS-IP-Address =3D localhost.localdomain
NAS-Port =3D 1812
rad_recv: Access-Reject packet from host 192.168.1.104:1812, id=3D125,
length=3D20



On the server side:


rad_recv: Access-Request packet from host 192.168.1.104:32769, id=3D187,
length=3D56
User-Name =3D "test"
User-Password =3D "test"
NAS-IP-Address =3D 255.255.255.255
NAS-Port =3D 1812
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 1
modcall[authorize]: module "preprocess" returns ok for request 1
modcall[authorize]: module "chap" returns noop for request 1
modcall[authorize]: module "mschap" returns noop for request 1
rlm_realm: No '@' in User-Name =3D "test", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[authorize]: module "suffix" returns noop for request 1
radius_xlat: 'test'
rlm_sql (sql): sql_set_user escaped user --> 'test'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username =3D 'test' ORDER BY id' rlm_sql (sql): Reserving sql socket id: =
3
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupc heck.Attribute,radgroup=
che
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username =3D 'test' AND usergroup.GroupName =3D
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username =3D 'test' ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupr eply.Attribute,radgroup=
rep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username =3D 'test' AND usergroup.GroupName =3D
radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): =
Released
sql socket id: 3
modcall[authorize]: module "sql" returns ok for request 1
modcall: group authorize returns ok for request 1
auth: type Local
auth: user supplied User-Password does NOT match local User-Password
auth: Failed to validate the user.
Login incorrect: [test/test] (from client localhost port 1812) Delaying
request 1 for 1 seconds Finished request 1 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 187 to 192.168.1.104:32769
Waking up in 4 seconds...
--- Walking the entire request list ---
Cleaning up request 1 ID 187 with timestamp 421a8970
Nothing to do. Sleeping until we see a request.



I am not sure but I believe the problem is in this area:=20

modcall: entering group authorize for request 1
modcall[authorize]: module "preprocess" returns ok for request 1
modcall[authorize]: module "chap" returns noop for request 1
modcall[authorize]: module "mschap" returns noop for request 1

If so, how can I fix the problem?


I realize there must be an encryption setting that is wrong, so any help
with is greatly appreciated.

James Ecker
MCSE + Internet, CNE, A+, Network+




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


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:22 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0