Hi again. I've found my question many times in mailinglist archives, but not
suitable solution.
I keep receiving 'pairs do not match user'; in the end, follows copy of log.
I have installed sql tables from the FreeRadius template. Since I'm not
using crypt now, I tried to change 'Password' to 'User-Password' as
attribute in the sql, but still no joy.
Reading the log, it says
modcall[authorize]: module "sql" returns notfound
users: Matched DEFAULT at 85
modcall[authorize]: module "files" returns ok
modcall: group authorize returns ok
rad_check_password: Found Auth-Type system
auth: type "System"
(after the message about pairs was sent); of course, I don't have a module
'sql {' in radiusd.conf, and don't know how to build one. Then, in the end
of log, I see "Found Auth-Type System" (is this correct? in my
'authorization' section I'm trying sql, but the module doesn't exists, and
we start it all over..) Is this the problem?
But, according the log, rlm_sql is checking the sql tables after stripping
username - and in this phase I get the error message... Yet, no joy.
Where the error / missing config could be?
-- Fernando
rad_recv: Access-Request packet from host 192.168.1.25:1027, id=35,
length=75
Thread 1 assigned request 0
--- Walking the entire request list ---
Threads: total/active/spare threads = 5/1/4
Nothing to do. Sleeping until we see a request.
Thread 1 handling request 0, (1 handled so far)
User-Name = "ferds"
User-Password = "twister"
NAS-IP-Address = 192.168.1.25
NAS-Port = 2
NAS-Port-Type = Async
Service-Type = Framed-User
Framed-Protocol = PPP
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
rlm_realm: No '@' in User-Name = "ferds", looking up realm NULL
rlm_realm: No such realm NULL
modcall[authorize]: module "suffix" returns noop
radius_xlat: 'ferds'
rlm_sql (sql): sql_set_user escaped user --> 'ferds'
(...)
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'ferds' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql (sql): Pairs do not match for user [ferds]
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns notfound
users: Matched DEFAULT at 85
modcall[authorize]: module "files" returns ok
modcall: group authorize returns ok
rad_check_password: Found Auth-Type system
auth: type "System"
auth: Failed to validate the user.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
