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