Welcome Guest | Login

performing migrations

This is the first time I've deployed a site and I'm pretty clueless about running a migration from my machine and getting it to create all the tables on the server.

my database.yml is like so
production:
 adapter: mysql
 database: username_mysitename
 username: username_databaseusername
 password: database_password
 host: my_sites_static_ip

ENV['RAILS_ENV'] ||= 'production' is uncommented in environment.rb

This is the command I'm running
rake db:migrate RAILS_ENV=production

Here's the error I get.
Host 'my_local_ip.comcast.net' is not allowed to connect to this MySQL server

I've set up a tunnel using fugu but I'm not sure how to run commands through that or what to do with that.

2007-09-26 10:25 PM

Hello,

I checked your account and I could see that it is a fresh account with nothing actually done on it. i.e I couldn't find any database.yml file or rails app as you have mentioned. From what you have mentioned, have you given the entry
host: 127.0.0.1

Also if the issue requires you to disclose further account info, then please send across a ticket to the support department. Otherwise we can continue troubleshooting the same via forum post.

2007-09-26 10:42 PM

Regards,
Rahul
Yes, I hadn't uploaded anything.  I thought that I ran migrate off my machine to create the tables on the server.  If I upload my database.yml do I just run a command through ssh on the server?

2007-09-27 12:22 AM

Hello,

First of all please create the rails app in your account. Do you have a rails app running fine in your local environment. If so upload the app in tar.gz format and deploy the app in your account.

Also if you could explain the nature of the app and your exact requirements, we can help you out better.

Also do have a look into this thread http://www.hostingrails.com/forums/wiki_thread/3 as it explains how to Install and Deploy Typo on HostingRails.com" and deals with the rake db:migrate

2007-09-27 12:41 AM

Regards,
Rahul
I got it working.  I was very lost as the deploying tutorial said to do a rake before generating my app.

2007-09-29 12:44 AM


Hello Guest! In order to post you must be an active client with us, please log in or sign up.