Hi Galaxy Community, I have the same problem than Nikolay few years ago ( http://dev.list.galaxyproject.org/connecting-to-a-DB-on-a-different-host-td4...) : I would like to connect my Galaxy instance to my postgresql database using SSL encryption and Auth method md5. I have no problems connecting to the DB via the command line with SSL encryption. When setting the galaxy.ini file with postgresql database connection to "postgresql://<USERNAME>:<PWD>@<HOST>:5432/<DB_NAME>?sslmode=require", I get the following message : "OperationalError: (psycopg2.OperationalError) sslmode value "require" invalid when SSL support is not compiled in" Regarding the former post I thought that it might come from the module psycopg2's compilation. I followed the steps of the post but encounter a different error. What I did: 1. Downloaded a tar.gz of psycopg2 2.5.1 (I saw the needed version in the file eggs.ini) to <install dir>/galaxy/ and unpacked it there 2. cd into psycopg2, modified the setup.py according to the instructions (added the line containing scramble_lib) 3. export the path to pg_config (export PATH=<path/to/postgresql>/bin:$PATH) 4. added the file ez_setup.py (downloaded from https://bootstrap.pypa.io/ez_setup.py) to <install dir>/galaxy/scripts/scramble/lib/, the same dir where scramble_lib.py is located 5. ran PYTHONPATH=<install dir>/galaxy/scripts/scramble/lib python setup.py egg_info --tag-build=_9.4.4_static bdist_egg And get the following error : " Traceback (most recent call last): File "setup.py", line 57, in <module> from scramble_lib import * File "<install dir>/galaxy/scripts/scramble/lib/scramble_lib.py", line 150, in <module> use_setuptools( download_delay=8, to_dir=os.path.dirname( __file__ ) ) File "<install dir>/galaxy/scripts/scramble/lib/ez_setup.py", line 160, in use_setuptools version = _resolve_version(version) File "<install dir>/galaxy/scripts/scramble/lib/ez_setup.py", line 368, in _resolve_version resp = urlopen(meta_url) File "/usr/lib64/python2.6/urllib2.py", line 126, in urlopen return _opener.open(url, data, timeout) File "/usr/lib64/python2.6/urllib2.py", line 391, in open response = self._open(req, data) File "/usr/lib64/python2.6/urllib2.py", line 409, in _open '_open', req) File "/usr/lib64/python2.6/urllib2.py", line 369, in _call_chain result = func(*args) File "/usr/lib64/python2.6/urllib2.py", line 1198, in https_open return self.do_open(httplib.HTTPSConnection, req) File "/usr/lib64/python2.6/urllib2.py", line 1165, in do_open raise URLError(err) urllib2.URLError: <urlopen error [Errno -2] Name or service not known> " Could it be because I have no internet access ? What module should I install to enable SSL encryption ? Additional information : - Postgresql version 9.4.4 - Galaxy version 15.10 - I use virtualenv for python environment Thanks in advance, Floreline