Recent Posts by michael

Topic: Brightbox Help / mysqldump and cron advice needed

Hi again

Just to say that I think this was to do with the pipe. I moved the command into an external .sh file then called that file from cron and it worked perfectly.

Extra note: I store the .sh file in a subversion repository. I needed the following command to mark it as executable:

svn propset svn:executable '' file.sh

Cheers!

Mike

Topic: Brightbox Help / mysqldump and cron advice needed

Hi all

Hoping someone can offer some advice … once a week, I take a mysqldump backup of my database. I always run this command from a terminal screen:

mysqldump -h sqlreadwrite.brightbox.net -p"PASSWORD" -u"USERNAME" USERNAME_APPNAME_production | gzip > /home/rails/backup_$(date +%Y%m%d).sql.gz

It works perfectly. To save me logging in once a week, I want to set it up as a cron job which runs every Sunday and on the 1st of each month. I’ve used crontab -e to add the following line to my crontab file:

0 7 1 * 0 mysqldump -h sqlreadwrite.brightbox.net -p"PASSWORD" -u"USERNAME" USERNAME_APPNAME_production | gzip > /home/rails/backup_$(date +%Y%m%d).sql.gz

Nothing seems to happen (there’s no backup file created). I first thought I’d scheduled it to only run on Sunday’s that are the first of the month but I’ve also tried 0 7 * * * to no avail. I have a suspicion it might be something to do with the pipe but any advice would be greatly appreciated.

Thanks

Mike

Topic: Brightbox Help / Creating a 2nd application

Hi Ian

Thanks for the advice :-)

I think I’m almost there … except when I try to run “cap deploy:web:reload” I get the error “Invalid command ‘RailsEnv’, perhaps misspelled or defined by a module not included in the server configuration”. My BrightBox is pretty old but I suspect ‘RailsEnv’ just isn’t installed but I don’t know how to install it.

I tried removing ‘RailsEnv production’ from /etc/apache2/sites-available/rails-myapp and this removes the error. When I do this, the web server starts and I can see the “You’re riding rails” HTML page but as soon as I append a controller name to the URL I get a 404 error … assuming this is because Apache isn’t passing the request on to an application server?

Do you think I need to install whatever ‘RailsEnv’ is? Any idea how?

Cheers!

Mike

Topic: Brightbox Help / Creating a 2nd application

Hi all

Just looking for some advice … I have an app up on bright box but want to add a second one. I’ve created the second app on my laptop – is there anything I need to configure for a second app? Concerned that if I run a ‘deploy’ it will over-write my existing one!

Cheers

Mike