Problem with authentication

[CoMeC]

Hey,

I am not sure, no specialist, but try to make this query in your mysql:

"SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username =
'test-user' ORDER BY id"

Make sure, that your mysql server/login/password/database are correct.
Take a look how is you password handled... clear-text or what?

Maybe that will help you,

Best regards,

CoMeC


On Thu, 13 Dec 2007 16:33:07 -0300, Pablo Lucchetti <pablo at lnx.org.ar>
wrote:
> Hi,
> 
> I've a Freeradius on a Debian Etch with Mysql but when I'm triying to
> test with NTRadPing always got the same error.
> The user already exists in database
> 
> 
> rad_recv: Access-Request packet from host 192.168.1.109:4027, id=2,
> length=49
>         User-Name = "test-user"
>         User-Password = "test-pass"
> rlm_sql (sql): Reserving sql socket id: 4
> rlm_sql (sql): SQL query error; rejecting user
> rlm_sql (sql): Released sql socket id: 4
> Sending Access-Reject of id 2 to 192.168.1.109 port 4027
> 
> 
> Any help please?
> 
> 
> Thanks in advance,
> Pablo
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html