[log4perl-devel] Log::Log4perl::Appender::DBI appender not working

[David Z. <wzh...@gm...>]

Hi there,

Here is my log4perl.properties file setup for Log::Log4perl::Appender::DBI

log4perl.appender.DBAppender = Log::Log4perl::Appender::DBI
log4perl.appender.DBAppender.datasource = 
DBI:mysql:dbname=tmp;host=devserv;port=
log4perl.appender.DBAppender.username   = user
log4perl.appender.DBAppender.password   = 12345
log4perl.appender.DBAppender.sql        = \
	INSERT INTO spp (loglevel, message) \
	VALUES (?,?)
log4perl.appender.DBAppender.layout    = Log::Log4perl::Layout::NoopLayout
log4perl.appender.DBAppender.params.1  = %c
log4perl.appender.DBAppender.params.1  = %m    

and got an error
Log4perl: DBI appender failed to reconnect to database after 1 attempt at 
./test.pl line 37

Please help, thanks in advance!

David