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