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.2.2
Package Fat-Free Framework 3.7.3-Release
Contact https://github.com/exodus4d
Repository https://github.com/exodus4d/pathfinder

Directories

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

Server

Time 2026/01/12 23:13:39 - (UTC)
OS Linux
Host name 09517723cfdf
Release name 6.12.63+deb13-amd64
Version info #1 SMP PREEMPT_DYNAMIC Debian 6.12.63-1 (2025-12-30)
Machine type x86_64
Document root /var/www/pathfinder
Port 443
Protocol - scheme HTTP/1.1 - https

Environment variables [optional]

required found
Git installed
Composer installed
NodeJs 12.2 14.21.3
npm 6.13.4 6.14.18

OK

Server

Requirements

required found
Server type nginx
Server version 1.9 1.18.0
PHP interface type fpm-fcgi
PHP 7.2 7.2.34-40+ubuntu20.04.1+deb.sury.org+1
php_int_size 64-bit 64-bit

PHP extensions

PCRE 8.02 8.45
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 5.3.7

LibEvent library [optional]

Event extension 2.3.0 missing

1 warning

PHP config php.ini

required found
exec() 1 1
memory_limit 256M 256
max_input_vars 3000 3000
max_execution_time 10 30
html_errors 0 1

Session

save_handler redis
session.save_path tcp://redis:6379
session.name pathfinder_session

1 warning

Environment
2

Configuration

ENVIRONMENT_CONFIG Config: app/environment.ini
BASE  
URL https://pathfinder-test.scan-stakan.space
DEBUG 0
CCP_SSO_URL https://login.eveonline.com
CCP_SSO_CLIENT_ID 1f9c098e65b94190b09157___ [32]
CCP_SSO_SECRET_KEY BnKRoCFCCUXhfqOpdUHY0mMdxWQJW5___ [40]
CCP_SSO_DOWNTIME 11:00
CCP_ESI_URL https://esi.evetech.net
CCP_ESI_DATASOURCE tranquility
SMTP_HOST localhost
SMTP_PORT 25
SMTP_SCHEME TLS
SMTP_USER [missing]
SMTP_PASS [missing]
SMTP_FROM registration@pathfinder-w.space
SMTP_ERROR admin@pathfinder-w.space

Modules

Registration/Login enabled
Slack enabled
Discord enabled

Map Settings

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

Settings

Pathfinder

DB driver mysql
DB host:port mysql:3306
DB name pathfinder
DB user pathfinder
DB pass gkgJf7K8hKVg___ [20]
DB status connected (persistent)
required installed
DB version 5.7 5.7.44
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 28800
interactive_timeout 28800 28800

