DBD::Pg - AIX 5.3 - Anybody any success?

Michael Howard <mike-YAMlkNiy9kXYAZS6AL0citBc4/[email protected]>
Newsgroups gmane.comp.db.postgresql.dbdpg
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.