library laravel-mysql-logger

itelmenko/laravel-mysql-logger

Laravel 5.6+ MySQL driver for Monolog

Laravel Monolog MySQL Handler.

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

Installation

composer require itelmenko/laravel-mysql-logger

For Laravel earlier than 10.0, please use version 1.0.7 of this package.:, _(*2)

composer require itelmenko/laravel-mysql-logger:v1.0.7

If you wish to change default table name to write the log into or database connection use following definitions in your .env file, _(*3)

DB_LOG_TABLE=logs
DB_LOG_CONNECTION=mysql

For Laravel < 5.5 open up config/app.php and find the providers key., _(*4)

'providers' => array(
    // ...
    ITelmenko\Logger\Laravel\Providers\MonologMysqlHandlerServiceProvider::class,
);

In config/logging.php, _(*5)

<?php
    // [...]

    'channels' => [

        // [...]

        'mysql' => [
            'driver' => 'custom',
            'via' => ITelmenko\Logger\Laravel\Logging\MySQLLogger::class,
            'connection' => env('DB_LOG_CONNECTION'),
            'table' => env('DB_LOG_TABLE'),
            'name' => 'my.channel' // optional
        ],
    ],

Publish config using Laravel Artisan CLI., _(*6)

php artisan vendor:publish

and select the option Provider: ITelmenko\Logger\Laravel\Providers\MonologMysqlHandlerServiceProvider, _(*7)

Migrate tables., _(*8)

php artisan migrate

Add ITelmenko\Logger\Laravel\Exceptions\MysqlLoggerInsertException into your ExceptionHandler to prevent looping when a database connection fails:, _(*9)

public function register()
{
    $this->reportable(function (Throwable $e) {
        if ($this->shouldReport($e) && app()->bound('sentry')) {
            app('sentry')->captureException($e);
        }
        if ($e instanceof MysqlLoggerInsertException) {
            return false; // prevent looping 
        }
    });
}

Using

Somewhere in your application

Log::channel('mysql')->info('Something happened!');

TODO

• ~~Change $table->bigIncrements('id') to something like ULID~~
• ~~Change root namespace to~~ ITelmenko
• ~~Remove extra fields from model~~
• ~~Remove updated_at?~~
• ~~Add microseconds for created_at~~
• Update version and readme.md (about a changing of migration, about vendor:publish)
• Add php doc
• Add phpcs