PATHFINDER - System Mapping Tool

pathfinder is an open source mapping tool for EVE ONLINE.

Setup and Bootstrapping

The following steps will guide you through the database bootstrapping/update process for PATHFINDER.

Server

Information

Installation Pathfinder
Version v1.5.0
Package Fat-Free Framework 3.6.5-Release
Contact https://github.com/exodus4d
Repository https://github.com/exodus4d/pathfinder

Directories

config.ini
TEMP tmp/ 0777
CACHE folder=tmp/cache/ 0777
API_CACHE folder=tmp/cache/ 0777
LOGS logs/ 0777
UI public/ 0777
AUTOLOAD app/main/ 0777
FAVICON favicon/ 0777
HISTORY [optional] history/
CONFIG PATH [optional] conf/ app/

Server

Time 2019/03/25 04:36:05 - (UTC)
OS Linux
Host name Pathfinder
Release name 4.18.0-16-generic
Version info #17~18.04.1-Ubuntu SMP Tue Feb 12 13:35:51 UTC 2019
Machine type x86_64
Document root /var/www/pathfinder
Port 80
Protocol - scheme HTTP/1.1 - http

Environment variables [optional]

required found
Git installed
Composer missing
Ruby missing
Ruby gem missing
Compass missing
NodeJs 6.0 missing
npm 3.10.0 missing

Environment

Requirements

required found
Server type apache
Server version 2.5 2.4.29
PHP interface type apache2handler
PHP 7.1 7.2.16-1+ubuntu18.04.1+deb.sury.org+1
php_int_size 64-bit 64-bit
PCRE 8.02 8.42
PDO installed installed
PDO_MYSQL installed installed
OpenSSL installed installed
XML installed installed
GD Library (for Image plugin) installed installed
cURL (for Web plugin) installed installed
Redis [optional] 3.0.0 missing
ZeroMQ extension 1.1.3 1.1.3
ZeroMQ installation 4.1.3 4.2.2
Event extension 2.3.0 missing
mod_rewrite enabled enabled
mod_headers enabled enabled

PHP config (php.ini)

required found
exec() 1 1
memory_limit 128M 128
max_input_vars 3000 5000
max_execution_time 10 30
html_errors 0 1
save_handler files
session.save_path /var/lib/php/sessions
session.name pathfinder_session

Settings

Configuration

ENVIRONMENT_CONFIG Config: conf/environment.ini
BASE [missing]
URL http://dreddalliance.com
DEBUG 3
CCP_SSO_URL https://login.eveonline.com
CCP_SSO_CLIENT_ID 04d6a653797d429497cdc5___ [32]
CCP_SSO_SECRET_KEY 6B2LWUpKuVEUmnzQLE8leJSp5CigoY___ [40]
CCP_SSO_DOWNTIME 11:00
CCP_ESI_URL https://esi.evetech.net
CCP_ESI_DATASOURCE singularity
SMTP_HOST localhost
SMTP_PORT 25
SMTP_SCHEME TLS
SMTP_USER pathfinder
SMTP_PASS ___ [4]
SMTP_FROM pathfinder@localhost.com
SMTP_ERROR pathfinder@localhost.com

Modules

Registration/Login enabled
Slack disabled
Discord disabled

Map Settings

private corporation alliance
Map lifetime (days) 60 99999 99999
Max. maps count/user 3 5 4
Map share limit/map 10 4 2
Max. systems count/map 50 100 100
Activity statistics enabled enabled disabled
History log files enabled enabled enabled
History log Slack disabled enabled enabled
Rally point poke Slack enabled enabled enabled
History log Discord disabled enabled enabled
Rally point poke Discord enabled enabled enabled
Rally point poke Email disabled disabled disabled

Database

Pathfinder

