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
