George Sanderson wrote:
>
> >> So far, using Apache::AuthenDBI, I get an error_log message:
> >>
> >> NOTICE: Unrecognized variable client_encoding
> >>
> >> Every time the DBI ping is called.
> >> I have not been able to tack down the origin of this message.
> >> Any ideas or suggestions?
> >
> >never seen before. What database do you use ?
> >
> I am using PostgreSQL 7.0.2
> More details. . .
> I am also using the latest Apache::AuthenDBI and Apache::AuthzDBI.
> In startup.pl I have:
> Apache::DBI->connect_on_init("dbi:Pg:dbname=atable", "webuser", "webuser",
> {
> PrintError => 1, # warn() on errors
> RaiseError => 0, # don't die on error
> AutoCommit => 1 # commit executes immediately
> }
> );
> #
> I did try seting PrintError=>0 with no change on the NOTICE message.
>
> Note: I am not using any of the following (in startup.pl):
> Apache::DBI->setPingTimeOut("dbi:driver:database", $timeout);
> Apache::AuthDBI->setCacheTime(0);
> Apache::AuthDBI->setCleanupTime(-1);
> Apache::AuthDBI->initIPC(50000);
>
> When I start httpd I get the following error log output.
> ======================================
> [Wed Nov 15 17:47:48 2000] [info] created shared memory segment #12928
> [Wed Nov 15 17:47:48 2000] [notice] Apache/1.3.14 (Unix) mod_perl/1.24_01
> mod_layout/2.8 configured -- resuming normal operations
> [Wed Nov 15 17:47:48 2000] [notice] suEXEC mechanism enabled (wrapper:
> /usr/local/apache/bin/suexec)
> [Wed Nov 15 17:47:48 2000] [info] Server built: Nov 5 2000 10:26:07
> 12052 Apache::DBI PerlChildInitHandler
> 12051 Apache::DBI PerlChildInitHandler
> 12053 Apache::DBI PerlChildInitHandler
> NOTICE: Unrecognized variable client_encoding
> Database handle destroyed without explicit disconnect at
> /usr/local/lib/perl5/5.6.0/site_perl/Apache/DBI.pm line 140.
> require 0 called at
> /usr/local/lib/perl5/5.6.0/site_perl/Apache/DBI.pm line 140
> Apache::DBI::childinit('Apache=SCALAR(0x874565c)') called at
> /dev/null line 0
> require 0 called at /dev/null line 0
> 12054 Apache::DBI PerlChildInitHandler
> NOTICE: Unrecognized variable client_encoding
> Database handle destroyed without explicit disconnect at
> /usr/local/lib/perl5/5.6.0/site_perl/Apache/DBI.pm line 140.
> require 0 called at
> /usr/local/lib/perl5/5.6.0/site_perl/Apache/DBI.pm line 140
> Apache::DBI::childinit('Apache=SCALAR(0x874565c)') called at
> /dev/null line 0
> require 0 called at /dev/null line 0
> 12055 Apache::DBI PerlChildInitHandler
> 12056 Apache::DBI PerlChildInitHandler
> =============================================================
> The NOTICE and etc messages are repeated several (12) times for the 6
> Apache children and the 1 Apache root processes running (i.e. 2 NOTICE
> messages per child).
> The Apache::DBI.pm is version 0.87 and near line 140 I see:
> sub childinit {
> my $prefix = "$$ Apache::DBI ";
> print STDERR "$prefix PerlChildInitHandler \n" if $Apache::DBI::DEBUG > 1;
> # if (defined @ChildConnect) {
> if (@ChildConnect) {
> for my $aref (@ChildConnect) {
> shift @$aref;
> DBI->connect(@$aref);
> $LastPingTime{@$aref[0]} = time;
> }
> }
> 1;
> }
> Note that I changed the "if(defined @ChildConnect" line because, "defined
> on aggregates (hashes and arrays) is deprecated." Line 140 is:
> $LastPingTime{@$aref[0]} = time;
please read postgresql-7.0.2/doc/postgres/trouble18031.htm.
Edmund
--
http://www.edmund-mergl.de
fon: +49 700 edemergl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]