[log4perl-devel] Re: ??? DB-Connect for Log4Perl via DBI ???

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

Jens, I'm cc'ing this response to our mailing list in case anybody else 
might find it helpful.  That's a better place to post things, somebody 
else might be able to field the question if I'm not available 
(http://lists.sourceforge.net/lists/listinfo/log4perl-devel)

 > I've problems with db connect and can only guess the meaning of
 > parameter "datasource" in logger initialization.

For a description of "datasource" Check out the DBI docs, 'perldoc DBI' 
under "Class Methods" or 
http://www.perldoc.com/perl5.6.1/lib/DBI.html#DBI-Class-Methods

The specifics depend on your particular database, so you might also 
check out 'perldoc DBD::Oracle' (I don't have access to Oracle right 
now, sorry).

I'll update the documentation in the log4perl module to mention the same.

Let us know how it goes, good luck.


Schmidtchen, Jens wrote:
> Hello,
> 
> can you PLEASE give me some advice on HOW TO get logging through DBI to 
> work?
> 
> I've problems with db connect and can only guess the meaning of 
> parameter "datasource" in logger initialization. The only example I've 
> found so far (the one where I've got your email address from) looks like 
> that:
> 
> log4j.appender.DBAppndr.datasource = DBI:CSV:f_dir=t/tmp
> 
> There 's no further explanation for "datasource". I've tried an entry 
> from my local ORACLE tnsname.ora file and got:
> 
> Can't connect(<my_oracle_tnsname> <my_oracle_user> <my_password>), no 
> database driver specified and DBI_DSN env var not set at 
> C:/Programme/Perl/site/lib/Log/Log4perl/Appender/DBI.pm line 83
> 
> Can you please check the attached sources and provide me with a 
> appropriate fix?
> 
> Thank you very much in advance.
> Best regards.
> 
> Jens
> 
> <<log4perldbi.l4p>> <<log4perldbi.pl>>
> 

-- 
Happy Trails . . .

Kevin M. Goess
(and Anne and Frank)
904 Carmel Ave.
Albany, CA  94706
(510) 525-5217