[ome-users] Dreaded DBD::Pg errors

[Ilya Goldberg]

On Aug 19, 2006, at 10:45 AM, Ilya Goldberg wrote:

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

Fixed in HEAD and OME_2_6_0.
-Ilya



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