Hi, Nate,

I am trying to follow the designed steps below.

1. I downloaded psycopg2 2.0.13. Does it matter where in galaxy-dist directory I place it?

2. I modified setup.py - OK

3. pg_config --version gives :

PostgreSQL 8.1.23

I don't really get what you mean by

" make sure the version you want to link against is the version found first on your $PATH "

Is this the Python version you mean? I am using python26 (64bit for CentosOS) and I use a link I created to it in my /home/galaxy/galaxy-python directory. The galaxy dist is located at /home/galaxy/galaxy-dist

4. Given the above details, can I just execute 4?

Thank you


On Mon, 2 May 2011 10:27:41 -0400, Nate Coraor <n...@bx.psu.edu> wrote:
Nikolai Vazov wrote:

Hi, Nate,

Thanks a lot for the hint : I also had suspicions about the SSL and
it seems to be working, well, I mean, failing, as you supposed
because of my psycopg2 which was built without SSL.

OperationalError: (OperationalError) sslmode value "require" invalid
when SSL support is not compiled in

At least I know what I shall do :)

We provide the psycopg2 egg, so rebuilding it may not be so simple. I
would suggest the following, if you want to do it by hand and link it
against your system libpq:

1. Download psycopg2 2.0.13.  The version is going to matter since
   Galaxy expects it.

2. In setup.py, find:

    from distutils.core import setup, Extension

   Prior to that import, add the following:

    from scramble_lib import *

3. Find the pg_config executable and make sure the version you want to
   link against is the version found first on your $PATH.

4. Execute:

    % PYTHONPATH=/path/to/galaxy-dist/scripts/scramble/lib python
setup.py egg_info --tag-build=_8.4.2_static bdist_egg

Let me know if you have any troubles with this process.


Nikolay Vazov, PhD
Research Computing Centre - http://hpc.uio.no
USIT, University of Oslo
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:


Reply via email to