Skip to content

Database

Mark Friedrich edited this page Jan 13, 2016 · 11 revisions

Once the installation is finished and you are able to see the Login-Form, you can continue with bootstrapping the databases. PATHFINDER requires two databases to work. The main database and the Static Data Export from CCP.

Setup Dashboard

The Setup Dashboard is enabled by default and will help you setting up and update your databases. Open the dashboard in your browser www.[YOUR_DOMAIN]/setup.

1. Setup Main Database (pathfinder)

Scroll down to the Database section. You should see something like this:

Create a new MySQL database, named "pathfinder" and add/edit app/environment.ini with your DB access data. Refresh the dashboard and check if Pathfinder is now able to connect to it. You should something like this:

Pathfinder shows some important DB configuration settings and compares them with the current requirements. If some of the values are orange, they fail the check. This is not a big problem! With the next steps, Pathfinder automatically tries to fix problems and set some configuration values as SESSION Config Options

Now we will create all the necessary tables and columns. All tables are created out of their PHP-Model Classes. This ensures that further changes can be applied to your database (e.g. new columns, new tables, changed column type, new indexes, new foreign keys,....). To create all missing tables/or columns, click the "Setup tables" button. (This could take some time,....). When finished, the page will reload and it should look like this:

All tables and columns should be created (check the green "Hook")

Clone this wiki locally