-
Notifications
You must be signed in to change notification settings - Fork 252
Database
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")!
The "battery" icon gives you some information whether a table is empty or not. Some tables are auto-filled with some static data. Some of the tables still have a orange "exclamation mark". That´s fine for now! When you check the table details, you will see that foreign key constraints
are not generated. We must be sure, that all tables are created first before adding/updating those keys.
To add/update all keys, click the "Fix columns/keys" button. This will create all the necessary keys for you. Do not add the keys manually. Pathfinder will check the naming of those keys. (You can see all the queries for key generation in the list). Page refreshes again, and should like this:
That´s it! You are done with the first Database.
Some static data, which is required for the "route search" module, has to be imported manually. This SQL dump is part of the repository export/sql/pathfinder.sql
.
Furthermore, import the EVE-ONLINE SDE into a separate database. Set/update DB credentials for this new created DB in environment.ini
.
This step can not be done by the dashboard. You have to do this manually
wget https://www.fuzzwork.co.uk/dump/mysql-latest.tar.bz2
tar xf mysql-latest.tar.bz2
cd vanguard-[..] // go to the extracted folder
mysql -u root -p -e "create database vanguard"; // Create the SDE database.
mysql -u root -p __DATABASE_NAME__ < db_file.sql // Upload the sql file. It might be named like "mysql56-vanguard-[...].sql", Also replace "root" with your mysql user.
You don´t have to import all tables! PATHFINDER requires only the following:
- invTypes
- mapConstellations
- mapDenormalize
- mapLocationWormholeClasses
- mapRegions
- mapSolarSystemJumps
- mapSolarsystems
Alternatively you could import a minimal version of the official EVE-ONLINE SDE. A SQL dump which contain all required table is part of the repository export/sql/
.
When done, reload the dashboard page and check if both databases are green! - Connection is established, all Tables exist and all the indexes/unique keys/columns/column types and foreign-key-constraints exist.