Re: [galaxy-dev] connecting to a DB on a different host

2011-05-03 Thread Nikolai Vazov
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

Re: [galaxy-dev] connecting to a DB on a different host

2011-05-03 Thread Nikolai Vazov
Hi again, The version of the PostgreSQL server I am trying to connect to is actually 8.3. The DB department say they will soon move to 9.0. The psycopg2 version in my eggs.ini for Galaxy is 8.4.2: psycopg2-2.0.13_8.4.2_static-py2.6-linux-x86_64-ucs4.egg Do you think it will work? 3. Find

Re: [galaxy-dev] connecting to a DB on a different host

2011-05-03 Thread Nate Coraor
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

Re: [galaxy-dev] connecting to a DB on a different host

2011-05-03 Thread Nate Coraor
Nikolai Vazov wrote: Hi again, The version of the PostgreSQL server I am trying to connect to is actually 8.3. The DB department say they will soon move to 9.0. The psycopg2 version in my eggs.ini for Galaxy is 8.4.2: psycopg2-2.0.13_8.4.2_static-py2.6-linux-x86_64-ucs4.egg Do you

Re: [galaxy-dev] connecting to a DB on a different host

2011-05-03 Thread Nikolai Vazov
Hi, Nate, When trying to execute PYTHONPATH=/home/galaxy/galaxy-dist/scripts/scramble/lib python26 setup.py egg_info --tag-build=_8.4.2_static bdist_egg I get Traceback (most recent call last): File setup.py, line 52, in module from scramble_lib import * File

Re: [galaxy-dev] connecting to a DB on a different host

2011-05-03 Thread Nate Coraor
Nikolai Vazov wrote: Hi, Nate, When trying to execute PYTHONPATH=/home/galaxy/galaxy-dist/scripts/scramble/lib python26 setup.py egg_info --tag-build=_8.4.2_static bdist_egg I get Traceback (most recent call last): File setup.py, line 52, in module from scramble_lib import

[galaxy-dev] connecting to a DB on a different host

2011-05-02 Thread Nikolai Vazov
Hi, 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 =

Re: [galaxy-dev] connecting to a DB on a different host

2011-05-02 Thread Nate Coraor
Nikolai Vazov wrote: Hi, 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 =

Re: [galaxy-dev] connecting to a DB on a different host

2011-05-02 Thread Nikolai Vazov
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

Re: [galaxy-dev] connecting to a DB on a different host

2011-05-02 Thread Nate Coraor
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