I use a bit of an obscure host (echristianhosting) but I really like them.  They have Ruby on Rails installed as a service.

Before we get into this, I’ve searched through the forums and haven’t been able to find the answer in a way I can understand it.  I don’t know anything about Ruby or SSH.  I’m a quick learner, but I need someone who is willing to be patient to give me some step by steps on how to get this setup.  I know I can run it on a site like tracks.tra.in, but I like to learn how to do this stuff.  I understand these types of questions can be frustrating (as I’m on the other end when it comes to CSS and web design), so hopefully someone doesn’t mind bearing with me…

So…

I’ve copied the entire Tracks-1.5 folder to my server in the root folder.
I’ve created a MYSQL db to use called tracks15
I’ve configured the variables

I have no idea how to populate my database with the tracks 1.5 schema.  Can someone run me through this (if you are familiar with cPanel X, that may be more helpful to me).  The main services I’m familiar with at cPanel X is phpMyAdmin and MySQL databases.

Thanks for any help in advance…

Do you have shell access? You need to run

rake db:migrate

from your tracks root directory. It will create the database structure for you in the mysql database. This is the default way for rails apps to populate / upgrade your database. I guess (hope) you have some way to execute this.

I’m not sure if I do have shell access.  I emailed the host to see if I do, but is there a way to try in the meantime?

I opened Terminal and typed ssh http://www.zollinhofer.com and it said port 22 connection refused.  Does that mean I don’t have shell access or am I just doing something wrong?

I don’t know. Both sites do not tell a lot of the services you’re using. I guess wait and see that the host replies to your message.

Alright, this is where I am now…

I uploaded the files to a folder on my server.
Ruby is installed already.
I created a db from cPanel X called tracks15 and gave user all privileges. 

I got ssh access, so I changed into the tracks15 folder on my server via Terminal using ssh and typed:

rake db:migrate RAILS_ENV=production

it started processing, and then said:

[~/www/tracks]# rake db:migrate RAILS_ENV=production
(in /home/username/public_html/tracks)
rake aborted!
production database is not configured

(See full trace by running task with—trace)

So I ran it again with -trace at the end and got:

[~/www/tracks]# rake db:migrate RAILS_ENV=production -trace
rake aborted!
no such file to load—ace
/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require’
/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1864:in `do_option’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1900:in `handle_options’
/usr/lib/ruby/1.8/getoptlong.rb:613:in `each’
/usr/lib/ruby/1.8/getoptlong.rb:610:in `loop’
/usr/lib/ruby/1.8/getoptlong.rb:610:in `each’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1900:in `handle_options’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1719:in `init’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1717:in `init’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1709:in `run’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run’
/usr/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7
/usr/bin/rake:16:in `load’
/usr/bin/rake:16

But I don’t know what this all means.  Any thoughts or suggestions???

this means that your database.yml is not set up correctly in /config
In this file there are three sections for configuring your production database, your development database and your test database. The error message states that the production database is not configured.

The section looks like

production:
    adapter: mysql
    database: tracks
    host: localhost
    username: root
    password:

You need to fill in the database name, the host name (if it is different from localhost), the usename that you have configured in mysql and of course the password.

Goog l

the last line should have been ‘good luck’

Did you ever get things running successfully on your server? I am attempting to do the same thing right now using cPanel and having some difficulty getting SSH access. I know from my basic knowledge of Ruby that this access to populate the database I set up in MySQL. I’m guessing I need to ask the server host to enable shell access for me, though it is technically in my list of options and I can create and manage public and private keys for such access.

I’ve noticed that in cPanel there is another step that may make a difference. You must create a new Ruby application in the Ruby on Rails service.

Curious how/if you have resolved this successfully and if you might pass along any additional steps as your opening description is quite similar to my own.

Cheers,
JM