Difference between revisions of "Install tracks on godaddy"
(Will finish Soon) |
(Wrapping it all up) |
||
Line 2: | Line 2: | ||
− | == | + | == Create Rails App Directory == |
− | * Create Rails App Directory | + | * In the Hosting Manager Control panel go Click on "CGI Admin" |
− | * Create | + | * 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 == |
− | I | + | * 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" [[image: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 [[image:BtnOpenManager_over.gif]] | ||
+ | * Click the "Edit" Icon under "Actions" (it looks like a pencil) [[image: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 | ||
+ | |||
+ | {{adsense2}} | ||
+ | |||
+ | == Populate the Database == | ||
+ | * Click the "OPEN MANAGER" Button [[image: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 [[image:b_selboard.png]] | ||
+ | * In the window that pops up enter the following | ||
+ | |||
+ | <pre> | ||
+ | -- 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`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | -- | ||
+ | -- 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`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | -- | ||
+ | -- 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`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `projects` | ||
+ | -- | ||
+ | |||
+ | |||
+ | -- -------------------------------------------------------- | ||
+ | |||
+ | -- | ||
+ | -- Table structure for table `schema_info` | ||
+ | -- | ||
+ | |||
+ | CREATE TABLE `schema_info` ( | ||
+ | `version` int(11) default NULL | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
+ | |||
+ | -- | ||
+ | -- 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`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; | ||
+ | |||
+ | -- | ||
+ | -- 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`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | ||
+ | |||
+ | -- | ||
+ | -- 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`) | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; | ||
+ | |||
+ | -- | ||
+ | -- Dumping data for table `users` | ||
+ | -- | ||
+ | </pre> | ||
+ | * 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: | ||
+ | <pre> | ||
+ | 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) | ||
+ | </pre> | ||
+ | |||
+ | 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 == | == External Links == |
Revision as of 17:29, 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`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `projects` -- -- -------------------------------------------------------- -- -- Table structure for table `schema_info` -- CREATE TABLE `schema_info` ( `version` int(11) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- 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`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `users` --
- 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. |