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
Best regards
Nikolay
Hi Nikolay,
You may be able to connect with:
postgres://<USERNAME>:<PASSWORD>@<HOST>:5432/<DB_NAME>?sslmode=<SSLMODE>
Where SSLMODE is one of the valid values from libpq:
http://www.postgresql.org/docs/9.0/static/libpq-ssl.html#LIBPQ-SSL-SSLMODE-S...
If psycopg2 was built without SSL this will probably fail, in which case I can rebuild the psycopg2 eggs to link against SSL, but this may take a while.
--nate
-- Nikolay Vazov, PhD Research Computing Centre - http://hpc.uio.no USIT, University of Oslo