Problem with authentication

[Pablo Lucchetti]

mysql> SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE 
Username = 'test-user' ORDER BY id;
+----+-----------+---------------+-----------+----+
| id | UserName  | Attribute     | Value     | op |
+----+-----------+---------------+-----------+----+
|  1 | test-user | user-password | test-pass | == |
+----+-----------+---------------+-----------+----+
1 row in set (0.00 sec)

It seems to be OK, but looking into sql.conf MySQL listen on localhost 
only and NTRadping is running on my pc, that's right?


Thanks a lot.

Pablo

CoMeC wrote:
> 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
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> __________ Información de NOD32, revisión 2721 (20071213) __________
> 
> Este mensaje ha sido analizado con  NOD32 antivirus system
> http://www.nod32.com
> 
> 
>