Database CakePHP Plugin

Author: Nick Baker
Version: 1.3
License: MIT
Website: http://www.webtechnick.com

Features

Database CakeLogger for CakePHP 2.x applications. Easy setup. Ideal for multi app applications where logging to a file is just not convinient. Simple admin interface to view/delete logs included.

Changelog

1.4.0 Compatible with CakePHP 2.4
1.3.0 New configuration file to change default read, write datasources.
1.2.0 Now using FULLTEXT search on messages, better indexes. Update your schema.
1.1.0 Adding new fields URI, hostname, referrer, and IP automatically logged on each log call. (only applys to default Log model)
1.0.0 Initial Release

Install

Clone the repository into your app/Plugin/DatabaseLogger directory:

$ git clone git://github.com/webtechnick/CakePHP-DatabaseLogger-Plugin.git app/Plugin/DatabaseLogger

Run the schema into your database:

$ cake schema create --plugin DatabaseLogger

Setup

Create a config file in app/Config/database_logger with the following (example file in plugin.)

$config = array(
	'DatabaseLogger' => array(
		'write' => 'default', //DataSource to write to.
		'read' => 'default', //Datasource to read from.
	)
);

Pro Tip: You can read from a different datasource than you write to, and they both can be different than your default.

Update the file app/Config/bootstrap.php with the following configurations like so:

App::uses('CakeLog','Log');
CakeLog::config('default', array('engine' => 'DatabaseLogger.DatabaseLog'));

Usage

Anywhere in your app where you call log() or CakeLog::write the database logger will be used.

	$this->log('This is a detailed message logged to the database','error');
	CakeLog::write('error', 'This is a detailed message logged to the database');