Nikolai Vazov wrote:
> I am trying to connect my galaxy instance to a DB on a different
> host. This DB uses an SSL encryption and Auth method md5.
> I have no problems in connecting to the DB via the command line, but
> the line (in universe_wsqi.ini) :
> database_connection =
> gives the following error when I run the script 'run.sh':
> OperationalError: (OperationalError) FATAL: no pg_hba.conf entry
> for host "<HOST_IP>", user "<USERNAME>", database "<DB_NAME>", SSL
> I managed to connect to a local instance of PostgreSQL server
> (without SSL, though)
> Can you give me some hints?
You may be able to connect with:
Where SSLMODE is one of the valid values from libpq:
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
> Thanks in advance
> Nikolay Vazov, PhD
> Research Computing Centre - http://hpc.uio.no
> USIT, University of Oslo
> Please keep all replies on the list by using "reply all"
> in your mail client. To manage your subscriptions to this
> and other Galaxy lists, please use the interface at:
Please keep all replies on the list by using "reply all"
in your mail client. To manage your subscriptions to this
and other Galaxy lists, please use the interface at: