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 <h...@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<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<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/<http://galaxyproject.org/search/mailinglists/>
>>
>>
___________________________________________________________
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/

Reply via email to