On Jan 3, 2012, at 8:35 PM, Huayan Gao wrote:
Thanks Nate!
I also want to do a mirror site of Galaxy Server in asia, but found the instruction is not so clear/detailed. Do we have a detailed one?
Hi Huayan, Please keep replies on the mailing list for the benefit and collaboration of the entire Galaxy community. Have you seen the documentation at: http://usegalaxy.org/production If so, and this is unclear, can you provide specifics about what you need to do that is not covered by the documentation. Thanks, --nate
Best, Huayan
On 4 Jan, 2012, at 4:16 AM, Nate Coraor wrote:
On Dec 8, 2011, at 10:12 PM, Huayan Gao wrote:
Dear all,
I am trying to install Galaxy in my Mac. And got the following error: password authentication failed for user "postgres".
I have installed postgres using dmg file and created a database called galaxydb under /Library/PostGresql/9.1 folder. I am able to run psql command. I also created postgres user for it. I modified the universe_wsgi.ini file for the database connection. Could you help me check what I should do next to fix the problem?
Hi Huayan,
Sorry for the delay in response. It probably isn't a good idea to use the 'postgres' superuser to run Galaxy. I'd suggest creating a new Postgres user (role) for Galaxy. The simplest thing to do if you're connecting with a unix socket (i.e. you're not specifying a hostname or IP address in database_connection) is to make the Postgres username match the username of the user running the Galaxy process, and to not require a password for that user. You may need the following in pg_hba.conf, if it's not already there:
local all all ident
So, if I have a local system username of 'nate', I would create a postgres user named 'nate' with access to a database 'galaxy', and set database_connection:
database_connection postgres:///galaxy
--nate
Here is part output when I run the "run.sh" command. ----------------------------------------- galaxy.model.migrate.check DEBUG 2011-12-09 11:02:30,748 psycopg2 egg successfully loaded for postgres dialect Traceback (most recent call last): File "/Users/huayangao/galaxy-dist/lib/galaxy/web/buildapp.py", line 82, in app_factory app = UniverseApplication( global_conf = global_conf, **kwargs ) File "/Users/huayangao/galaxy-dist/lib/galaxy/app.py", line 39, in __init__ create_or_verify_database( db_url, kwargs.get( 'global_conf', {} ).get( '__file__', None ), self.config.database_engine_options ) File "/Users/huayangao/galaxy-dist/lib/galaxy/model/migrate/check.py", line 54, in create_or_verify_database dataset_table = Table( "dataset", meta, autoload=True ) File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/schema.py", line 108, in __call__ return type.__call__(self, name, metadata, *args, **kwargs) File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/schema.py", line 236, in __init__ _bind_or_error(metadata).reflecttable(self, include_columns=include_columns) File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/engine/base.py", line 1261, in reflecttable conn = self.contextual_connect() File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.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 "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/pool.py", line 142, in connect return _ConnectionFairy(self).checkout() File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/pool.py", line 304, in __init__ rec = self._connection_record = pool.get() File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/pool.py", line 161, in get return self.do_get() File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/pool.py", line 639, in do_get con = self.create_connection() File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/pool.py", line 122, in create_connection return _ConnectionRecord(self) File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/pool.py", line 198, in __init__ self.connection = self.__connect() File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/pool.py", line 261, in __connect connection = self.__pool._creator() File "/Users/huayangao/galaxy-dist/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.7.egg/sqlalchemy/engine/strategies.py", line 80, in connect raise exc.DBAPIError.instance(None, None, e) OperationalError: (OperationalError) FATAL: password authentication failed for user "postgres" None None
-------------------------------------
Best,
Huayan