[ome-users] DBD::PG install error

[Ilya Goldberg]

Hi Michael
The DBI/DBD::Pg pair has been a problem child since the inception of  
OME over 5 years ago.  This problem was the impetus for the original  
installer and for caching "known good" combinations on our own  
servers rather than relying on CPAN.
That being said I can confirm the following working combinations:
OS X:  DBI 1.48/DBD::Pg 1.43/Postgres v7.4.8
FC 1:  DBI 1.37/DBD::Pg 1.22/Postgres v7.3.4-RH
FC 2:  DBI 1.40/DBD::Pg 1.31/Postgres v7.4.2 (64-bit hardware+OS)
FC 4:  DBI 1.48/DBD::Pg 1.41/Postgres v8.0.6 (64-bit hardware+OS)

perhaps others can contribute their experiences?

We can't guarantee other combinations since we haven't tried them,  
and certain combinations are known to be problematic.  The installer  
checks for combinations with known problems and aborts the install.   
That is of course not to say that other combinations may or may not  
work - your mileage may vary, as they say.

-Ilya


On Feb 1, 2006, at 5:08 PM, McCaughey, Michael J wrote:

> I was using 1.42... when using your 1.32 (thank you for making this  
> available) and 1.22 (from OME repository), I can compile correctly  
> but 'make test' bombs:
>
> qTESTING MODULE -- 'make test'
> FAILURE -- OUTPUT: "PERL_DL_NONLAZY=1 /usr/bin/perl "- 
> MExtUtils::Command::MM" "-
> e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
>  t/00basic...........Can't load '/var/tmp/OME/install/DBD-Pg-1.32/ 
> blib/arch/auto
> /DBD/Pg/Pg.so' for module DBD::Pg: libpq.so.4: cannot open shared  
> object file: N
> o such file or directory at /usr/lib64/perl5/5.8.5/x86_64-linux- 
> thread-multi/Dyn
> aLoader.pm line 230.
>   at t/00basic.t line 4
>  Compilation failed in require at t/00basic.t line 4.
>
> but it is there:
> [OME]# ls -l /var/tmp/OME/install/DBD-Pg-1.32/blib/arch/auto/DBD/Pg/ 
> Pg.so
> -rwxr-xr-x  1 root root 246839 Feb  1 15:45 /var/tmp/OME/install/ 
> DBD-Pg-1.32/blib/arch/auto/DBD/Pg/Pg.so
>
> Do I need to change all of DBI? I'm running version 1.40.
>
>
> Michael J. MCaughey, PhD
> Molecular Physiology and Biophysics
> U9203 MRBIII
> 6-6175
>
>
>
> -----Original Message-----
> From: Curtis Rueden [mailto:ctrueden at wisc.edu]
> Sent: Wed 2/1/2006 1:51 PM
> To: McCaughey, Michael J
> Cc: ome-users at lists.openmicroscopy.org.uk
> Subject: Re: [ome-users] DBD::PG install error
>
> Hi Mike,
>
> I have not seen that exact error message, but my lab has had
> difficulties with various DBD::Pg errors. What version of DBD::Pg are
> you using? The latest versions (as of a couple months ago) of  
> DBD::Pg do
> not work correctly with OME. My lab uses v1.32 successfully with  
> two OME
> installations (on Debian boxes). For convenience, I have placed a copy
> online at:
>     http://skyking.microscopy.wisc.edu/curtis/DBD-Pg-1.32.tar.gz
>
> -Curtis
>
> McCaughey, Michael J wrote:
>
>> Trying again with a fresh checkout of OME and a new install of pgsql,
>> I've got another error installing.  This is from
>> CoreDatabaseTablesTask.log
>>
>> SUCCESS Adding constraints to CLASS "OME::Configuration::Variable"
>> ERROR Adding constraints to ST "Experimenter" -- OUTPUT: "DBD::Pg::db
>> do failed:
>>  ERROR:  constraint
>> "@Experimenter.module_execution->OME::ModuleExecution" for r
>> elation "experimenters" already exists at
>> /home/mrmike/OME/src/perl2/OME/Databas
>> e/PostgresDelegate.pm line 726.
>>
>> Got me. Anyone here seen this before?
>>
>> Mike
>>
>>
>>
>> Michael J. MCaughey, 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