[ome-users] Dreaded DBD::Pg errors

[Curtis Rueden]

Hi,

DBD::Pg v1.43 works on my Ubuntu system, so these errors are somewhat
frustrating. Could you try different versions of DBD::Pg and see if you can
find one that works for you? If so, I'll try it on my box and see how it
works for me. IMHO the OME installer should not be installing DBD::pg
1.43unless it works on every system we know of.

I agree that it would also be nice if OME were smarter about rejecting known
bad (or even not-known-good) versions of DBD::Pg.

-Curtis

On 8/18/06, McCaughey, Michael J <michael.j.mccaughey at vanderbilt.edu> wrote:
>
>  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.4installed.
>
> 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
>
>
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20060818/4532df07/attachment.html>