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

[<wei...@gm...>]

Hi there,

I found out where the problem was, and btw, yes,

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

The problem was the table was using "message" as one of the column names,  
which even though not a reserved word in MySQL, but somehow makes it  
unhappy (Unknown column 'message' in 'field list'). After I changed the  
column name to "msg", it's all working now. When I saw "Log4perl: DBI  
appender failed to reconnect to database after 1 attempt  
at ./tests/testDbCon.pl line 21", I thought it was the database connection  
issue. Maybe it'd nice that the actual DBI error was captured.

BTW, in my codes, I have overridden DBI.pm to establish the database  
connection and return a DBH, I'd like to use that DBH for log4perl, how do  
I go about doing it?

Thanks,

David

On Feb 11, 2009 4:49pm, "Kevin M. Goess" <cp...@go...> wrote:
> 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...
>
> > 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.
>
> >
>
>
>