TIP: Galaxy + MySql + SQLAlchemy
Hello, Here's a tip for connecting galaxy to mysql on localhost (if it didn't work for you out of the box): ## Get a clean copy of galaxy $ hg clone http://www.bx.psu.edu/hg/galaxy galaxy ## Create dedicated MySQL database for galaxy, ## with user 'galaxy' and password '12345' $ mysql -u root -p password: mysql> create database galaxy ; mysql> use galaxy ; mysql> grant all on galaxy.* to 'galaxy'@'localhost' identified by '12345'; ## Setup Galaxy $ sh setup.sh ## Change universe_wsgi.ini, to use the new database database_connection = mysql://galaxy:12345@localhost/galaxy ## Run Galaxy $ sh run.sh ----------------- But here's the catch: On a standard debian system, mysql puts the unix socket file in /var/run/mysqld/mysqld.sock However, SqlAlchemy assumes the socket is in /tmp/mysql.sock. So when I run galaxy, I get the following exception: OperationalError: (OperationalError) (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)") None None Two possible solutions for that: 1. Change the socket file in /etc/mysql/my.cnf (not recommended) or 2. Add the following incantation to the SQLAlchemy string in universe_wsgi.ini: database_connection = mysql://galaxy:12345@localhost/galaxy?unix_socket=/var/run/mysqld/mysqld.sock With this change, Galaxy runs fine with mysql on localhost. -Gordon.
participants (1)
-
Assaf Gordon