• View
• Edit
• History
• Print
• Login

GTD-PHP Version 0.7 Installation Instructions

NB: The current trunk version is now 0.8. We strongly recommend that all users install or upgrade to version 0.8 or major enhancements, bugfixes, and security improvements.

Requirements

• MySQL
• PHP
• Apache with PHP enabled

This version does not support installations using table prefixes in the database. We plan on adding that support in a future release.

1. UPGRADING

1. You should backup your gtd database with:

mysqldump gtd > gtdbackup.sql

(use this in case you need to restore)

2. Extract the tarball into the same directory you originally installed gtd-php in.

3. Then proceed to step 8 under NEW INSTALLATION. This will add new tables as well as add new columns to your existing tables. Your original data will be upgraded to use the new functionality in version 0.5. You do not need to recreate your original database (i.e., step 1 is simply a precaution).

2. NEW INSTALL (Mac OS X)

For an other OS, adjust accordingly):

1. Set up mysql and php

2. cd ~/Sites

3. tar -xzvf pathtotarball

4. cd ~/Sites/gtd-php

5. cp config.sample.php config.php

6. Edit config.php and change $pass and $user to values for local machine.

7. In mysql create a database called gtd:

	create database gtd;

    Note that you should also set proper mysql permissions for the mysql user.
    This user should NOT have access to other databases, nor grant privileges;
    this should NOT be the root user.

8. Make sure the name of the database and user that you created in step 7,

   match those in your config file from step 6.

9. Point your browser to http://localhost/~username/gtd-php/install.php

    If you encounter a mysql error "Error connecting to database"
    then connect to mysql from a shell and issue:
    	set password for 'user'@'localhost' = old_password('password');

	being sure to change user to the user in config.php and password to
	the value of pass in config.php

10. Explore, enjoy, and send us comments, suggestions, gripes, donations at

    http://toae.org/boards

If you have any bugs or requests please open a new ticket for this at New Ticket

3. NEW INSTALL (Debian/Sarge)

1. Install packages:

     apt-get install mysql-server-4.1
     apt-get install libapache2-mod-php4
     apt-get install php4-mysql

2. Set a root password for mysql, this root account is not the same as the operating system root password/account

     /usr/bin/mysqladmin -u root password 'enter-your-good-new-password-here'

3. Download and install the gtd-php software (it was version 0.7 at time of writing)

     tar -xvzf gtd-php-0.7.tar.gz
     mv gtd-php /var/www/

4. Configure apache, i use virtual hosts, but you can configure it any way you like http://httpd.apache.org/docs/2.0/vhosts/

5. Create the gtd database, you will be prompted for the mysql root password.

     mysql -u root -p -e "create database gtd"

change <user> and <pasword> in the line below to something else, this is the username and password for the gtd database

     mysql -u root -p -e "grant all privileges on gtd.* to <user>@localhost identified by '<password>'; flush privileges"

6. Make a config.php

     cp /var/www/gtd-php/config.sample.php /var/www/gtd-php/config.php

change the user and password to the ones you just set with the mysql commands in step 5, use the gtd database user account, do not use the root account!

     nano /var/www/gtd-php/config.php

7. Install the database using the install.php script by putting something like the the following into a web browser. http://gtd.yoursite.com/install.php

4. NEW INSTALL (Access gtd-php from the internet)

These instructions are specific to the godaddy.com web hosting service (modify as necessary for your host). It assumes you're using their Linux server with 2.0 configuration (you can find this out under "Control Panel" a.k.a. "Hosting Control Center").

1. Setup a new database: From Hosting Control Center click "Databases" >> "MySQL" then follow the instructions to create a new database.

2. Download and unzip gtd-php to your local computer.

3. Copy "config.sample.php" into the same directory, then rename the new file "config.php".

4. Edit config.php to look something like this

     <?php
	     $host = 'h50mysql25.secureserver.net';
	     $db = 'yourDatabaseName';
	     $user = 'yourDatabaseName';
	     $pass = 'yourDatabasePassword';
	     $title = 'GTD';
	     $theme = 'default';
     ?> 

Your godaddy.com host may be slightly different. You can verify your host name under "Hosting Control Center" >> "Databases" >> "MySQL" then click the edit/view icon for your GTD database. The "Host Name" is listed there.

5. Create a new folder in the root of your godaddy.com account called "gtd".

6. Move (e.g. via FTP) the gtd-php folder from your local computer to the "gtd" folder at godaddy.com.

7. Point your browser to "http://www.yourwebsite.com/gtd/gtd-php/install.php". With some luck everything went fine and the installation is done.

8. Go to "http://www.yourwebsite.com/gtd/gtd-php/" to start using the program.

Optional Step (Password protect your GTD)

a. Pick a user name and password: These are not tied to the database or godaddy.com logins, so they can be anything you want.

b. Go to the following website to create an encrypted password. You just need to follow their step 1 and click "Submit"

     http://www.tools.dynamicdrive.com/password/

c. Using a text editor (e.g. NotePad, TextEdit, Vim, Emacs, etc; do not use MS Word) on your local computer create a file called "temp.htpasswd". Copy and paste in the username and encrypted password from step b above. You can include multiple users on separate lines. For example, user "john" with password "doggy" and user "jane" with password "kitty" would like this:

     john:F9sCkZqg3bgB2
     jane:9o3OwLv7xCXqY

d. Create a new folder under the root directory at godaddy.com with a name such as "pw" and copy temp.htpasswd into that folder. Once at godaddy.com, rename the file to ".htpasswd". Do NOT put the password file in the root directory at godaddy.com.

e. Using a text editor on your local computer create a file called "temp.htaccess" and insert text similar to:

     AuthUserFile /home/content/j/o/h/johnsmith/html/pw/.htpasswd
     AuthGroupFile /dev/null
     AuthName EnterPassword
     AuthType Basic

     require user john
     require user jane

The first line is the absolute file path to the location of the password file (not the web address) on your host's server. This example is for godaddy.com, your host may have a different path. Note the pattern in the first line, the user name is "johnsmith" and so the path has the first three letters of the user name (i.e. "/j/o/h/").

The last two lines contain the user names of people who should have access to your GTD.

f. Move the file temp.htaccess to the folder /gtd/ on godaddy.com. Rename the file to ".htaccess".

Optional Step (Give your GTD a nice address, such as gtd.yourdomain.com)

a. Create a subdomain for gtd-php: From Hosting Control Center click "Settings" >> "Domain Management" then follow the instructions to create a new subdomain (e.g. gtd.yourdomain.com). Note you want to point it to "/gtd/gtd-php/".

Documentation Installation Version07