Thanks Dirk but it seems that I have no more result from "Authorise"
Section, what I can see in DEBUG is:
...
rlm_sql: Pairs do not match [guetali000]
rlm_sql: Released sql socket id: 4
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.
.
Nicolas
- Original Message -
From: "Dirk Tanneberger" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 8:11 PM
Subject: Re: MySQL, again and again ...
> Hello,
>
> I had the same problem for few day and I have fixed it with
> the following config:
>
> authorize {
> preprocess
> suffix
> sql
> }
>
> authenticate {
> }
>
> preacct {
> suffix
> preprocess
> }
>
> accounting {
> detail
> unix
> sql
> radutmp
> }
>
> Now Authentication with mysql works fine.
>
> Dirk Tanneberger
>
>
> - Original Message -
> From: "Nicolas Blanc" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 09, 2002 4:41 PM
> Subject: MySQL, again and again ...
>
>
> > Hi everybody,
> >
> > First, my freeradius daemon doesn't want any SQL module in authenticate
> > section, Why
> >
> > Second, even in Authorise section, my user isn't found, so I'm obliged
to
> > add the "File" module
> > Someone could give me a help, give me a config, ?
> >
> > Nicolas
> > PS: Here are my main parameters and debug output:
> > - radiusd.conf (v 0.5):
> > authorize {
> > files
> > sql
> > }
> > authenticate {
> > unix
> > }
> > preacct {
> > suffix
> > files
> > preprocess
> > }
> > accounting {
> > detail
> > sql
> > }
> > - Radius.Radcheck:
> > 1 | guetali000 | Password | test
> > - Radius.UserGroup:
> > 1 | guetali000 | 200
> > - Radius.RadgroupCheck
> > 1 | 200 | Auth-Type | Password | |
> > - Radius.Radgroupreply:
> > 1 | 200 | Service-Type | Framed-User | |0 |
> >
> > - Debug Output:
> > ad_recv: Access-Request packet from host 127.0.0.1:32772, id=112,
length=58
> > User-Name = "guetali"
> > ...etc etc .
> > rlm_sql: Pairs do not match [guetali]
> > rlm_sql: Released sql socket id: 4
> > modcall[authorize]: module "sql" returns notfound
> > modcall: group authorize returns ok (BECAUSE of "guetali" MATCHES
"DEFAULT"
> > in USERS FILE)
> > rad_check_password: Found Auth-Type Local (OK with "FILES" module...)
> > auth: type Local
> > auth: No password configured for the user
> > Login incorrect (No password configured for the user): [guetali/test]
(from
> > nas local port 0) (OF COURSE, THE PASSWORD IS IN SQL)
> > auth: Failed to validate the user.
> > Login incorrect: [guetali/test] (from nas local port 0)
> >
> >
> >
> >
> > -
> > List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
> >
> >
>
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
