Category:Installation

= update =

Now, you can enable SSH, although it takes a request, followed by a verification phone call, and then your website and databases are moved to a different server which can take up to 24 hours.

So, in the interest of getting this info out there… If you’re using GoDaddy, enabling SSH to execute commands such as rake will in effect blow you out of of the water for a day. And after the move, you will have to update the host for any database apps you are currently running (the host changes). If your schema is rather simple, you’re probably better off manually setting it up.

(from http://www.getontracks.org/forums/viewthread/439/)

= old way =
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
  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

  Categories:

  • Installation