I"m not too fluent in any of this but I’m going to give it a shot anyway. I have a few questions.

What needs to be changed in database.yml when installing on the web using mysql? In the production area of the file, is the “host” entry supposed to be my domain name? I’m sure I’ll have more questions, but that’s all for now.

Thanks in advance for any assistance that you can provide.

the host should be the hostname of the server where your database is at (i.e. database server)

Set the following:

development:
  adapter: mysql
  database: name_of_your_production_db
  host: hostname_or_ip_of_your_database
  username: db_user_for_tracks
  password: password_for_db_user

Thanks Reinier.

Seems my host does not have mkmf.rb installed in Rails so I am getting issues. I don’t have sudo permissions and they won’t give them to me.

Any clue what I can do about that?

no, but I don’t think you need them, as long as you can edit the tracks files.

were you able to edit database.yml ?
do you have a mysql database and a user/password?
did you change site.yml (1.7rc2) or environment.rb (pre-1.7rc2)?

Yes I’ve done those. Now I’m getting an issue at the migrate command:

rake aborted!
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

Seems that this has to do with settings in my.cnf located at \etc. I do not have that file in that location, so I’m not quite sure where to go from here. I’m on a shared webhost so not sure that I can create that file and restart mysql.

rails tries to find the sock file to connect to mysql. Apparently it is not in the default place where rails looks. I suspect that your webhost does have the file somewhere. You can point rails to the right place in your database.yml file using

socket: /path/to/mysql.sock

for example:

development:
  adapter: mysql
  socket: /path/to/mysql.sock
  database: name_of_your_production_db
  host: hostname_or_ip_of_your_database
  username: db_user_for_tracks
  password: password_for_db_user

of course you need to find the sock file first (in /var/run/ perhaps?). Furthermore, sometimes the filename can differ too, so copy it carefull.

good luck

Argh. I’m getting frustrated.

I’ve gone through everything and now am having one last issue. When I go to mydomain.com/tracks/signup I’m getting a 403 forbidden. Is there something I have to chmod in teh symbolic link I’ve created?

Thanks for all your help.

I gather that you are trying to install Tracks in a subdir on your domain. Its much easier to use a full domain name, i.e. tracks.mydomain.com.

Please note that subdirs only works for tracks 1.7rc2, not for tracks1.7rc1

For this to work:
* setup the subdir in site.yml (for tracks1.7 rc2)
* change the config of apache to FollowSymLinks
* set the ownership of the tracks files so that apache can read them
* if you are using passenger, be sure to set RailsBaseURI to the subdir

It’s not in a subdir, it’s in the root dir.

The hosts’ instructions on rails installations stated to create a symbolic link to /public_html. I’d rather have it the way you stated. How do I do that?

For reference, their instructions are here:

http://wiki.asmallorange.com/RubyOnRailsDeployment