[ome-users] DBD::PG install error

[Ilya Goldberg]

Oops,  1 more:
FC 4: DBI 1.30/DBD::Pg 1.22/Postgre v8.0.6 (64-bit hardware+OS)
These are the versions of DBI/DBD::Pg that will be installed by the  
OME installer (i.e. the ones cached on openmicroscopy.org).  Probably  
they could use updating to DBI 1.48/DBD::Pg 1.41.

The OS X OME installer will install DBI 1.48/DBD::Pg 1.43/Postgres  
v7.4.8:
http://users.openmicroscopy.org.uk/~igg/OME-Installer.dmg
These are the versions that DarwinPorts would have installed some  
time ago (haven't checked recently).  Unlike DarwinPorts, these all  
get installed as standard OS X ".pkg" packages.

I generally don't use OS package managers or CPAN to deal with Perl  
modules (too much experience with failure to do this anymore).  The  
standard "perl Makefile.PL;make;sudo make install" is what the OME  
installer does, and its what CPAN does as well as some (most?) OS  
package managers.  The advantage of letting the OME installer do it  
for you is that 1) It will install a "known good" combination, and 2)  
it will not attempt to do brain-dead things like upgrading your perl  
installation, which CPAN is prone to doing.  The disadvantage is that  
you may be running other software that depends on later versions of  
these modules.  However, this is not normally the case for a "stock"  
OS install.

-Ilya

On Feb 6, 2006, at 11:50 AM, Ilya Goldberg wrote:

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