Dennis Daupert wrote:
I got one error during attempted installation of DBD::Pg.
Is it safe to do a 'force install' or is there some fix needed?
The failure appears to be that the tests for DBD::Pg need to talk to a Postgres
database and are getting a permissions error from Postgres.
To make the test suite run, you need to make sure that the port/dbname/user/pass
which the test suite is using matches up with an actual port/db/user/pass that
you have. The Particulars below says that what the test tried was port 5432, a
db named 'test', a user named 'test', and a passwd named 'testme'. You need to
either create that database, or configure the test suite to use a different
database/user/etc that you already have. I believe there are docs with DBD::Pg
that say how to do the latter; it involves either setting environment variables
or creating a config file, I think.
Running the test suite is not essential to installing DBD::Pg and so you could
certainly 'force install'; but running the test suite is highly recommended as
it could root out some potential problems early, whereas otherwise you may just
discover them when running your own code, even if your own code isn't wrong.
-- Darren Duncan
Test Summary Report
-------------------
t/12placeholders.t (Wstat: 256 Tests: 235 Failed: 1)
Failed test: 113
Non-zero exit status: 1:
Files=15, Tests=1698, 15 wallclock secs ( 0.27 usr 0.13 sys + 1.76 cusr
0.54 csys = 2.70 CPU)
Result: FAIL
Failed 1/15 test programs. 1/1698 subtests failed.
make: *** [test_dynamic] Error 255
Particularrs:
# DBI Version 1.607
# DBD::Pg Version 2.15.1
# Perl Version 5.10.0
# OS linux
# PostgreSQL (compiled) 80307
# PostgreSQL (target) 80307
# PostgreSQL (reported) PostgreSQL 8.3.7 on x86_64-pc-linux-gnu,
compiled by GCC gcc-4.3.real (Ubuntu 4.3.3-5ubuntu4) 4.3.3
# Default port 5432
# DBI_DSN dbi:Pg:db="test"
# DBI_USER test
# Test schema dbd_pg_testschema
# PGDATABASE test
# PGPASSWORD testme
# PGUSER test
# LANG en_CA.UTF-8
# array_nulls on
# backslash_quote safe_encoding
# client_encoding UTF8
# server_encoding UTF8
# standard_conforming_strings off
# Failed test 'Prepare works with placeholders after double slashes'
# at t/12placeholders.t line 516.
# got: 'DBD::Pg::db do failed: ERROR: permission denied for
schema pg_catalog at t/12placeholders.t line 511.
# '
# expected: ''
# Looks like you failed 1 test of 235.:
t/12placeholders.t .. Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/235 subtests
t/20savepoints.t .... ok
t/99cleanup.t ....... 1/1 Removing test database directory
t/99cleanup.t ....... ok
best,
/dennis
------------------------------------------------
Dennis Daupert, PhD
Senior Systems Development Professional -- CSC Account
CSC
GOS | o: 1.317.298.9499 | [email protected] | www.csc.com
