Hi,
As mentioned before, I'm having problems with DBD::Pg on AIX 5.3. I've
read the README and done plenty of 'googling' but to no avail. Are there
ANY reports of success?
The set up I'm having trouble with is;
AIX 5.3
apache-2.2.10
perl 5.10.0 (built with threads)
mod_perl-2.0.4
DBI-1.6.07
DBD-Pg-2.11.2 & DBD-Pg-2.11.2
postgresql-8.3.4
I've tried a fresh install of AIX with fresh installs of all the above
but it just wont play ball. The results of make test is below;
# gmake test
PGINITDB="/usr/local/pgsql/bin/initdb" PERL_DL_NONLAZY=1
/usr/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/*.t
t/00-signature......skipped
all skipped: Set the environment variable TEST_SIGNATURE to
enable this test
t/00basic...........ok
t/01connect.........#
# DBI Version 1.607
# DBD::Pg Version 2.11.2
# Perl Version 5.10.0
# OS aix
# PostgreSQL (compiled) ?
# PostgreSQL (target) ?
# PostgreSQL (reported) ?
# Default port ?
# DBI_DSN dbi:Pg:dbname=test
# DBI_USER postgres
# Test schema dbd_pg_testschema
# LANG en_GB
# Adjusted: initdb
# Error was: Previous failure (Failed to run initdb (executable probably
not available) Final call was: initdb)
skipped
all skipped: Connection to database failed, cannot continue testing
t/01constants.......ok
t/02attribs.........skipped
all skipped: Connection to database failed, cannot continue testing
t/03dbmethod........skipped
all skipped: Connection to database failed, cannot continue testing
t/03smethod.........skipped
all skipped: Connection to database failed, cannot continue testing
t/04misc............skipped
all skipped: Connection to database failed, cannot continue testing
t/06bytea...........skipped
all skipped: Connection to database failed, cannot continue testing
t/07copy............skipped
all skipped: Connection to database failed, cannot continue testing
t/08async...........skipped
all skipped: Connection to database failed, cannot continue testing
t/09arrays..........skipped
all skipped: Connection to database failed, cannot continue testing
t/12placeholders....skipped
all skipped: Connection to database failed, cannot continue testing
t/20savepoints......skipped
all skipped: Connection to database failed, cannot continue testing
t/99_perlcritic.....skipped
all skipped: Set the environment variable TEST_CRITIC to enable
this test
t/99_pod............skipped
all skipped: Set the environment variable TEST_AUTHOR to enable
this test
t/99_spellcheck.....skipped
all skipped: Set the environment variable TEST_SPELL to enable
this test
t/99_yaml...........ok
2/2 skipped: various reasons
t/99cleanup.........ok 1/1Removing test database
directory
t/99cleanup.........ok
1/1 skipped: various reasons
All tests successful, 15 tests and 3 subtests skipped.
Files=19, Tests=139, 8 wallclock secs ( 6.38 cusr + 0.91 csys = 7.29 CPU)
As suggested, I've tried;
prove --blib . -v t/01connect.t
and get basically the same as above.
# prove --blib . -v t/01connect.t
t/01connect....#
# DBI Version 1.607
# DBD::Pg Version 2.11.2
# Perl Version 5.10.0
# OS aix
# PostgreSQL (compiled) ?
# PostgreSQL (target) ?
# PostgreSQL (reported) ?
# Default port ?
# DBI_DSN dbi:Pg:dbname=test
# DBI_USER postgres
# Test schema dbd_pg_testschema
# LANG en_GB
# Adjusted: initdb
# Error was: Previous failure (Failed to run initdb (executable probably
not available) Final call was: initdb)
1..0 # Skip Connection to database failed, cannot continue testing
skipped
all skipped: Connection to database failed, cannot continue testing
All tests successful, 1 test skipped.
Files=1, Tests=0, 0 wallclock secs ( 0.41 cusr + 0.08 csys = 0.49 CPU)
If I go ahead and install, it proceeds without error. However, the
following perl code core dumps on the execute;
$sth = $dbh->prepare(qq{ SELECT id, mod_nm, mod_pd FROM mod_dets WHERE
id = ? ORDER BY mod_nm }) or die($sth->errstr);
foreach $nam (@mod_list) {
$sth->bind_param(1, $nam) or die($sth->errstr);
$sth->execute or die($sth->errstr);
......... other code here not executed
}
I've tried gcc instead of xlc, I've tried just about every combination
of perl/DBD::Pg/PostgreSQL you can think of. No Joy. Anybody any clues?
Alternatives to DBD::Pg? Maybe it's AIX5?
Cheers,
--
Michael Howard mike at dewberryfields dot co dot uk
Lancashire
England
