Welcome Guest Login Register Member List
ExpressionEngine Forums
Advanced Search
Username: Password:
Remember Me? forgot password?
You are here: Forum Home  >  Installation  >  Tracks on a web host  >  Thread
   
 
Installing on Godaddy
 
jfinnan
Posted: 07 July 2006 06:13 AM   [ Ignore ]  
Newbie
Rank
Total Posts:  1
Joined  2006-07-07

Godaddy supports Rails, but in a shared hosting account you don’t have telnet access. Is there a schema for the MYSQL database that I can follow to create the DB?
Profile
 
bsag
Posted: 07 July 2006 06:49 AM   [ Ignore ]   [ # 1 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  217
Joined  2006-03-05

Hmm, that’s tricky. There isn’t a schema as such, because the database is usually generated by the rake db:migrate commands. There’s a couple of ways to get around this.

1. If you have Tracks (and mysql) installed on your own machine, go through the installation process as far as creating the database and running rake db:migrate to populate it with tables. Then you can export the schema from MySQL and upload it to your Godaddy database (I assume that they have phpmyadmin, or something like that).
2. If you don’t have any of the necessary stuff installed, when I get a moment, I’ll export a schema for you. It might take a while though, because I’m very busy with a grant application at the moment. If anyone else running 1.041 could be kind enough to do it (just export the tables) and attach the schema file to this thread, that would be really helpful.
Profile
 
Hapa
Posted: 10 August 2006 08:33 AM   [ Ignore ]   [ # 2 ]  
Newbie
Avatar
Rank
Total Posts:  3
Joined  2006-08-10

I’m currently trying to figure out how to install on GoDaddy also.  If I get it working I’ll post how I did it here.

Here’s a Db shema from v1.041
Just use phpMyAdmin to insert the tables

-- 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`)
); 

Profile
 
Hapa
Posted: 10 August 2006 09:50 AM   [ Ignore ]   [ # 3 ]  
Newbie
Avatar
Rank
Total Posts:  3
Joined  2006-08-10

Ok, I got it working
Here’s what I had to do

Create a database and insert the tables into it using phpMyAdmin and the script in the above post.
BTW you don’t

Go to the CGI Administration page and in the Ruby tab under “Create Rails App Directory”
type the directory you will upload Tracks to

Then upload tracks to that directory

Under “Create Rails Symbolic Link”
Click the “Show Rails Applications” link

Choose “Tracks” from the drop down list and
Enter “tracks” in the bock titled “Enter a link name: “  then click the create button

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] 

Because GoDaddy doesn’t use MySQL on localhost I had to modify 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) 

Then I set the permissions of dispatch.cgi to 755

I just used the same values for development, test and production. If you want to set up 3 databases have fun

goto http://www.yoursite.com/tracks/signup to sign on

If my memory serves me correctly that was all I did and it’s working, you can see my login page at http://www.opentutorial.com/tracks/  (You must use the trailing slash, this is due to my root .htaccess file)

Reference:
I used the following web pages to figure this out


http://forums.asmallorange.com/index.php?showtopic=6452&hl=tracks
http://www.db75.com/new_blog/?p=237

I plan to write a tutorial about this at http://www.opentutorial.com/Install_tracks_on_godaddy soon.

I hope this helps

Good luck,

-Kolomona
Profile
 
sonny
Posted: 08 September 2007 03:46 PM   [ Ignore ]   [ # 4 ]  
Newbie
Rank
Total Posts:  2
Joined  2007-09-08

Hello. I’m trying to get tracks running on my GoDaddy account but keep running into a problem:

I use the CGI Admin to create a directory for tracks. Upload tracks into the directory. Next, I attempt to “Create Rails Symbolic Link” and “Click the “Show Rails Applications” link but….when I click show rails applications it does not show any applications. Also, there is no drop down menu.

I’m very newbie so probably missing some simple step. Would really appreciate some help. THANKS.

sonny
Profile
 
   
 
 
‹‹ tracks      public Tracks Tra.in installation ››

Powered By ExpressionEngine
Template Design By Sonnenvogel.com
Select a theme:

ExpressionEngine Discussion Forum - Version 2.1.1 (20081028)
Script Executed in 0.1382 seconds

Atom Feed
RSS 2.0