Hi, Hari. You should probably make sure that you can connect to postgres from the command line before trying to connect using galaxy. In particular, it looks like you need to set up this file correctly: http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html Sean On Tue, Apr 12, 2011 at 7:50 AM, hari krishna <pobbati.hari@gmail.com> wrote:
Hi, I am planning to change database from sqlite to postgresql . for this i installed postgresql 8.1.2 and created user and database at my home location. from my home i can able to login to that database
psql -d galaxy -U galaxy -h 192.168.65.8
where database and user name as galaxy and hostname I modified universal.wsgi.ini file as database_connection =postgres:///galaxy<?user=galaxy&password=galaxy123!@#[?host=/var/run/postgresql]
database_engine_option_strategy = threadlocal database_engine_option_server_side_cursors = True database_engine_option_pool_size = 5
database_engine_option_max_overflow = 10
after these modification when i ran the server am getting error like this:
***************************** Traceback (most recent call last):
File "/home/gridmon/hari/galaxy_new/galaxy-central/lib/galaxy/web/buildapp.py", line 82, in app_factory app = UniverseApplication( global_conf = global_conf, **kwargs ) File "/home/gridmon/hari/galaxy_new/galaxy-central/lib/galaxy/app.py", line 30, in __init__
create_or_verify_database( db_url, self.config.database_engine_options ) File "/home/gridmon/hari/galaxy_new/galaxy-central/lib/galaxy/model/migrate/check.py", line 54, in create_or_verify_database dataset_table = Table( "dataset", meta, autoload=True )
File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/schema.py", line 108, in __call__ return type.__call__(self, name, metadata, *args, **kwargs) File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/schema.py", line 236, in __init__
_bind_or_error(metadata).reflecttable(self, include_columns=include_columns) File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/engine/base.py", line 1261, in reflecttable
conn = self.contextual_connect() File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/engine/threadlocal.py", line 194, in contextual_connect return self.session.get_connection(**kwargs)
File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/engine/threadlocal.py", line 20, in get_connection return self.engine.TLConnection(self, self.engine.pool.connect(), close_with_result=close_with_result)
File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 151, in connect agent = _ConnectionFairy(self) File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 304, in __init__
rec = self._connection_record = pool.get() File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 161, in get return self.do_get()
File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 639, in do_get con = self.create_connection() File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 122, in create_connection
return _ConnectionRecord(self) File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 198, in __init__ self.connection = self.__connect()
File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 261, in __connect connection = self.__pool._creator() File "/home/gridmon/hari/galaxy_new/galaxy-central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/engine/strategies.py", line 80, in connect
raise exc.DBAPIError.instance(None, None, e) OperationalError: (OperationalError) FATAL: no pg_hba.conf entry for host "[local]", user "galaxy", database "galaxy<", SSL off *********************************************
Can any one help me for integrating postgresql to galaxy.... waiting for ur kind reply
-- Thanks & Regards, Hari Krishna .M