Re: MySQL, again and again ...
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
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
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
