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