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
>>
>
>
___________________________________________________________
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/
