Install tracks on godaddy

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.

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

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

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

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 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

Upload Tracks

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

Set permissions

• set the permissions of dispatch.cgi to 755

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

Bibliography

• (ISBN 0142000280
• (ISBN 0143034545
• (ISBN 1932394699

Amazon's Related Products

• (ASIN B0006BAGAW
• (ASIN B0001YGN7O
• (ASIN B0006VNZ1O

External Links

• Tracks Website
• My forum post on GoDaddy installation