K, so the latest CVS will have it now?
The patch you gave me on Tuesday doesn't seem to help, Alan. Should I
contact you, or [EMAIL PROTECTED]?
Just to verify that I've followed the instructions:
# ls -al /source/radius/freeradius-current/src/modules/rlm_sql/sql.c
-rw-rw-r-- 1 root root 15348 Nov 1 11:08
/source/radius/freeradius-current/src/modules/rlm_sql/sql.c
#
## Here's from my sql.conf:
authorize_check_query = "SELECT id,UserName,Attribute,Value,op
FROM ${authcheck_table} WHERE Username = '%{SQL-User-Name}' O
RDER BY id"
authorize_reply_query = "SELECT id,UserName,Attribute,Value,op
FROM ${authreply_table} WHERE Username = '%{SQL-User-Name}' O
RDER BY id"
authorize_group_check_query = "SELECT
${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}
.Attribute,${g
roupcheck_table}.Value,${groupcheck_table}.op FROM
${groupcheck_table},${usergroup_table} WHERE ${usergroup_table}.Username
= '%{SQL
-User-Name}' AND ${usergroup_table}.GroupName =
${groupcheck_table}.GroupName ORDER BY ${groupcheck_table}.id"
authorize_group_reply_query = "SELECT
${groupreply_table}.id,${groupreply_table}.GroupName,${groupreply_table}
.Attribute,${g
roupreply_table}.Value,${groupreply_table}.op FROM
${groupreply_table},${usergroup_table} WHERE ${usergroup_table}.Username
= '%{SQL
-User-Name}' AND ${usergroup_table}.GroupName =
${groupreply_table}.GroupName ORDER BY ${groupreply_table}.id"
## Still get the same error:
rad_recv: Access-Request packet from host 216.7.221.3:53192, id=196,
length=77
User-Name = "fastw.hmv6618"
Password = "J\247\213\342"\313\233(\t\227\273+-\007\004"
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-IP-Address = 216.7.221.3
NAS-Port = 1
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
modcall[authorize]: module "suffix" returns ok
rlm_sql: Reserving sql socket id: 4
radius_xlat: 'fastw.hmv6618'
sql_escape in: 'fastw.hmv6618'
sql_escape out: 'fastw.hmv6618'
sql_set_user: escaped user --> 'fastw.hmv6618'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'fastw.hmv6618' ORDER BY id'
SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'fastw.hmv6618' ORDER BY id
Password = "d3Mc9T4"
Password = "d3Mc9T4"
Auth-Type = Local
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'fastw.hmv6618' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgrou
pcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'fastw.hmv6618' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = 'fastw.hmv6618' ORDER BY id'
SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'fastw.hmv6618' ORDER BY id
Service-Type = Framed-User
Service-Type = Framed-User
Framed-Protocol = PPP
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = 216.7.197.224
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = 216.7.197.224
Framed-IP-Netmask = 255.255.255.255
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'fastw.hmv6618' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrou
preply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'fastw.hmv6618' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: Released sql socket id: 4
rlm_sql: Pairs do not match [fastw.hmv6618]
modcall[authorize]: module "sql" returns notfound
modcall: group authorize returns ok
auth: No Auth-Type configuration for the request, rejecting the user
auth: Failed to validate the user.
Login incorrect: [fastw.hmv6618/d3Mc9T4] (from nas testhost1 port 1)
Sending Access-Reject of id 196 to 216.7.221.3:53192
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 196 with timestamp 3be1858f
Nothing to do. Sleeping until we see a request.
Ideas?
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of
> [EMAIL PROTECTED]
> Sent: November 1, 2001 12:04 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Auth failures
>
>
> "Jason Lixfeld" <[EMAIL PROTECTED]> wrote:
> > Here's the failure:
> >
> > Making static dynamic in rlm_counter...
> ...
> > rlm_counter.c: In function `counter_instantiate':
> > rlm_counter.c:246: too few arguments to function `dict_addattr'
>
> Hmm.. 'cvs update'. I've fixed it.
>
> Alan DeKok.
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
