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

[Mike S. <m...@pe...>]

On Tue, 10 Feb 2009, David Zhao wrote:

> = DBI:mysql:dbname=tmp;host=devserv;port=
> log4perl.appender.DBAppender.username   = user
> log4perl.appender.DBAppender.password   = 12345

Can you connect to the database using the mysql client? Try

     mysql -uuser -p -h devserv tmp

and when prompted for a password, type '12345'. If this works, the only
other suspicious item I noticed at first glance is the ";port=" part --
try it without.

-- Mike

Mike Schilli
m...@pe...

> 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
>
>
> ------------------------------------------------------------------------------
> Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
> software. With Adobe AIR, Ajax developers can use existing skills and code to
> build responsive, highly engaging applications that combine the power of local
> resources and data with the reach of the web. Download the Adobe AIR SDK and
> Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
> _______________________________________________
> log4perl-devel mailing list
> log...@li...
> https://lists.sourceforge.net/lists/listinfo/log4perl-devel
>