Nikolai Vazov wrote:
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?
Yes, you should be able to. That version of postgres is rather old but psycopg2 should be backwards compatible. --nate
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