Thanks Hans. You made my day! This was indeed it {blush}. Just took the example line from the wiki and the currently present example line in the universe_wsgi.ini file too literally. I did notice the triple / but thought/expected it to be something of the SQLalchemy stuff. Works like a charm now. Now troubleshooting why galaxy is still running outside without apache..... :( Alex -----Oorspronkelijk bericht----- Van: Hans-Rudolf Hotz [mailto:hrh@fmi.ch] Verzonden: maandag 15 november 2010 9:11 Aan: Bossers, Alex CC: galaxy-dev@bx.psu.edu Onderwerp: Re: [galaxy-dev] mysql config problem 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/my sqld/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