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 <rsa...@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:eaf...@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 <rsa...@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:eaf...@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 <rsa...@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/****
>
>  ****
>
> ** **
>
___________________________________________________________
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/

Reply via email to