Hi, I have a Freeradius + Mysql on Ubuntu 12.04 running.
I can make it work and Accpet the requests using the original sql scheme, but I need to change the DB in order for it to work with a DB I already have, because my web aplication is already designed to make changes to this DB and it would be a huge effort to reprogram everything. I have changed the DB and table names in sql.conf and it seems to be connectiong ok, but it appears to be some problem in the SQL query but it won't show the error message, this is what I get on debug: Mon May 21 14:07:18 2012 : Debug: rlm_sql (sql): Reserving sql socket id: 4 Mon May 21 14:07:18 2012 : Info: [sql] expand: SELECT id, username, attribute, value, op FROM login_radius WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM login_radius WHERE username = 'coizado' ORDER BY id Mon May 21 14:07:18 2012 : Debug: rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM login_radius WHERE username = 'coizado' ORDER BY id Mon May 21 14:07:18 2012 : Debug: rlm_sql_mysql: MYSQL check_error: 1054 received Mon May 21 14:07:18 2012 : Error: rlm_sql_getvpdata: database query error Mon May 21 14:07:18 2012 : Error: [sql] SQL query error; rejecting user Mon May 21 14:07:18 2012 : Debug: rlm_sql (sql): Released sql socket id: 4 Mon May 21 14:07:18 2012 : Info: ++[sql] returns fail I already have "sqltrace = yes" in sql.conf, but it seems to have no diference. Any idea as to where should I look to find out what exactly is the sql error? Thanks in advance. -- View this message in context: http://freeradius.1045715.n5.nabble.com/How-do-I-find-out-the-query-error-tp5713188.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html