Alex I guess, you have one "/" too many, try: database_connection = mysql://galaxy:password_here@localhost/galaxy?unix_socket=/var/run/mysqld/mysqld.sock you might also want to try replacing 'localhost' with the actual name of the server. But I am pretty sure the third "/" after the "mysql:" is the culprit Regards, Hans On 11/14/2010 09:04 PM, Bossers, Alex wrote:
Hi All,
maybe a silly question. I am trying to get galaxy running using a mysql DB behind apache. I followed the wiki instructions on how to setup a production server version. Which covered most (of which most steps seem ok and working as far as I could test). I have troubles with the mysql DB part. Mysql is running ok and the user and pass and DB exist for a system user galaxy. However when I try to start the server (after getting some extra eggs) it fails with something like:
..... snip... File "/opt/galaxy_central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py", line 198, in __init__ self.connection = self.__connect() File "/opt/galaxy_central/eggs/SQLAlchemy-0.5.6_dev_r6498-py2.6.egg/sqlalchemy/pool.py", line 261, in __connect connection = self.__pool._creator() File "/opt/galaxy_central/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) (1045, "Access denied for user 'galaxy'@'localhost'<mailto:'galaxy'@'localhost'> (using password: NO)") None None
So I think its the alchemy connection line.... in the universe_wsgi.ini... and the eroor says password NO....confused. Below what I have now but I guess there is something wrong... tried many but failed. The alchemy docs didn't help me either :(
database_connection = mysql:///galaxy:password_here@localhost/galaxy?unix_socket=/var/run/mysqld/mysqld.sock I also tried putting the user and DB info separate using and alternative line while removing that info from the line stated above;
mysql_db = mysql://galaxy:password_here@localhost/galaxy No luck either
Thanks Alex
_______________________________________________ galaxy-dev mailing list galaxy-dev@lists.bx.psu.edu http://lists.bx.psu.edu/listinfo/galaxy-dev