postgres://user:pass@host/galaxy in 'universe_wsgi.ini'
now i tried with
postgres:///<db_name><?user=user_name&password=your_pass>
and it is working.. but i could'nt connect to the webpage http://127.0.0.1:8080/ from another system in same network..
Sridhar
Hi Sridhar
Have you set up your PostgreSQL database correctly? and provide the right username and password in the 'universe_wsgi.ini' file ?
See: http://wiki.galaxyproject.org/Admin/Config/Performance/ProductionServer?action=show&redirect=Admin%2FConfig%2FPerformance#Switching_to_a_database_server
Also, see this old thread, where the same error has been reported before:
http://lists.bx.psu.edu/pipermail/galaxy-dev/2010-May/002624.html
Regards, Hans-Rudolf
On 05/08/2013 01:24 PM, sridhar srinivasan wrote:
___________________________________________________________
Hi ,
I am getting error during Installing galaxy locally.
Traceback (most recent call last):
File
"/illumina/apps/galaxy/galaxy-dist/lib/galaxy/webapps/galaxy/buildapp.py",
line 35, in app_factory
app = UniverseApplication( global_conf = global_conf, **kwargs )
File "/illumina/apps/galaxy/galaxy-dist/lib/galaxy/app.py", line 51,
in __init__
create_or_verify_database( db_url, kwargs.get( 'global_conf', {}
).get( '__file__', None ), self.config.database_engine_options, app=self )
File
"/illumina/apps/galaxy/galaxy-dist/lib/galaxy/model/migrate/check.py",
line 50, in create_or_verify_database
dataset_table = Table( "dataset", meta, autoload=True )
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/schema.py",
line 108, in __call__
return type.__call__(self, name, metadata, *args, **kwargs)
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/schema.py",
line 236, in __init__
_bind_or_error(metadata).reflecttable(self,
include_columns=include_columns)
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py",
line 1261, in reflecttable
conn = self.contextual_connect()
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/base.py",
line 1229, in contextual_connect
return self.Connection(self, self.pool.connect(),
close_with_result=close_with_result, **kwargs)
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py",
line 142, in connect
return _ConnectionFairy(self).checkout()
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py",
line 304, in __init__
rec = self._connection_record = pool.get()
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py",
line 161, in get
return self.do_get()
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py",
line 639, in do_get
con = self.create_connection()
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py",
line 122, in create_connection
return _ConnectionRecord(self)
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py",
line 198, in __init__
self.connection = self.__connect()
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py",
line 261, in __connect
connection = self.__pool._creator()
File
"/illumina/apps/galaxy/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/engine/strategies.py",
line 80, in connect
raise exc.DBAPIError.instance(None, None, e)
OperationalError: (OperationalError) FATAL: Ident authentication failed
for user "galaxy"
None None
I created a user galaxy to install galaxy locally.
Thanks in Advance.
Sridhar
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/
To search Galaxy mailing lists use the unified search at:
http://galaxyproject.org/search/mailinglists/