Re: Problem with authentication

Pablo Lucchetti <pablo@lnx.org.ar> · Thu, 13 Dec 2007 16:55:47 -0300

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@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