How do I find out the query error?

Coizado PavelAlves at Speedlink.com.br
Tue May 22 00:01:07 CEST 2012


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.


More information about the Freeradius-Users mailing list