Difference between revisions of "Install tracks on godaddy"
(Wrapping it all up) |
(→Populate the Database: Fixed SQL syntax) |
||
Line 62: | Line 62: | ||
`user_id` int(11) default '1', | `user_id` int(11) default '1', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) | + | ); |
-- | -- | ||
Line 83: | Line 83: | ||
`updated_at` datetime default NULL, | `updated_at` datetime default NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) | + | ); |
-- | -- | ||
Line 104: | Line 104: | ||
`description` text, | `description` text, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) | + | ); |
-- | -- | ||
Line 119: | Line 119: | ||
CREATE TABLE `schema_info` ( | CREATE TABLE `schema_info` ( | ||
`version` int(11) default NULL | `version` int(11) default NULL | ||
− | ) | + | ); |
-- | -- | ||
Line 140: | Line 140: | ||
PRIMARY KEY (`id`), | PRIMARY KEY (`id`), | ||
KEY `sessions_session_id_index` (`session_id`) | KEY `sessions_session_id_index` (`session_id`) | ||
− | ) | + | ); |
-- | -- | ||
Line 165: | Line 165: | ||
`user_id` int(11) default '1', | `user_id` int(11) default '1', | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) | + | ); |
-- | -- | ||
Line 186: | Line 186: | ||
`preferences` text, | `preferences` text, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
− | ) | + | ); |
− | |||
− | |||
− | |||
</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 == |
Revision as of 17:43, 15 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.
Contents
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
See Also
Bibliograph y
- (ISBN 0142000280
- (ISBN 0143034545
- (ISBN 1932394699
Amazon's Related Products
- (ASIN B0006BAGAW
- (ASIN B0001YGN7O
- (ASIN B0006VNZ1O
External Links
NOTE: This page is currently undergoing a major edit. As a courtesy, please do not make edits to this page while this message is posted, in order to avoid edit conflicts. |