How do i see SQL in my logs?

rubyonrails-talk
1

Warning, long time coder but new to RoR

I am not seeing anywhere near the level of logging i want in my logs, for the sql stuff. regular ruby logging ( in development.log) seems ok.

For example,

Mysql::Error (Access denied for user 'rw'@'localhost' (using password: NO)):

What query generated this error? what table was it trying to access?!?

2

The query_analyzer plugin is great for EXPLAINing the database queries that are going on in your app.

http://agilewebdevelopment.com/plugins/query_analyzer

If you're getting an error like you mentioned, though, your app probably isn't even trying to make any queries. It sounds like it can't even connect to the database.