Almost, mysql requires two forward slashes, like so:
database_connection = mysql://galaxy:password_here@<host>/galaxy?unix_socket=/var/run/mysqld/mysqld.sock

NTW, unless you are not absolutely set on MySQL, the Galaxy team prefers PostrgeSQL as the backend database. 

Enis

On Wed, Jun 29, 2011 at 4:03 PM, Sanka, Ravi <rsanka@jcvi.org> wrote:

Hello Enis,

 

Thank you. Galaxy is now directing the files to the new storage location.

 

On a related note, I am also planning to switch Galaxy from the default SQLite to an existing MYSQL database. The documentation says to do this, the database_connection field in the config file must be given the proper URL. This is the example it gave:

 

database_connection = postgres:///<db_name><?user=user_name&password=your_pass>

 

Would the same value work if postgres was switched out with mysql?

 

-----------------------------------------------

Ravi Sanka

ICS - Bioinformatics Engineer

J. Craig Venter Institute

301-795-7743

-----------------------------------------------

 

From: Enis Afgan [mailto:eafgan@emory.edu]
Sent: Wednesday, June 29, 2011 12:02 PM


To: Sanka, Ravi
Cc: galaxy-dev@lists.bx.psu.edu
Subject: Re: [galaxy-dev] changing file storage location

 

In order for Galaxy to acknowledge the changes, you'll have to restart Galaxy. I'll double check in the wiki to make sure this is stated somewhere but simply stopping the Galaxy process and starting it back up should reload the config file. 

 

If your Galaxy is running the background run:

sh run.sh --stop-daemon

sh run.sh --daemon

 

If the process is not running in the background, simply stop it (i.e., ctrl + C)

 

Enis

On Wed, Jun 29, 2011 at 11:52 AM, Sanka, Ravi <rsanka@jcvi.org> wrote:

Hi Enis,

 

No I didn’t restart Galaxy after the changes were saved. Is that the process explained in the README.txt (setup.sh & run.sh)? That process was for the first time, so I didn’t repeat it after saving the changes.

 

-----------------------------------------------

Ravi Sanka

ICS - Bioinformatics Engineer

J. Craig Venter Institute

301-795-7743

-----------------------------------------------

 

From: Enis Afgan [mailto:eafgan@emory.edu]
Sent: Wednesday, June 29, 2011 11:32 AM
To: Sanka, Ravi
Cc: galaxy-dev@lists.bx.psu.edu
Subject: Re: [galaxy-dev] changing file storage location

 

Hi Ravi,

Just a quick check - did you restart Galaxy after saving the changes? What you did should direct any new files to the specified location.

 

Enis

On Wed, Jun 29, 2011 at 10:43 AM, Sanka, Ravi <rsanka@jcvi.org> wrote:

Greetings,

 

My name is Ravi Sanka. I have a question regarding Galaxy.

 

Recently, I had a local installation set up and am now trying to change the location where the install stores imported and created files.

 

I opened the config file universe_wsgi.ini and did the following:

 

-          Removed the ‘#’ mark from ‘#file_path = database/files’

-          Changed value of file_path to the absolute path of an accessible, readable/writable location

-          Saved changes

 

Despite this, the install still stores files in database/files. Is there a step I’m missing? Does the setup procedure (setup.sh & run.sh) need to be run again?

 

I also intend to change the database from the SQLite default to an existing database, so I assume the steps to change the file_path also apply to database_connection.

 

Thank you for your time.

 

-----------------------------------------------

Ravi Sanka

ICS - Bioinformatics Engineer

J. Craig Venter Institute

301-795-7743

-----------------------------------------------

 


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