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 Nikolay On Mon, 2 May 2011 10:27:41 -0400, Nate Coraor <nate@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.
--nate
-- Nikolay Vazov, PhD Research Computing Centre - http://hpc.uio.no USIT, University of Oslo