cake-databaseLog

Simple storing CakePHP 2.x log into a database., _(*1)

This package does not automatically update in packagist.org, _(*2)

Installation

Add "freefri/cake-databaselog": "dev-master", to your composer.json or clone the repository into Plugin/CakeDatabaselog, _(*3)

Load the plugin in your bootstrap.php CakePlugin::load('CakeDatabaselog');, _(*4)

Create a table in your database kind of this:, _(*5)

 CREATE TABLE `log_entries` (
   `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
   `type` varchar(50) DEFAULT NULL,
   `title` varchar(30) DEFAULT NULL,
   `message` text,
   `environment` varchar(100) DEFAULT NULL,
   `server` text,
   `created` datetime DEFAULT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

Use the new engine to log in bootstrap.php, _(*6)

 CakeLog::config(
     'debug', [
         'engine' => 'CakeDatabaselog.DatabaseLog',
         'types' => ['notice', 'info', 'debug'],
         'environment' => 'production-server',
     ]
 );

You may also be interested in a more complex solution: https://github.com/dereuromark/CakePHP-DatabaseLog (those two projects are not related), _(*7)