View GodDaddy
Category:Installation
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.
Origin
This article originally appears at wwwOpenTutorial.com OpenTutorial Tutorials About everything by Anyone
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
#!/usr/bin/env ruby
Change the 1st line from:to:
#!/usr/local/bin/ruby.
edit ”/public/.htaccess” fileChange 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 onCategories: