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

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

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...> 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.
>
> -- 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
>>
>>
>