Installation

Table of Contents Preconditions Installation and Configuration Database Setup Restore Default Configuration Mod-Rewrite Problems Custom Base Directory Custom Database Configuration Still Problems with the Installation?

Preconditions

• MySQL server with root access installed.
• Apache (or similar httpd) installed and configurable
  • pointing to a webroot where you have write access to.
  • make sure .htaccess files are used (AllowOverride all).
  • PHP5 and rewrite modules enabled

you can see all modules by running:

 apache2ctl -t -D DUMP_MODULES

• Sendmail installed and configured

Installation and Configuration

• Unzip all the files of the project to a directory that can be accessed by your http-server
• The project has the following structure:
• (Project Root) contains index.php and a .htaccess file containing rules for URL rewriting. It also contains some helper script. All instructions and pathes given on this page are relative to this project root.
  • application: contains all php code
  • database contains sql scripts to setup the database
  • css, img contains style sheets or images respectively
  • docs contains documentation for the project

Database Setup

The default configuration is:

• a database called goftogo
• a user goftogo@localhost with no password who has full access to the database

If you have no user called goftogo@localhost and no database goftogo and want to create everything from scratch you can also run the database setup script in the project root directory:

 ./createdatabase.sh

The database setup can be done by hand by running sql-scripts contained in the database directory. All the commands mentioned hereafter assume database as the working directory:

You can init the database and create a user goftogo@localhost

 mysql -u root -p < init.sql

To create the tables in the database run database/goftogo.sql. This will create all the tables in the database:

 mysql goftogo -u goftogo < tables.sql

To fill the tables with example data you can run

 mysql goftogo -u goftogo < data.sql

If you follow these instructions and have your webroot pointing directly to the project's root directory (where you pulled from github) you should now be able to run Goftogo by pointing your browser to

 localhost

you can look at the documentation at

 localhost/docs

Restore Default Configuration

local configurations will only need to make changes in three files to make sure goftogo runs on localhost:

 .htaccess
 application/config/config.php
 application/config/database.php

If you use the default configuration (goftogo database, localhost root as project location) and it still does not work it is likely somebody accidentally changed the files in the repository. For these cases all the config files have a version ending in ==== Mod-Rewrite Problems ==== If you cannot access the project with localhost directly and have to enter localhost/index.php there is a problem with an apache module called mod_rewrite. You will find a detailed instruction here: [http://codeigniter.com/wiki/mod_rewrite]. Please note that the .htaccess file is already part of the project, you do not have to change this. ==== Custom Base Directory ==== If you want to run the project at another URI than localhost (for example localhost/mycustomdir): * edit ''application/config/config.php'' and set the correct base_url like this: $config['base_url'] = http://localhost/mycustomdir * If you want to use mod_rewrite you also have to change the base rewrite rule (line three) in the .htaccess file: <pre>RewriteBase /mycustomdir</pre>

* make sure you will NOT commit these changes by telling git to ignore these files:

 git update-index --assume-unchanged application/config/config.php
 git update-index --assume-unchanged .htaccess

==== Custom Database Configuration ====

If you have a custom database configuration * edit ''application/config/database.php'' and modify, username, password or whatever you want to change.

 $config['base_url'] = http://localhost/MyCustomPath

* make sure you will NOT commit this:

 git update-index --assume-unchanged application/config/database.php

== Still Problems with the Installation? ==

If you read and understood this complete page but there are still problems with the installation, create an Issue in the Setup/Installation Issues Milestone. Then assign this issue to Jonas and Tilman. (click [/jonassanoj/dbpro/issues/new here] to create an issue).