NAME

JLogger::Storage::DB - store messages in database

SYNOPSIS

General config in config.yaml storages: - JLogger::Storage::DB: source: <dbi storage string> username: <database username> password: <database password> attr: <additional connection parameters>

DESCRIPTION

Stores logged messages in a database. Before storing messages you need to load schema. Schema files can be found in schema/ directory.

EXAMPLES

Sample configuration strings for config.xml for different databases.

SQLite

storages:
    - JLogger::Storage::DB:
        source: dbi:SQLite:jlogger.sql

MySQL

storages:
    - JLogger::Storage::DB:
        source: dbi:mysql:database=jlogger
        username: mysql_username
        password: mysql_password

PostgreSQL

storage:
    - JLogger::Storage::DB:
        source: dbi:Pg:dbname=jlogger
        username: pg_username
        password: pg_password