[galaxy-dev] proper setup of postgres

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[galaxy-dev] proper setup of postgres

Davide Cittaro
Hi there, 
I'm trying to setup postgres for galaxy, and this should be easy... nevertheless I get authentication errors as I start galaxy. I'm not a postgres expert, but this line

local   all         all                               ident sameuser

in pg_hba.conf should enable access to local users but then:

$ ./run.sh 
[…]
galaxy.model.migrate.check DEBUG 2010-05-20 14:11:02,248 psycopg2 egg successfully loaded for postgres dialect
Traceback (most recent call last):
  File "/data/galaxy_dist/lib/galaxy/web/buildapp.py", line 61, in app_factory
    app = UniverseApplication( global_conf = global_conf, **kwargs )
  File "/data/galaxy_dist/lib/galaxy/app.py", line 28, in __init__
    create_or_verify_database( db_url, self.config.database_engine_options )
  File "/data/galaxy_dist/lib/galaxy/model/migrate/check.py", line 54, in create_or_verify_database
    dataset_table = Table( "dataset", meta, autoload=True )
  File "/data/galaxy_dist/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 "/data/galaxy_dist/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 "/data/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/engine/base.py", line 1261, in reflecttable
    conn = self.contextual_connect()
  File "/data/galaxy_dist/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 "/data/galaxy_dist/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 "/data/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 151, in connect
    agent = _ConnectionFairy(self)
  File "/data/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 304, in __init__
    rec = self._connection_record = pool.get()
  File "/data/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 161, in get
    return self.do_get()
  File "/data/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 639, in do_get
    con = self.create_connection()
  File "/data/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 122, in create_connection
    return _ConnectionRecord(self)
  File "/data/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 198, in __init__
    self.connection = self.__connect()
  File "/data/galaxy_dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.5.egg/sqlalchemy/pool.py", line 261, in __connect
    connection = self.__pool._creator()
  File "/data/galaxy_dist/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:  Ident authentication failed for user "galaxy"
 None None

This is true for root also.
Any hint appreciated :-)

d

/*
Davide Cittaro

Cogentech - Consortium for Genomic Technologies
via adamello, 16
20139 Milano
Italy

tel.: +39(02)574303007
*/




_______________________________________________
galaxy-dev mailing list
[hidden email]
http://lists.bx.psu.edu/listinfo/galaxy-dev
Reply | Threaded
Open this post in threaded view
|

Re: [galaxy-dev] proper setup of postgres

Davide Cittaro

On May 20, 2010, at 2:12 PM, Davide Cittaro wrote:

Hi there, 
I'm trying to setup postgres for galaxy, and this should be easy... nevertheless I get authentication errors as I start galaxy. I'm not a postgres expert, but this line

Sorry, forget about this mail...  Evidently users and db shoud be created before :-)

d




/*
Davide Cittaro

Cogentech - Consortium for Genomic Technologies
via adamello, 16
20139 Milano
Italy

tel.: +39(02)574303007
*/




_______________________________________________
galaxy-dev mailing list
[hidden email]
http://lists.bx.psu.edu/listinfo/galaxy-dev