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
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:
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
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 s
