How to log SQL queries to a log file with CakePHP

Question

I have a CakePHP 1.2 application that makes a number of AJAX calls using the AjaxHelper object. The AjaxHelper makes a call to a controller function which then returns some data back to the page.

I would like to log the SQL queries that are executed by the AJAX controller functions. Normally, I would just turn the debug level to 2 in config/core.php, however, this breaks my AJAX functionality because it causes the output SQL queries to be appended to the output that is returned to the client side.

To get around this issue, I would like to be able to log any SQL queries performed to a log file. Any suggestions?

Can't you simply turn the query logging functionality of your database on? — deceze
– deceze ♦, Commented Jan 18, 2011 at 6:21

RabidFire · Accepted Answer · 2011-03-26 09:12:54Z

5

I found a nice way of adding this logging functionality at this link:

http://cakephp.1045679.n5.nabble.com/Log-SQL-queries-td1281970.html

Basically, in your cake/libs/model/datasources/dbo/ directory, you can make a subclass of the dbo that you're using. For example, if you're using the dbo_mysql.php database driver, then you can make a new class file called dbo_mysql_with_log.php. The file would contain some code along the lines of the following:

App::import('Core', array('Model', 'datasource', 'dbosource', 'dbomysql'));

class DboMysqlWithLog extends DboMysql {
    function _execute($sql) {
        $this->log($sql);
        return parent::_execute($sql);
    }
}

In a nutshell, this class modifies (i.e. overrides) the _execute function of the superclass to log the SQL query before doing whatever logic it normally does.

You can modify your app/config/database.php configuration file to use the new driver that you just created.

edited Mar 26, 2011 at 9:12

RabidFire

6,3401 gold badge31 silver badges25 bronze badges

answered Jan 23, 2011 at 20:38

Mansoor Siddiqui

22k11 gold badges51 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

RabidFire Over a year ago

Just for the record: Using App::import is the right way to go about requireing the dbo_mysql file. Threw errors for me while running unit tests, but this fixed it.

Joelio Over a year ago

anyone know how to do this for cake 2? There is no dbo folder in cake 2.

Vinay Aggarwal Over a year ago

It's giving "Call to undefined method DboMysqlWithLog::connect()" for me. Any idea what's wrong ?

Sumit Kumar Over a year ago

can you please mention version of cakephp for which this works.

romellem Over a year ago

@Joelio, I found this blog that worked for me for my Cake 2 application - ashokg165.wordpress.com/2015/06/23/…

David Yell · Accepted Answer · 2011-01-18 16:18:03Z

1

This is a fantastic way to debug things like this, https://github.com/cakephp/debug_kit

answered Jan 18, 2011 at 16:18

David Yell

11.9k13 gold badges64 silver badges102 bronze badges

2 Comments

Simon E. Over a year ago

+1, because DebugKit is awesome. But unfortunately some AJAX calls don't work with DebugKit and so logging to a file can still be helpful. :-)

Joelio Over a year ago

debugkit doesnt seem to log sql statements executed in the post of a controller call, only on the rendering controller calls.

Collectives™ on Stack Overflow

How to log SQL queries to a log file with CakePHP

2 Answers 2

5 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related