Re: How do I find out the query error?

2012-05-23 Thread Coizado 
Hi there Alan DeKok-2,

Just came by to say thanks for your kind response and to let you know that I
fixed the problem by trying the querys manually until I got them all
working.

Thank you very much.

Best Regards.

--
View this message in context: 
http://freeradius.1045715.n5.nabble.com/How-do-I-find-out-the-query-error-tp5713188p5713349.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: How do I find out the query error?

2012-05-23 Thread Alan DeKok 
Coizado wrote:
 Hi there Alan DeKok-2,
 
 Just came by to say thanks for your kind response and to let you know that I
 fixed the problem by trying the querys manually until I got them all
 working.
 
 Thank you very much.

  You're welcome.  It's what I do.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: How do I find out the query error?

2012-05-22 Thread Alan DeKok 
Coizado wrote:
 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

  That's the query.

 Mon May 21 14:07:18 2012 : Debug: rlm_sql_mysql: MYSQL check_error: 1054
 received

  That's the MySQL error.

 Any idea as to where should I look to find out what exactly is the sql
 error?

  Look up the MySQL error on the MySQL site.  Try to run the query manually.

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

How do I find out the query error?

2012-05-21 Thread Coizado 
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