[ome-users] Dreaded DBD::Pg errors

[McCaughey, Michael J]

Again DBD::Pg has reared it's ugly head.

I'm installing OME_2_6_0 from cvs. I have DBD:Pg v 1.43 and Postgres 8.1.4 installed.

The perl installer dies after creating a new ome database with:

   Database Delegate Class: OME::Database::PostgresDelegate
             Database Name: ome
                      Host: undefined (local)
                      Port: undefined (default)
Username for DB connection: undefined (process owner)

Are these values correct ? [y/n]:
Creating OME PostgreSQL SUPERUSER (ome)[SUCCESS].
Creating Apache PostgreSQL SUPERUSER (apache)[SUCCESS].
Creating Admin PostgreSQL SUPERUSER (mrmike)[SUCCESS].
Checking database
Creating PostgreSQL database ome...     [Done.]
Fixing OID/INTEGER compatability bug...DBD::Pg::db do failed: ERROR:  could not access file "$libdir/plpgsql": No such file or directory


Errors executing task: DBD::Pg::db do failed: ERROR:  could not access file "$libdir/plpgsql": No such file or directory

 at install.pl line 82
        main::run_tasks() called at install.pl line 266
# Looks like your test died before it could output anything.

Oddly enough, plpgsql.so exists in /usr/local/pgsql/lib.

The source of the fault seems to be line 143 in PostgresDelegate.pm It's not obvious where $libdir gets set.

Incidentally, if you already have DBD:Pg 1.49 (latest version) installed, the perl installer happily uses it (and then blows up with errors) instead of rejecting it as PerlModuleTask.pm implies.

Any suggestions on what to look for?

Michael J. McCaughey, PhD
Molecular Physiology and Biophysics
U9203 MRBIII
6-6175

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20060818/ff7f399c/attachment.html>