Hi
First of all very sorry for such a long email. I have free-radius0.8.1 with
mysql 2.23.49 on solaris8. I am trying to get users authenticated from
database i.e.mysql using free-radius.
I am getting these two errors:
1) Pairs do not match for user [[EMAIL PROTECTED]]. what am I doing wrong at
there ( tried my best to get any clue from mailing list but no success)
2) these queries
rlm_sql_mysql: MYSQL check_error: 1065 received
rlm_sql (sql) sql_checksimul: Database query failed
are getting failed.
Here is the log
--------------
Ready to process requests.
rad_recv: Access-Request packet from host 204.xxx.xxx.xxxx:44582, id=55,
length=102
User-Name = '[EMAIL PROTECTED]'
User-Password = "test"
NAS-IP-Address = 206.xxx.xxx.xxxx
NAS-Port = 3188
Service-Type = Framed-User
Framed-Protocol = PPP
Called-Station-Id = "816xxxxxxx"
NAS-Port-Type = Async
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
rlm_chap: Could not find proper Chap-Password attribute in request
modcall[authorize]: module "chap" returns noop
modcall[authorize]: module "mschap" returns notfound
rlm_realm: Looking up realm test.comfor User-Name = '[EMAIL PROTECTED]'
rlm_realm: Found realm seriousisp.us
rlm_realm: Adding Stripped-User-Name = "test"
rlm_realm: Proxying request from user test to realm test.com
rlm_realm: Adding Realm = "test.com"
rlm_realm: Authentication realm is LOCAL.
rlm_realm: auth_port is not set. proxy cancelled
modcall[authorize]: module "suffix" returns noop
radius_xlat: '[EMAIL PROTECTED]'
rlm_sql (sql): sql_set_user escaped user --> '[EMAIL PROTECTED]'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = '[EMAIL PROTECTED]' 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 = '[EMAIL PROTECTED]'AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = '[EMAIL PROTECTED]'ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = '[EMAIL PROTECTED]' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): Pairs do not match for user [[EMAIL PROTECTED]]
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns notfound
users: Matched DEFAULT at 152
users: Matched DEFAULT at 171
users: Matched DEFAULT at 183
modcall[authorize]: module "files" returns ok
modcall: group authorize returns ok
rad_check_password: Found Auth-Type SQL
auth: type "SQL"
modcall: entering group authenticate
radius_xlat: '[EMAIL PROTECTED]'
rlm_sql (sql): sql_set_user escaped user --> '[EMAIL PROTECTED]'
rlm_sql (sql): sql_set_password escaped password --> 'test'
radius_xlat: ''
rlm_sql (sql): Reserving sql socket id: 3
Running SQL query:
rlm_sql_mysql: MYSQL check_error: 1065 received
rlm_sql (sql) sql_checksimul: Database query failed
rlm_sql (sql): Released sql socket id: 3
modcall[authenticate]: module "sql" returns fail
modcall: group authenticate returns fail
module authenticate result is -1
auth: Failed to validate the user.
Delaying request 0 for 1 seconds
Finished request 0
Going to the next request
----------------------------------
I will really appreciate any help on it.
Shohab
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
