[Catalyst] Log4Perl with Appender DBIx
cylontoaster
cylontoaster at gmx.de
Mon Oct 24 10:57:32 GMT 2011
Hello,
I wanted to use Log4Perl for all my logging-purposes and stumbled over
some pitfalls.
Can anybody give me a hint for configuring Log4Perl using the DBIx-appender?
So, I installed Log::Log4perl::Appender::DBIx::Class and extended my
Log4Perl-configuration-file with this:
# DBIx
log4perl.appender.DB =
Log::Log4perl::Appender::DBIx::Class
log4perl.appender.DB.schema = DW::Schema
log4perl.appender.DB.class =
DW::Schema::Result::Logger
log4perl.appender.DB.category_column = logger_category
log4perl.appender.DB.level_column = logger_level
log4perl.appender.DB.message_column = logger_message
log4perl.appender.DB.layout =
Log::Log4perl::Layout::SimpleLayout
Because, my 'connect_info's are in a configuration-file, I also have
problems connecting the DB.
That's why I also inserted ...
log4perl.appender.DB.connect_info= dbi:mysql:dbname, "user", "pw"
... which throws an exception like:
Couldn't load class (DW) because: DBI Connection failed: DBI
connect('dbname, "user", "pw"','',...) failed: Access denied for user
'root'@'localhost' (using password: NO) at
/root/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm line 1262
Anybody already used this module?
I'm grateful for every response.
Thanx in advance,
Andy
More information about the Catalyst
mailing list