[Help-gnu-radius] SQL Auth doesn't work

[Fred]

I've installed gnu-radius-0.96.4 in a Slackware machine, with the
--enable-shadow and --with-mysql options. Compilation and instalation works
fine. Then I configured the sqlserver and at my mysql.log the radiud connect
and do the select at the database. Everything seems fine, but when I execute
radauth, it doesn't authenticate. Below my command msg and logs.

------
# radauth -v -slocalhost:foobar mane
Password:
server 127.0.0.1:1645
send code 1 (RT_AUTHENTICATION_REQUEST)
send: User-Name = mane
send: Password = mane123
send: NAS-Port-Id = 0
no reply
server 127.0.0.1:1645
send code 1 (RT_AUTHENTICATION_REQUEST)
send: User-Name = mane
send: Password = mane123
send: NAS-Port-Id = 0
no reply
expect 2
got    0
FAIL

----
I've tried to use the Cistron-Radius-radtest too, and I had the result and
logs above:

# radtest mane mane123 localhost 0 foobar
Sending Access-Request of id 238 to 127.0.0.1:1812
User-Name = "mane"
User-Password = "01f3753452383378253236224-FB;h"
NAS-IP-Address = SVR04
NAS-Port-Id = "0"
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=238, length=20

----
# tail /var/log/radius.log
Nov 20 16:05:32: Auth.notice: Invalid user: [mane]: CLID unknown (from nas
255.255.255.255)

----

Can someone help me with this trouble?? How does the authentication in MySQL
work?? The password field at the database need to be crypted (PASSWORD???,
CRYPT???, MD5???) or can I use it with Plain Text.

I tried to put at at my etc/raddb/users this options:
-------
DEFAULT Auth-Type = Crypt-Local,
Password-Location = SQL,
Simultaneous-Use = 1
Service-Type = Framed-User,
Framed-Protocol = PPP
-------
but it didn't work too.
Now my etc/raddb/users is configured as above:

-------
DEFAULT Auth-Type = SQL,
Simultaneous-Use = 1
Service-Type = Framed-User,
Framed-Protocol = PPP

-------

Sorry for the longer email, and if anyone know where is my mistake, i'll
thanks a lot.

Thanks.

_________________________________
Frederico R. C. Costa
Network and System Mananger
Jornal Diário da Manhã
Fone: 55 (62) 267-1054
E-mail: address@hidden



________________________________________________
Diario da Manha Online