Hi Rudolf,
Thanks for the reply..

Could you please tell how to check and set the PostgreSQL ..
I provide the correct username and password in universe.ini file..

when i give

#database_connection = postgres:///galaxy_prod ?user=galaxy&password=password
it gave error in history page
"""
Content Encoding Error


The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.

    *   Please contact the website owners to inform them of this problem.

"""


Now after changing it into

database_connection = postgres://galaxy:password@localhost:5432/galaxy_prod

it gives error which i mentioned in previous mail....

Please suggest on this

Thanks
Sridhar


On Wed, May 8, 2013 at 7:16 PM, Hans-Rudolf Hotz <hrh@fmi.ch> wrote:
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/