Simple CakePHP Database Logger Replacement
PHP
Pull request Compare This branch is 139 commits ahead, 18 commits behind webtechnick:master.
Permalink
Failed to load latest commit information.
config Add monitoring. Jan 8, 2017
docs Docs Jan 8, 2017
src Allow deleting per log type. Jan 28, 2017
tests Add more tests. Jan 8, 2017
.editorconfig editorconfig Aug 24, 2016
.gitattributes Initial 3.x migration Apr 11, 2016
.gitignore Fix up tests. Sep 28, 2016
.travis.yml Fix group by for postgres. Oct 6, 2016
LICENSE Initial 3.x migration Apr 11, 2016
README.md Update README.md Jan 20, 2017
composer.json Add monitoring. Jan 8, 2017
phpunit.xml.dist whitelist Sep 28, 2016

README.md

CakePHP DatabaseLog Plugin

Build Status Coverage Status Latest Stable Version Minimum PHP Version License Total Downloads

DatabaseLog engine for CakePHP applications.

This branch is for CakePHP 3.x

Features

  • Easy setup and almost no dependencies.
  • Defaults to SQLite as single app application light weight approach.
  • Ideal for multi app applications where logging to a file is just not convenient.
  • If DB is used, fallback to SQLite in case the DB is not reachable.
  • Simple admin interface to view/delete logs included.
  • Basic monitoring and alert system included.
  • Export to TXT files possible.

Log Rotation

While file handling requires file log rotation and splitting into chunks of (compressed) files, a database approach can more easily keep the logs together in a single database. This is more convinient when looking through them or searching for something specific.

This plugin internally combines log entries of the exact same "content" into a single row with an increased count. Additionally you would want to add a cronjob triggered cleanup shell to keep the total size and row count below a certain threshold.

Demo

Clone and install the sandbox app, create some errors and browse the admin backend for the logs overview.

Or just attach it to your app directly. Time needed: 5 minutes.

Install

Composer (preferred)

composer require dereuromark/cakephp-databaselog

Setup

Enable the plugin in your config/bootstrap.php or call

bin/cake plugin load DatabaseLog

You can simply modify the existing config entries in your config/app.php:

    'Log' => [
        'debug' => [
            'className' => 'DatabaseLog.Database'
        ],
        'error' => [
            'className' => 'DatabaseLog.Database'
        ],
    ],

This will use the database_log connection and an SQLite file database by default, stored in your logs folder.

Using an actual database (optional)

Create a config setting in your config/app.php what database connection it should log to:

'DatabaseLog' => [
    'datasource' => 'my_datasource', // DataSource to use
]

It is recommended to not use the same datasource as your production server (default) because when the DB is not reachable logging to it will also not be possible. In that case it will fallback to SQLite file logging on this server instance, though.

Once the datasource is reachable and once the first log entry is being written, the database table (defaulting to database_logs) will be automatically created. No need to manually run any migration or SQL script here. You can also manually create the table before hand, if you prefer:

bin/cake Migrations migrate -p DatabaseLog

Or just copy the migration file into your app /config/Migrations, modify if needed, and then run it as part of your app migrations.

Fully tested so far are PostgreSQL and MySQL, but by using the ORM all major databases should be supported.

Usage

Anywhere in your app where you call $this->log() or Log::write() the DatabaseLog engine will be used.

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

There is also a browsable web backend you can view your logs with.

See docs for more details.