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
___________________________________________________________
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:
http://lists.bx.psu.edu/
