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