freeradius 1.0.4 + mysql cannot authincate

[Jonathan Carpenter]

I am running freeradius 1.0.4 + mysql 4.1.16. I have use the mysql database
schema from the freeradius tar ball. Everything seems to be
setup correctly I can authenticate from flat text files but not from any
database usernames. Here is the output from my /usr/sbin/radiusd -X:

Starting - reading configuration files ...
reread_config:  reading radiusd.conf
Config:   including file: /etc/raddb/clients.conf
Config:   including file: /etc/raddb/snmp.conf
Config:   including file: /etc/raddb/eap.conf
Config:   including file: /etc/raddb/sql.conf
 main: prefix = "/usr"
 main: localstatedir = "/var"
 main: logdir = "/var/log/radius"
 main: libdir = "/usr/lib"
 main: radacctdir = "/var/log/radius/radacct"
 main: hostname_lookups = no
 main: max_request_time = 30
 main: cleanup_delay = 5
 main: max_requests = 1024
 main: delete_blocked_requests = 0
 main: port = 1645
 main: allow_core_dumps = no
 main: log_stripped_names = yes
 main: log_file = "/var/log/radius/radius.log"
 main: log_auth = yes
 main: log_auth_badpass = yes
 main: log_auth_goodpass = yes
 main: pidfile = "/var/run/radiusd/radiusd.pid"
 main: user = "radiusd"
 main: group = "radiusd"
 main: usercollide = no
 main: lower_user = "before"
 main: lower_pass = "no"
 main: nospace_user = "before"
 main: nospace_pass = "before"
 main: checkrad = "/usr/sbin/checkrad"
 main: proxy_requests = no
 security: max_attributes = 200
 security: reject_delay = 1
 security: status_server = no
 main: debug_level = 0
read_config_files:  reading dictionary
read_config_files:  reading naslist
Using deprecated naslist file.  Support for this will go away soon.
read_config_files:  reading clients
read_config_files:  reading realms
radiusd:  entering modules setup
Module: Library search path is /usr/lib
Listening on authentication *:1645
Listening on accounting *:1646
Ready to process requests.
rad_recv: Access-Request packet from host 127.0.0.1:32784, id=125, length=58
        User-Name = "scooby"
        User-Password = "scooby"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 10
rad_lowerpair:  User-Name now 'scooby'
rad_rmspace_pair:  User-Name now 'scooby'
rad_rmspace_pair:  User-Password now 'scooby'
auth: No authenticate method (Auth-Type) configuration found for the
request: Rejecting the user
auth: Failed to validate the user.
Login incorrect: [scooby/scooby] (from client localhost port 10)
Delaying request 0 for 1 seconds
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Sending Access-Reject of id 125 to 127.0.0.1:32784
Waking up in 4 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 125 with timestamp 43c3dc9c
Nothing to do.  Sleeping until we see a request.

Here is my syntax for radtest:
radtest scooby scooby localhost:1645 10 secret

My entries in the mysql table radcheck:
mysql> select * from radcheck;
+----+----------+---------------+----+----------+
| id | UserName | Attribute     | op | Value    |
+----+----------+---------------+----+----------+
|  1 | scooby   | User-Password | := | scooby   |
+----+----------+---------------+----+----------+

Do I have my information specified wrong in my database or not enough
information in my database? I can not figure out why I get authentications
errors when running radtest. I am not sure where I should specify the
auth-type. Any help would be appreciated.

                          Thanks,
--
Jonathan Carpenter
Linux System Administrator
Windows System Administrator
<The Unix Geek>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060110/e4417422/attachment.html>