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...@perlmeister.com > <mailto:m...@perlmeister.com>> 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. > ------------------------------------------------------------------------------ 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 log4perl-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/log4perl-devel
