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