Install tracks on godaddy

From OpenTutorial

OpenTutorial Featured Sponsor

Satellite TV for PC

Get over 3000 STATIONS on your PC or Laptop for free!!

Instantly Turn your Computer into a Super TV
click for more info

Tracks is a web-based application to help you implement David Allen’s Getting Things Done™ (GTD) methodology. It is built using Ruby on Rails. This tutorial explains how to install Tracks on a GoDaddy server running on a Deluxe hosting Account.

1 Create Rails App Directory
2 Create Symbolic Link
3 Create the Database
4 Populate the Database
5 Edit the Files
6 Upload Tracks
7 Set permissions
8 Log on to Tracks
9 See Also
10 Bibliography
11 Amazon's Related Products
12 External Links

[edit] Create Rails App Directory

In the Hosting Manager Control panel go Click on "CGI Admin"
This will take you to the CGI Administration page.
In the Ruby tab under "Create Rails App Directory"
Type the directory you will upload Tracks to and click the "Create" button

[edit] Create Symbolic Link

Under "Create Rails Symbolic Link"
Click the "Show Rails Applications" link
Choose "Tracks" from the drop down list
Enter "tracks" in the bock titled "Enter a link name:" then click the create button

[edit] Create the Database

In the Hosting Manager Control panel go Click on "MySQL"
Click on "CREATE NEW DATABASE" button
Enter a Username and password that you'll remember (Your username will also become your database name)
on next page clilck "CREATE DATABASE"

It will take a while (5 to 10 min or so) for GoDaddy's servers to create and setup your database. Hit reload every so often.

When the "OPEN MANAGER" button is enabled your database is setup
Click the "Edit" Icon under "Actions" (it looks like a pencil)
This shows you your database information
Copy the "Host Name" to a scratch text file or write it down, you will need this to connect to your database

[edit] Populate the Database

Click the "OPEN MANAGER" Button
Logon to the MySQL Manager by entering the Username and Password you just created for your Db
On the phpMyAdmin page click the "SQL" Icon on the left
In the window that pops up enter the following

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 

-- Generation Time: Aug 09, 2006 at 11:57 AM
-- Server version: 4.1.9
-- PHP Version: 4.3.11RC1-dev
-- 
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `contexts`
-- 

CREATE TABLE `contexts` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `hide` int(4) NOT NULL default '0',
  `position` int(11) NOT NULL default '0',
  `user_id` int(11) default '1',
  PRIMARY KEY  (`id`)
);

-- 
-- Dumping data for table `contexts`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `notes`
-- 

CREATE TABLE `notes` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `project_id` int(11) NOT NULL default '0',
  `body` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
);

-- 
-- Dumping data for table `notes`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `projects`
-- 

CREATE TABLE `projects` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `position` int(11) NOT NULL default '0',
  `done` int(4) NOT NULL default '0',
  `user_id` int(11) default '1',
  `description` text,
  PRIMARY KEY  (`id`)
);

-- 
-- Dumping data for table `projects`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `schema_info`
-- 

CREATE TABLE `schema_info` (
  `version` int(11) default NULL
);

-- 
-- Dumping data for table `schema_info`
-- 

INSERT INTO `schema_info` VALUES (7);

-- --------------------------------------------------------

-- 
-- Table structure for table `sessions`
-- 

CREATE TABLE `sessions` (
  `id` int(11) NOT NULL auto_increment,
  `session_id` varchar(255) default NULL,
  `data` text,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `sessions_session_id_index` (`session_id`)
);

-- 
-- Dumping data for table `sessions`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `todos`
-- 

CREATE TABLE `todos` (
  `id` int(11) NOT NULL auto_increment,
  `context_id` int(11) NOT NULL default '0',
  `description` varchar(100) NOT NULL default '',
  `notes` text,
  `done` int(4) NOT NULL default '0',
  `created_at` datetime default NULL,
  `due` date default NULL,
  `completed` datetime default NULL,
  `project_id` int(11) default NULL,
  `user_id` int(11) default '1',
  PRIMARY KEY  (`id`)
);

-- 
-- Dumping data for table `todos`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(80) default NULL,
  `password` varchar(40) default NULL,
  `word` varchar(255) default NULL,
  `is_admin` int(4) NOT NULL default '0',
  `preferences` text,
  PRIMARY KEY  (`id`)
);

Then click the "Go" Button
You may now close the phpMyAdmin window

[edit] Edit the Files

Using your favorite text editor edit the following files.

Edit "/public/dispatch.cgi" file Change the 1st line from:

#!/usr/bin/env ruby

to:

#!/usr/local/bin/ruby.

edit "/public/.htaccess" file

Change the line that reads:

RewriteRule ^(.*)$ dispatch.cgi [QSA,L]

to read:

RewriteRule ^(.*)$ dispatch.fcgi [QSA,L]

Edit the "database.yml" file to read as follows:

development:
  adapter: mysql
  database: (your db name)
  host: (The MySQL Host address) 
  port: 3306
  username: (your db user name)
  password: (Your Password)

test:
  adapter: mysql
  database: (your db name)
  host: (The MySQL Host address) 
  port: 3306
  username: (your db user name)
  password: (Your Password)

production:
  adapter: mysql
  database: (your db name)
  host: (The MySQL Host address) 
  port: 3306
  username: (your db user name)
  password: (Your Password)

I just used the same values for development, test and production. If you want to set up 3 databases have fun

[edit] Upload Tracks

Using your favorite FTP program Upload Tracks to the directory you just created.

[edit] Set permissions

set the permissions of dispatch.cgi to 755

[edit] Log on to Tracks

You can now log on to your tracks installation by going to goto http://www.yoursite.com/tracks/signup to sign on

[edit] See Also

[edit] Bibliography

( ISBN 0142000280 ) Getting Things Done: The Art of Stress-Free Productivity
( ISBN 0143034545 ) Ready for Anything: 52 Productivity Principles for Work and Life
( ISBN 1932394699 ) Ruby for Rails: Ruby Techniques for Rails Developers