Difference between revisions of "Install tracks on godaddy"

From OpenTutorial
Jump to navigation Jump to search
m (Bibliography: Typo)
 
(One intermediate revision by the same user not shown)
Line 269: Line 269:
 
* [http://www.rousette.org.uk/projects/forums/viewthread/13/ My forum post on GoDaddy installation]
 
* [http://www.rousette.org.uk/projects/forums/viewthread/13/ My forum post on GoDaddy installation]
  
{{Inuse}}
+
 
 +
[[Category:Software]]
 +
[[Category:Internet]]
 +
[[Category:Ruby]]
 +
[[Category:MySQL]]

Latest revision as of 02:28, 18 August 2006

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" Icon mysql.gif
  • 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 BtnOpenManager over.gif
  • Click the "Edit" Icon under "Actions" (it looks like a pencil) IconEdit over.gif
  • 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 BtnOpenManager over.gif
  • 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 B selboard.png
  • 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


See Also

Bibliography

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

Amazon's Related Products

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


External Links