Difference between revisions of "Install tracks on godaddy"

From OpenTutorial
Jump to navigation Jump to search
(Wrapping it all up)
 
(3 intermediate revisions by the same user not shown)
Line 62: Line 62:
 
   `user_id` int(11) default '1',
 
   `user_id` int(11) default '1',
 
   PRIMARY KEY  (`id`)
 
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
);
  
 
--  
 
--  
Line 83: Line 83:
 
   `updated_at` datetime default NULL,
 
   `updated_at` datetime default NULL,
 
   PRIMARY KEY  (`id`)
 
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
);
  
 
--  
 
--  
Line 104: Line 104:
 
   `description` text,
 
   `description` text,
 
   PRIMARY KEY  (`id`)
 
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
);
  
 
--  
 
--  
Line 119: Line 119:
 
CREATE TABLE `schema_info` (
 
CREATE TABLE `schema_info` (
 
   `version` int(11) default NULL
 
   `version` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
);
  
 
--  
 
--  
Line 140: Line 140:
 
   PRIMARY KEY  (`id`),
 
   PRIMARY KEY  (`id`),
 
   KEY `sessions_session_id_index` (`session_id`)
 
   KEY `sessions_session_id_index` (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
+
);
  
 
--  
 
--  
Line 165: Line 165:
 
   `user_id` int(11) default '1',
 
   `user_id` int(11) default '1',
 
   PRIMARY KEY  (`id`)
 
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
);
  
 
--  
 
--  
Line 186: Line 186:
 
   `preferences` text,
 
   `preferences` text,
 
   PRIMARY KEY  (`id`)
 
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
+
);
  
--
 
-- Dumping data for table `users`
 
--
 
 
</pre>
 
</pre>
 
* Then click the "Go" Button
 
* Then click the "Go" Button
 
* You may now close the phpMyAdmin window
 
* You may now close the phpMyAdmin window
 
  
 
== Edit the Files ==
 
== Edit the Files ==
Line 258: Line 254:
  
  
== Bibliograph y ==
+
== Bibliography ==
 
* (ISBN 0142000280
 
* (ISBN 0142000280
 
* (ISBN 0143034545
 
* (ISBN 0143034545
 
* (ISBN 1932394699
 
* (ISBN 1932394699
 
  
 
== Amazon's Related Products ==
 
== Amazon's Related Products ==
Line 274: 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