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.

Information

Installation Pathfinder
Version v2.0.0
Package Fat-Free Framework 3.7.1-Release
Contact https://github.com/exodus4d
Repository https://github.com/exodus4d/pathfinder

Directories

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

Server

Time 2024/06/14 01:29:22 - (UTC)
OS Linux
Host name gvam1288.siteground.biz
Release name 6.6.21-MCIclouder470
Version info #470 SMP PREEMPT_DYNAMIC Fri Mar 8 08:09:36 EET 2024
Machine type x86_64
Document root /home/customer/www/mialta.com/public_html
Port 443
Protocol - scheme HTTP/1.0 - https

Environment variables [optional]

required found
Git installed
Composer installed
NodeJs 12.2 missing
npm 6.13.4 missing

Server
2

Requirements

required found
Server type apache
Server version 2.5 unknown
PHP interface type cgi-fcgi
PHP 7.2 7.4.33
php_int_size 64-bit 64-bit
PCRE 8.02 10.35
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
Event extension 2.3.0 missing
mod_rewrite enabled unknown
mod_headers enabled unknown

PHP config php.ini

required found
exec() 1 1
memory_limit 128M 768
max_input_vars 3000 3000
max_execution_time 10 120
html_errors 0 1
save_handler files
session.save_path /tmp
session.name pathfinder_session

Environment
6

Configuration

ENVIRONMENT_CONFIG Config: app/environment.ini
BASE  
URL https://www.mialta.com
DEBUG 0
CCP_SSO_URL https://login.eveonline.com
CCP_SSO_CLIENT_ID [missing]
CCP_SSO_SECRET_KEY [missing]
CCP_SSO_DOWNTIME 11:00
CCP_ESI_URL https://esi.evetech.net
CCP_ESI_DATASOURCE tranquility
SMTP_HOST [missing]
SMTP_PORT [missing]
SMTP_SCHEME [missing]
SMTP_USER [missing]
SMTP_PASS [missing]
SMTP_FROM [missing]
SMTP_ERROR [missing]

Modules

Registration/Login enabled
Slack enabled
Discord enabled

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

Settings

Pathfinder

DB driver mysql
DB host:port localhost:3306
DB name mialta_pathfinder
DB user mialta_pathfind
DB pass 1___ [9]
DB status connected (persistent)
required installed
DB version 5.7 26
default_storage_engine InnoDB InnoDB
character_set_server utf8mb4 utf8mb4
character_set_database utf8mb4 utf8mb4
character_set_client utf8mb4 utf8mb4
character_set_results utf8mb4 utf8mb4
character_set_connection utf8mb4 utf8mb4
collation_database utf8mb4_unicode_ci utf8mb4_unicode_ci
collation_connection utf8mb4_unicode_ci utf8mb4_unicode_ci
foreign_key_checks ON ON
innodb_file_per_table ON ON
wait_timeout 28800 60
interactive_timeout 28800 60
Table exist charset
activity_log utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. year smallint 0 1 0
4. week tinyint 0 1 0
5. active tinyint(1) 0 1 0
6. characterId int 1 1 0
7. mapId int 1 1 0
8. mapCreate smallint 0 0 0
9. mapUpdate smallint 0 0 0
10. mapDelete smallint 0 0 0
11. systemCreate smallint 0 0 0
12. systemUpdate smallint 0 0 0
13. systemDelete smallint 0 0 0
14. connectionCreate smallint 0 0 0
15. connectionUpdate smallint 0 0 0
16. connectionDelete smallint 0 0 0
17. signatureCreate smallint 0 0 0
18. signatureUpdate smallint 0 0 0
19. signatureDelete smallint 0 0 0
foreign key
1. fk_activity_log___characterId___character___id
2. fk_activity_log___mapId___map___id
alliance utf8mb4
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 utf8mb4
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 1 1 0
5. mapId int 1 1 0
foreign key
1. fk_alliance_map___allianceId___alliance___id
2. fk_alliance_map___mapId___map___id
character utf8mb4
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 1 1 0
12. allianceId int 1 1 0
13. roleId int 0 1 0
14. cloneLocationId bigint 1 1 0
15. cloneLocationType varchar(128) 0 0 0
16. kicked timestamp 1 1 0
17. banned timestamp 1 1 0
18. shared tinyint(1) 0 0 0
19. logLocation tinyint(1) 0 0 0
20. selectLocation tinyint(1) 0 0 0
21. 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 utf8mb4
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 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 utf8mb4
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 1 1 1
5. systemId int 1 1 0
6. systemName varchar(128) 0 0 0
7. shipTypeId int 1 1 0
8. shipTypeName varchar(128) 0 0 0
9. shipId bigint 1 1 0
10. shipMass float 0 0 0
11. shipName varchar(128) 0 0 0
12. stationId int 1 1 0
13. stationName varchar(128) 0 0 0
14. structureTypeId int 1 1 0
15. structureTypeName varchar(128) 0 0 0
16. structureId bigint 1 1 0
17. structureName varchar(128) 0 0 0
foreign key
1. fk_character_log___characterId___character___id
character_map utf8mb4
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 1 1 0
5. mapId int 1 1 0
foreign key
1. fk_character_map___characterId___character___id
2. fk_character_map___mapId___map___id
character_status utf8mb4
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 utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. createdCharacterId int 1 1 0
4. updatedCharacterId int 1 1 0
5. active tinyint(1) 0 1 0
6. mapId int 1 1 0
7. source int 1 1 0
8. target int 1 1 0
9. scope varchar(128) 0 0 0
10. type text 1 0 0
11. sourceEndpointType text 1 0 0
12. targetEndpointType text 1 0 0
13. 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 utf8mb4
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 1 1 0
5. record tinyint(1) 0 1 0
6. shipTypeId int 1 1 0
7. shipTypeName varchar(128) 0 0 0
8. shipMass float 0 0 0
9. characterId int 1 1 0
10. characterName varchar(128) 0 0 0
foreign key
1. fk_connection_log___connectionId___connection___id
connection_scope utf8mb4
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 utf8mb4
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 0 0 0
7. shared tinyint(1) 0 0 0
8. isNPC tinyint(1) 0 0 0
corporation_map utf8mb4
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 1 1 0
5. mapId int 1 1 0
foreign key
1. fk_corporation_map___corporationId___corporation___id
2. fk_corporation_map___mapId___map___id
corporation_right utf8mb4
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 1 1 0
5. rightId int 1 1 0
6. roleId int 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 utf8mb4
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 1 1 0
5. structureId int 1 1 0
foreign key
1. fk_corporation_structure___corporationId___corporation___id
2. fk_corporation_structure___structureId___structure___id
cron utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 1 1
4. handler varchar(255) 0 1 1
5. expr varchar(128) 0 0 0
6. isPaused tinyint(1) 0 0 0
7. lastExecStart decimal(18,6) 1 0 0
8. lastExecEnd decimal(18,6) 1 0 0
9. lastExecMemPeak float 1 0 0
10. lastExecState text 1 0 0
11. history text 1 0 0
map utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. createdCharacterId int 1 1 0
4. updatedCharacterId int 1 1 0
5. active tinyint(1) 0 1 0
6. scopeId int 1 1 0
7. typeId int 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. persistentSignatures tinyint(1) 0 0 0
14. trackAbyssalJumps tinyint(1) 0 0 0
15. logActivity tinyint(1) 0 0 0
16. logHistory tinyint(1) 0 0 0
17. slackWebHookURL varchar(128) 0 0 0
18. slackUsername varchar(128) 0 0 0
19. slackIcon varchar(128) 0 0 0
20. slackChannelHistory varchar(128) 0