library monolog-db

gordonzero/monolog-db

Laravel 5.6 Monolog custom database channel

Laravel 5.6 Monolog Database Handler.

This package will log errors into a database instead storage/log/laravel.log file., _(*1)

Installation

composer require gordonzero/monolog-db

Open up config/logging.php and find the channels key. Add the following channel to the list., _(*2)

'database' => [
    'driver' => 'custom',
    'via'=> \Logger\DatabaseLogger::class,
    'table'=> env('DB_LOG_TABLE', 'logs'),
    'connection' => env('DB_LOG_CONNECTION', env('DB_CONNECTION', 'mysql')),
],

Set up Environment Variables (see Below)., _(*3)

Migrate the tables., _(*4)

php artisan migrate

Database Engines

Make sure before you migrate the table that you have set the envirment veriable for the database engine. This is done by adding the following line to the .env file, _(*5)

DB_LOG_ENGINE=InnoDB

To use the whatever the default database engine is or to specify no database engine during the table migration use the following, _(*6)

DB_LOG_ENGINE=NONE

Environment configuration

If you wish to change default table name to write the log into add the following definition in your .env file, _(*7)

DB_LOG_TABLE=logs

To change the database connection that is used to wright the logs add the following definition to your .env file, _(*8)

DB_LOG_CONNECTION=mysql

To make sure you are using the database channel for logging add it to the stack in your config\logging.php or change the following in your .env file, _(*9)

LOG_CHANNEL=database

Credits

Based on:, _(*10)

• [Mark Hilton] (https://github.com/markhilton/monolog-mysql)
• [Pedro Fornaza] (https://github.com/pedrofornaza/monolog-mysql)