Something wrong with connecting Galaxy with mysql/postgresql server when uploading datasets

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Something wrong with connecting Galaxy with mysql/postgresql server when uploading datasets

wangdan
Hello, Galaxy developers:
I'm a Galaxy user and to customize and deploy Galaxy server locally. I
need to build a connection between Galaxy and database server now. MySQL
and PostgreSQL are both configured to test the connection.
################################################
#for mysql server and db name is galaxy
database_connection=mysql:///galaxy?unix_socket=/var/run/mysqld/mysqld.sock&user=<user_name>&passwd=<password_string>
#for postgresql and db name is galaxy
database_connection=postgresql:///galaxy?host=/var/run/postgresql&user=postgres&password=<password_string>
################################################
Now starting Galaxy server has no errors and I can create a user account
on local Galaxy server successfully. But when uploading datasets into
Galaxy(mostly less than 1 MB size) it remains "uploading" status(Dataset
is uploading) and cannot complete datasets uploading job. I tested both
PostgreSQL and MySQL and it really did not work. Shockingly using
PostgreSQL the dataset uploading job can be accomplished very very
slowly 3 or 4 times.
wangdan

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

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/