OK

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(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 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(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 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 text 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. cloneLocationId bigint(20) 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(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 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(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. structureTypeId int(11) 1 1 0
15. structureTypeName varchar(128) 0 0 0
16. structureId bigint(20) 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(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 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(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. 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(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 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(11) 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(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 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(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 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(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
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(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. 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 0 0
21. slackChannelRally varchar(128) 0 0 0
22. discordUsername varchar(128) 0 0 0
23. discordWebHookURLRally varchar(255) 0 0 0
24. 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 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
map_type 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. class varchar(128) 0 0 0
7. classTab varchar(128) 0 0 0
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. name varchar(128) 0 1 1
5. label varchar(128) 0 0 0
6. description varchar(512) 0 0 0
role 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. level int(11) 1 1 0
7. style varchar(128) 0 0 0
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. structureId int(11) 1 1 0
5. corporationId int(11) 1 1 0
6. systemId int(11) 1 1 0
7. statusId int(11) 1 1 0
8. name varchar(128) 0 0 0
9. description varchar(512) 0 0 0
foreign key
1. fk_structure___corporationId___corporation___id
2. fk_structure___statusId___structure_status___id
structure_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. label varchar(128) 0 0 0
6. class varchar(128) 0 0 0
system utf8mb4
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. systemId int(11) 1 1 0
8. alias varchar(128) 0 0 0
9. typeId int(11) 1 1 0
10. statusId int(11) 0 1 0
11. locked tinyint(1) 0 0 0
12. rallyUpdated timestamp 1 0 0
13. rallyPoke tinyint(1) 0 0 0
14. description text 1 0 0
15. posX int(11) 0 0 0
16. posY int(11) 0 0 0
foreign key
1. fk_system___createdCharacterId___character___id
2. fk_system___updatedCharacterId___character___id
3. fk_system___mapId___map___id
4. fk_system___typeId___system_type___id
5. fk_system___statusId___system_status___id
system_jumps 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. systemId int(11) 1 1 1
5. lastUpdatedValue int(11) 0 1 0
6. value1 int(11) 0 0 0
7. value2 int(11) 0 0 0
8. value3 int(11) 0 0 0
9. value4 int(11) 0 0 0
10. value5 int(11) 0 0 0
11. value6 int(11) 0 0 0
12. value7 int(11) 0 0 0
13. value8 int(11) 0 0 0
14. value9 int(11) 0 0 0
15. value10 int(11) 0 0 0
16. value11 int(11) 0 0 0
17. value12 int(11) 0 0 0
18. value13 int(11) 0 0 0
19. value14 int(11) 0 0 0
20. value15 int(11) 0 0 0
21. value16 int(11) 0 0 0
22. value17 int(11) 0 0 0
23. value18 int(11) 0 0 0
24. value19 int(11) 0 0 0
25. value20 int(11) 0 0 0
26. value21 int(11) 0 0 0
27. value22 int(11) 0 0 0
28. value23 int(11) 0 0 0
29. value24 int(11) 0 0 0
system_kills_factions 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. systemId int(11) 1 1 1
5. lastUpdatedValue int(11) 0 1 0
6. value1 int(11) 0 0 0
7. value2 int(11) 0 0 0
8. value3 int(11) 0 0 0
9. value4 int(11) 0 0 0
10. value5 int(11) 0 0 0
11. value6 int(11) 0 0 0
12. value7 int(11) 0 0 0
13. value8 int(11) 0 0 0
14. value9 int(11) 0 0 0
15. value10 int(11) 0 0 0
16. value11 int(11) 0 0 0
17. value12 int(11) 0 0 0
18. value13 int(11) 0 0 0
19. value14 int(11) 0 0 0
20. value15 int(11) 0 0 0
21. value16 int(11) 0 0 0
22. value17 int(11) 0 0 0
23. value18 int(11) 0 0 0
24. value19 int(11) 0 0 0
25. value20 int(11) 0 0 0
26. value21 int(11) 0 0 0
27. value22 int(11) 0 0 0
28. value23 int(11) 0 0 0
29. value24 int(11) 0 0 0
system_kills_pods 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. systemId int(11) 1 1 1
5. lastUpdatedValue int(11) 0 1 0
6. value1 int(11) 0 0 0
7. value2 int(11) 0 0 0
8. value3 int(11) 0 0 0
9. value4 int(11) 0 0 0
10. value5 int(11) 0 0 0
11. value6 int(11) 0 0 0
12. value7 int(11) 0 0 0
13. value8 int(11) 0 0 0
14. value9 int(11) 0 0 0
15. value10 int(11) 0 0 0
16. value11 int(11) 0 0 0
17. value12 int(11) 0 0 0
18. value13 int(11) 0 0 0
19. value14 int(11) 0 0 0
20. value15 int(11) 0 0 0
21. value16 int(11) 0 0 0
22. value17 int(11) 0 0 0
23. value18 int(11) 0 0 0
24. value19 int(11) 0 0 0
25. value20 int(11) 0 0 0
26. value21 int(11) 0 0 0
27. value22 int(11) 0 0 0
28. value23 int(11) 0 0 0
29. value24 int(11) 0 0 0
system_kills_ships 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. systemId int(11) 1 1 1
5. lastUpdatedValue int(11) 0 1 0
6. value1 int(11) 0 0 0
7. value2 int(11) 0 0 0
8. value3 int(11) 0 0 0
9. value4 int(11) 0 0 0
10. value5 int(11) 0 0 0
11. value6 int(11) 0 0 0
12. value7 int(11) 0 0 0
13. value8 int(11) 0 0 0
14. value9 int(11) 0 0 0
15. value10 int(11) 0 0 0
16. value11 int(11) 0 0 0
17. value12 int(11) 0 0 0
18. value13 int(11) 0 0 0
19. value14 int(11) 0 0 0
20. value15 int(11) 0 0 0
21. value16 int(11) 0 0 0
22. value17 int(11) 0 0 0
23. value18 int(11) 0 0 0
24. value19 int(11) 0 0 0
25. value20 int(11) 0 0 0
26. value21 int(11) 0 0 0
27. value22 int(11) 0 0 0
28. value23 int(11) 0 0 0
29. value24 int(11) 0 0 0
system_signature utf8mb4
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. systemId int(11) 1 1 0
7. groupId int(11) 0 1 0
8. typeId int(11) 0 1 0
9. connectionId int(11) 1 1 0
10. name varchar(128) 0 0 0
11. description varchar(512) 0 0 0
foreign key
1. fk_system_signature___createdCharacterId___character___id
2. fk_system_signature___updatedCharacterId___character___id
3. fk_system_signature___systemId___system___id
4. fk_system_signature___connectionId___connection___id
system_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. label varchar(128) 0 0 0
6. class varchar(128) 0 0 0
system_type 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
user 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 1 0
5. email varchar(128) 0 0 0
user_character 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. userId int(11) 1 1 0
5. characterId int(11) 1 1 1
foreign key
1. fk_user_character___userId___user___id
2. fk_user_character___characterId___character___id

OK

Setup tables Fix columns/keys

EVE-Online universe

DB driver mysql
DB host:port mysql:3306
DB name eve_universe
DB user pathfinder
DB pass gkgJf7K8hKVg___ [20]
DB status connected (persistent)
required installed
DB version 5.7 5.7.44
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 28800
interactive_timeout 28800 28800

OK

Table exist charset
alliance utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. ticker varchar(128) 0 0 0
5. dateFounded datetime 1 0 0
6. factionId int(11) 1 1 0
foreign key
1. fk_alliance___factionId___faction___id
category utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. published tinyint(1) 0 1 0
constellation utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. regionId int(11) 1 1 0
5. x bigint(20) 0 0 0
6. y bigint(20) 0 0 0
7. z bigint(20) 0 0 0
foreign key
1. fk_constellation___regionId___region___id
corporation utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. ticker varchar(128) 0 0 0
5. dateFounded datetime 1 0 0
6. memberCount int(11) 0 0 0
7. isNPC tinyint(1) 0 0 0
8. factionId int(11) 1 1 0
9. allianceId int(11) 1 1 0
foreign key
1. fk_corporation___factionId___faction___id
2. fk_corporation___allianceId___alliance___id
dogma_attribute utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. displayName varchar(128) 1 0 0
5. description text 1 0 0
6. published tinyint(1) 1 0 0
7. stackable tinyint(1) 1 0 0
8. highIsGood tinyint(1) 1 0 0
9. defaultValue float 0 0 0
10. iconId int(11) 1 0 0
11. unitId int(11) 1 0 0
faction utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. description text 1 0 0
5. sizeFactor int(11) 0 0 0
6. stationCount int(11) 0 0 0
7. stationSystemCount int(11) 0 0 0
faction_war_system utf8mb4
column exist type null I U
1. systemId int(11) 1 1 1
2. ownerFactionId int(11) 1 1 0
3. occupierFactionId int(11) 1 1 0
4. contested varchar(128) 0 0 0
5. victoryPoints int(11) 0 0 0
6. victoryPointsThreshold int(11) 0 0 0
foreign key
1. fk_faction_war_system___systemId___system___id
2. fk_faction_war_system___ownerFactionId___faction___id
3. fk_faction_war_system___occupierFactionId___faction___id
group utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. published tinyint(1) 0 1 0
5. categoryId int(11) 1 1 0
foreign key
1. fk_group___categoryId___category___id
planet utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. systemId int(11) 1 1 0
5. typeId int(11) 1 1 0
6. x bigint(20) 0 0 0
7. y bigint(20) 0 0 0
8. z bigint(20) 0 0 0
foreign key
1. fk_planet___systemId___system___id
2. fk_planet___typeId___type___id
race utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. description text 1 0 0
5. factionId int(11) 1 1 0
foreign key
1. fk_race___factionId___faction___id
region utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. description text 1 0 0
sovereignty_map utf8mb4
column exist type null I U
1. systemId int(11) 1 1 1
2. factionId int(11) 1 1 0
3. allianceId int(11) 1 1 0
4. corporationId int(11) 1 1 0
foreign key
1. fk_sovereignty_map___systemId___system___id
2. fk_sovereignty_map___factionId___faction___id
3. fk_sovereignty_map___allianceId___alliance___id
4. fk_sovereignty_map___corporationId___corporation___id
star utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. typeId int(11) 1 1 0
5. age bigint(20) 1 0 0
6. radius bigint(20) 1 0 0
7. temperature int(11) 1 0 0
8. luminosity float 1 0 0
9. spectralClass varchar(128) 1 0 0
foreign key
1. fk_star___typeId___type___id
stargate utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. systemId int(11) 1 1 0
5. typeId int(11) 1 1 0
6. destinationSystemId int(11) 1 1 0
7. x bigint(20) 0 0 0
8. y bigint(20) 0 0 0
9. z bigint(20) 0 0 0
foreign key
1. fk_stargate___systemId___system___id
2. fk_stargate___typeId___type___id
3. fk_stargate___destinationSystemId___system___id
station utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. systemId int(11) 1 1 0
5. typeId int(11) 1 1 0
6. corporationId int(11) 1 1 0
7. raceId int(11) 1 1 0
8. services text 1 0 0
9. x bigint(20) 0 0 0
10. y bigint(20) 0 0 0
11. z bigint(20) 0 0 0
foreign key
1. fk_station___systemId___system___id
2. fk_station___typeId___type___id
3. fk_station___corporationId___corporation___id
4. fk_station___raceId___race___id
structure utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. systemId int(11) 1 1 0
5. typeId int(11) 1 1 0
6. x float 0 0 0
7. y float 0 0 0
8. z float 0 0 0
foreign key
1. fk_structure___systemId___system___id
2. fk_structure___typeId___type___id
system utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. constellationId int(11) 1 1 0
5. starId int(11) 1 1 0
6. security varchar(128) 1 0 0
7. trueSec float 0 0 0
8. securityStatus decimal(18,6) 0 0 0
9. securityClass varchar(128) 1 0 0
10. effect varchar(128) 1 0 0
11. x bigint(20) 0 0 0
12. y bigint(20) 0 0 0
13. z bigint(20) 0 0 0
foreign key
1. fk_system___constellationId___constellation___id
2. fk_system___starId___star___id
system_neighbour utf8mb4
column exist type null I U
1. regionId int(11) 1 1 0
2. constellationId int(11) 1 1 0
3. systemId int(11) 1 1 1
4. systemName varchar(128) 0 0 0
5. jumpNodes varchar(512) 0 0 0
6. trueSec decimal(18,6) 0 0 0
foreign key
1. fk_system_neighbour___regionId___region___id
2. fk_system_neighbour___constellationId___constellation___id
3. fk_system_neighbour___systemId___system___id
system_static utf8mb4
column exist type null I U
1. systemId int(11) 1 1 0
2. typeId int(11) 1 1 0
foreign key
1. fk_system_static___systemId___system___id
2. fk_system_static___typeId___type___id
type utf8mb4
column exist type null I U
1. created timestamp 1 1 0
2. updated timestamp 1 1 0
3. name varchar(128) 0 0 0
4. description text 1 0 0
5. published tinyint(1) 0 1 0
6. radius float 0 0 0
7. volume float 0 0 0
8. capacity float 0 0 0
9. mass float 0 0 0
10. groupId int(11) 1 1 0
11. marketGroupId int(11) 0 1 0
12. packagedVolume float 0 0 0
13. portionSize int(11) 0 0 0
14. graphicId int(11) 0 1 0
foreign key
1. fk_type___groupId___group___id
type_attribute utf8mb4
column exist type null I U
1. typeId int(11) 1 1 0
2. attributeId int(11) 1 1 0
3. value float 0 0 0
foreign key
1. fk_type_attribute___typeId___type___id
2. fk_type_attribute___attributeId___dogma_attribute___id

OK

Setup tables Fix columns/keys

Database

Redis server No.1

DSN redis:6379
status connected
required found
redis_version 3.0 5.0.14
maxmemory 64M 0
used_memory 4.29M
used_memory_peak 4.53M
maxmemory_policy allkeys-lru noeviction
connected_clients 2
blocked_clients 0
evicted_keys 0

Databases

db(0) : SESSION 4 keys
 Flush
db(5) : CACHE; API_CACHE 285 keys
 Flush

OK

Cache [optional]
4

  TCP-Socket (intern) 1 con    1 con max

HOST 127.0.0.1
PORT 5555
URI tcp://127.0.0.1:5555
timeout (seconds) 0.6
uptime 11h 57m 31s

PING OK

client URI file #line message type
23:13:40 127.0.0.1:38940 TcpSocket task "healthCheck" processing…
23:13:08 127.0.0.1:54802 TcpSocket task "healthCheck" done → response send
23:13:08 127.0.0.1:54802 TcpSocket task "healthCheck" processing…
23:10:19 127.0.0.1:55896 TcpSocket task "healthCheck" done → response send
23:10:19 127.0.0.1:55896 TcpSocket task "healthCheck" processing…
23:10:08 127.0.0.1:57170 TcpSocket task "healthCheck" done → response send
23:10:08 127.0.0.1:57170 TcpSocket task "healthCheck" processing…
17:48:48 127.0.0.1:57942 TcpSocket task "healthCheck" done → response send
17:48:48 127.0.0.1:57942 TcpSocket task "healthCheck" processing…
11:16:09 AbstractSocket start Socket server…

  Web-Socket 0 con    0 con max

URI

INIT CONNECTION…

client URI file #line message type
11:16:09 AbstractMessag… start WebSocket server…

Socket configuration [optional]
1 1

  Configuration app/cron.ini

required found
LOG 1 1
CLI 1 1
WEB 0
SILENT 1

  Jobs

last
status name schedule start time exec. time mem. peak
cleanUpCharacterData @hourly 23:00:01  0.470s 3.82M
deactivateMapData @hourly 23:00:01  0.471s 3.6M
deleteAuthenticationData @downtime 11:00:01
deleteEolConnections @fiveMinutes 23:10:01 0.093s 3.6M
deleteExpiredCacheData @downtime 11:00:01  0.691s 3.59M
deleteExpiredConnections @hourly 23:00:01 0.448s 3.6M
deleteLogData @instant 23:13:01 0.101s 3.59M
deleteMapData @downtime 11:00:01 0.636s 3.6M
deleteSignatures @halfHour 23:00:01  0.444s 3.6M
deleteStatisticsData @weekly 00:00:02 0.585s 3.58M
importSystemData @halfPastHour 22:30:01 15.396s 13.9M
truncateMapHistoryLogFiles @halfHour 23:00:01  0.422s 3.6M
updateSovereigntyData @halfPastHour 22:30:01 16.075s 22.58M

Cronjob
1

  Import static data

count sub count
Wormholes data 126/127
 Import
Structures data 14/15 41/42
 Import
Ships data 47/48 534/558
 Import
Wormhole statics data 3772/3772
 Import

   Build search index

Systems data index 95/8286
 Clear  Build
Systems neighbour index 5201/5201
 Clear  Build

  Filesystem cache 116.61KB

Temp dir tmp/ → 116.61KB
 Delete files
Cache dir tmp/cache/ → 0KB
 Delete files

  Cookies

Invalidate all Cookie data
 Clear authentication data

Administration
4