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

[Kevin M. G. <cp...@go...>]

What are the rest of the contents of your testDbCon.pl script?

And does this succeed?

perl -MDBI -e 'DBI->connect(q/DBI:mysql:dbname=tmp;host=devserv/)'



DavidZ wrote:
> yes, I can connect to the database using mysql client, and tried to
> connect without ";port=", still not working:
> Log4perl: DBI appender failed to reconnect to database after 1 attempt
> at ./test
> s/testDbCon.pl line 38
> 
> Not sure why it's saying "reconnect".
> thanks,
> 
> David
> 
> 
> On Tue, Feb 10, 2009 at 11:59 PM, Mike Schilli <m...@pe...
> <mailto:m...@pe...>> wrote:
> 
>     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.
>