DB driver mysql
DB host:port localhost:3306
DB name pathfinder
DB user root
DB pass ___ [6]
DB status connected
required installed
DB version 5.7 5.7.25
default_storage_engine InnoDB InnoDB
character_set_database utf8 utf8
character_set_client utf8 utf8
character_set_results utf8 utf8
character_set_connection utf8 utf8
collation_database utf8_general_ci utf8_general_ci
collation_connection utf8_general_ci utf8_general_ci
foreign_key_checks ON ON
innodb_file_per_table ON ON
Table exist  
activity_log
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. year smallint(6) 0 1 0
4. week tinyint(4) 0 1 0
5. active tinyint(1) 0 1 0
6. characterId int(11) 1 1 0
7. mapId int(11) 1 1 0
8. mapCreate smallint(6) 0 0 0
9. mapUpdate smallint(6) 0 0 0
10. mapDelete smallint(6) 0 0 0
11. systemCreate smallint(6) 0 0 0
12. systemUpdate smallint(6) 0 0 0
13. systemDelete smallint(6) 0 0 0
14. connectionCreate smallint(6) 0 0 0
15. connectionUpdate smallint(6) 0 0 0
16. connectionDelete smallint(6) 0 0 0
17. signatureCreate smallint(6) 0 0 0
18. signatureUpdate smallint(6) 0 0 0
19. signatureDelete smallint(6) 0 0 0
foreign key
1. fk_activity_log___characterId___character___id
2. fk_activity_log___mapId___map___id
alliance
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. ticker varchar(128) 0 0 0
6. shared tinyint(1) 0 0 0
alliance_map
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. allianceId int(11) 1 1 0
5. mapId int(11) 1 1 0
foreign key
1. fk_alliance_map___allianceId___alliance___id
2. fk_alliance_map___mapId___map___id
character
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. lastLogin timestamp 1 1 0
4. active tinyint(1) 0 1 0
5. name varchar(128) 0 0 0
6. ownerHash varchar(128) 0 0 0
7. esiAccessToken varchar(255) 1 0 0
8. esiAccessTokenExpires timestamp 1 1 0
9. esiRefreshToken varchar(255) 1 0 0
10. esiScopes text 1 0 0
11. corporationId int(11) 1 1 0
12. allianceId int(11) 1 1 0
13. roleId int(11) 0 1 0
14. kicked timestamp 1 1 0
15. banned timestamp 1 1 0
16. shared tinyint(1) 0 0 0
17. logLocation tinyint(1) 0 0 0
18. selectLocation tinyint(1) 0 0 0
19. securityStatus float 0 0 0
foreign key
1. fk_character___corporationId___corporation___id
2. fk_character___allianceId___alliance___id
3. fk_character___roleId___role___id
character_authentication
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. characterId int(11) 1 1 0
5. selector varchar(128) 0 1 1
6. token varchar(128) 0 1 0
7. expires timestamp 1 1 0
foreign key
1. fk_character_authentication___characterId___character___id
character_log
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. characterId int(11) 1 1 1
5. systemId int(11) 1 1 0
6. systemName varchar(128) 0 0 0
7. shipTypeId int(11) 1 1 0
8. shipTypeName varchar(128) 0 0 0
9. shipId bigint(20) 1 1 0
10. shipMass float 0 0 0
11. shipName varchar(128) 0 0 0
12. stationId int(11) 1 1 0
13. stationName varchar(128) 0 0 0
14. structureId bigint(20) 1 1 0
15. structureName varchar(128) 0 0 0
foreign key
1. fk_character_log___characterId___character___id
character_map
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. characterId int(11) 1 1 0
5. mapId int(11) 1 1 0
foreign key
1. fk_character_map___characterId___character___id
2. fk_character_map___mapId___map___id
character_status
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. class varchar(128) 0 0 0
connection
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. createdCharacterId int(11) 1 1 0
4. updatedCharacterId int(11) 1 1 0
5. active tinyint(1) 0 1 0
6. mapId int(11) 1 1 0
7. source int(11) 1 1 0
8. target int(11) 1 1 0
9. scope varchar(128) 0 0 0
10. type text 1 0 0
11. eolUpdated timestamp 1 0 0
foreign key
1. fk_connection___createdCharacterId___character___id
2. fk_connection___updatedCharacterId___character___id
3. fk_connection___mapId___map___id
4. fk_connection___source___system___id
5. fk_connection___target___system___id
connection_log
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. connectionId int(11) 1 1 0
5. record tinyint(1) 0 1 0
6. shipTypeId int(11) 1 1 0
7. shipTypeName varchar(128) 0 0 0
8. shipMass float 0 0 0
9. characterId int(11) 1 1 0
10. characterName varchar(128) 0 0 0
foreign key
1. fk_connection_log___connectionId___connection___id
connection_scope
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
6. connectorDefinition varchar(255) 0 0 0
corporation
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. ticker varchar(128) 0 0 0
6. memberCount int(11) 0 0 0
7. shared tinyint(1) 0 0 0
8. isNPC tinyint(1) 0 0 0
corporation_map
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. corporationId int(11) 1 1 0
5. mapId int(11) 1 1 0
foreign key
1. fk_corporation_map___corporationId___corporation___id
2. fk_corporation_map___mapId___map___id
corporation_right
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. corporationId int(11) 1 1 0
5. rightId int(11) 1 1 0
6. roleId int(11) 1 1 0
foreign key
1. fk_corporation_right___corporationId___corporation___id
2. fk_corporation_right___rightId___right___id
3. fk_corporation_right___roleId___role___id
corporation_structure
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. corporationId int(11) 1 1 0
5. structureId int(11) 1 1 0
foreign key
1. fk_corporation_structure___corporationId___corporation___id
2. fk_corporation_structure___structureId___structure___id
map
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. createdCharacterId int(11) 1 1 0
4. updatedCharacterId int(11) 1 1 0
5. active tinyint(1) 0 1 0
6. scopeId int(11) 1 1 0
7. typeId int(11) 1 1 0
8. name varchar(128) 0 0 0
9. icon varchar(128) 0 0 0
10. deleteExpiredConnections tinyint(1) 0 0 0
11. deleteEolConnections tinyint(1) 0 0 0
12. persistentAliases tinyint(1) 0 0 0
13. logActivity tinyint(1) 0 0 0
14. logHistory tinyint(1) 0 0 0
15. slackWebHookURL varchar(128) 0 0 0
16. slackUsername varchar(128) 0 0 0
17. slackIcon varchar(128) 0 0 0
18. slackChannelHistory varchar(128) 0 0 0
19. slackChannelRally varchar(128) 0 0 0
20. discordUsername varchar(128) 0 0 0
21. discordWebHookURLRally varchar(255) 0 0 0
22. discordWebHookURLHistory varchar(255) 0 0 0
foreign key
1. fk_map___createdCharacterId___character___id
2. fk_map___updatedCharacterId___character___id
3. fk_map___scopeId___map_scope___id
4. fk_map___typeId___map_type___id
map_scope
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
map_type
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
6. class varchar(128) 0 0 0
7. classTab varchar(128) 0 0 0
right
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. active tinyint(1) 0 1 0
4. name varchar(128) 0 0 0
5. label varchar(128) 0 0 0
6. description varchar(512) 0 0 0