[ome-users] Dreaded DBD::Pg errors

[Ilya Goldberg]

Hmm,
I wouldn't blame DBD::Pg just yet - we use this DBD::Pg/postgres  
combo on everything.
Your postgres libraries are in /usr/local/pgsql/lib.  Some unixes  
look for libraries (and other things) in /usr/local by default, but  
not all of them.
Did you compile postgres yourself?  Getting a package for your OS  
might make things easier.  Or, you probably need to modify ldconfig  
to load libraries from /usr/local, then re-build DBD::Pg so it finds  
and links the libraries where you have them.  If you compiled  
postgres from source and it works (i.e. server is running, "psql  
template1" works, etc), then you can probably download DBD::Pg from  
CPAN, do the "perl Makefile.PL; make; make test; make install" thing  
on it, and be good to go.  Building DBD::Pg manually as well will let  
you see what its complaining about, the README generally has some  
helpful hints to get it to work.

>> 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.
>>

> 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.

This is a bug - its not rejecting invalid versions as it should

>
> -Curtis
>

-Ilya






On Aug 18, 2006, at 11:19 PM, Curtis Rueden wrote:

> 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.43 unless 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.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
>
>
>
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>
>
>
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users