SeAT

https://eveseat.github.io/docs
Admin
SeAT is an administration and management tool for EVE Online, providing features for installation,...
Tokens:27,040
Snippets:432
Trust Score:8.3
Update:3 months ago
Show doc for...
Tokens:
Raw
### Prepare Installation Directory

Source: https://eveseat.github.io/docs/installation/manual_installation

Creates and navigates to the web root directory for the SeAT installation.

```bash
mkdir -p /var/www
```

```bash
cd /var/www
```

--------------------------------

### Install Nginx and PHP-FPM

Source: https://eveseat.github.io/docs/installation/manual_installation

Installs the necessary web server and PHP processor packages.

```bash
apt-get install nginx php8.2-fpm
```

--------------------------------

### Install Git

Source: https://eveseat.github.io/docs/installation/manual_installation

Installs the git client required for downloading the SeAT source code.

```bash
apt-get install git
```

--------------------------------

### Install Redis Server

Source: https://eveseat.github.io/docs/installation/manual_installation

Installs the Redis server package.

```bash
apt-get install redis-server
```

--------------------------------

### Install Composer

Source: https://eveseat.github.io/docs/installation/manual_installation

Downloads and installs the Composer package manager to /usr/local/bin.

```bash
curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/local/bin --filename=composer && hash -r
```

--------------------------------

### Install MariaDB Server

Source: https://eveseat.github.io/docs/installation/manual_installation

Installs the MariaDB database server package.

```bash
apt-get install mariadb-server
```

--------------------------------

### Install curl

Source: https://eveseat.github.io/docs/installation/manual_installation

Installs the curl utility required for downloading the MariaDB repository setup script.

```bash
apt-get install curl
```

--------------------------------

### Install Docker on Linux

Source: https://eveseat.github.io/docs/installation/docker_installation

Installs Docker on Linux systems using the official installation script.

```bash
sh <(curl -fsSL get.docker.com)
```

--------------------------------

### Start SeAT Stack

Source: https://eveseat.github.io/docs/installation/docker_installation

Initializes the Docker containers using the appropriate configuration files.

```bash
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.traefik.yml up
```

```bash
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.proxy.yml up
```

--------------------------------

### Manage Blade Installation Services

Source: https://eveseat.github.io/docs/upgrading/general

Commands to stop and start supervisor workers during the upgrade process.

```bash
supervisorctl stop all
```

```bash
supervisorctl start all
```

--------------------------------

### Add MariaDB Repository

Source: https://eveseat.github.io/docs/installation/manual_installation

Downloads and executes the official MariaDB repository setup script.

```bash
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | bash
```

--------------------------------

### Composer Output Example

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/bare_metal

Expected output after running the composer create-project command.

```text
76 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
> @php artisan vendor:publish --tag=laravel-assets --ansi --force

   INFO  Publishing [laravel-assets] assets.  

  Copying directory [vendor/laravel/horizon/public] to [public/vendor/horizon]  DONE
  Copying directory [vendor/opcodesio/log-viewer/public] to [public/vendor/log-viewer]  DONE

No security vulnerability advisories found.
> @php artisan key:generate --ansi

   INFO  Application key set successfully.  
```

--------------------------------

### Docker-compose Download Placeholder

Source: https://eveseat.github.io/docs/installation/docker_installation

Placeholder block for Docker Compose installation instructions.

```text
1
2
3
```

--------------------------------

### Install SeAT Project

Source: https://eveseat.github.io/docs/admin_guides/scaled_deployments

Use composer to download the SeAT project files for a specific component installation.

```bash
composer create-project eveseat/seat /var/www/seat --no-dev
```

```bash
composer create-project eveseat/seat --no-dev
```

--------------------------------

### View Docker Compose startup output

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/docker

Example output showing the initialization of the SeAT Docker network and containers.

```text
root@seat:/opt/seat-docker# docker-compose up
Creating network "seat-docker_seat-network" with the default driver
Pulling mariadb (mariadb:10)...
10: Pulling from library/mariadb
3ff22d22a855: Already exists
e7cb79d19722: Already exists
323d0d660b6a: Already exists

...
```

--------------------------------

### Install SeAT 4.0 via Composer

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/bare_metal

Downloads and installs the SeAT 4.0 project files.

```bash
composer create-project eveseat/seat /var/www/seat "4.0.*" --no-dev --no-interaction
```

--------------------------------

### Install PHP 7.3 and Extensions

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/bare_metal

Installs PHP 7.3 and the required extensions for SeAT 4.0.

```bash
apt-get update
apt-get install libpng-dev libfreetype6-dev libjpeg-dev
apt-get install curl openssl zip php7.3-bz2 php7.3-cli php7.3-curl php7.3-dom php7.3-gd php7.3-gmp php7.3-intl php7.3-mbstring php7.3-mysql php7.3-opcache php7.3-redis php7.3-zip
```

--------------------------------

### Run Database Migrations and Setup

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/bare_metal

Publishes vendor assets, runs migrations, seeds the schedule, and updates the SDE.

```bash
sudo -H -u www-data bash -c 'php /var/www/seat/artisan vendor:publish --force --all'
sudo -H -u www-data bash -c 'php /var/www/seat/artisan migrate'
sudo -H -u www-data bash -c 'php /var/www/seat/artisan db:seed --class=Seat\\Console\\database\\seeds\\ScheduleSeeder'
sudo -H -u www-data bash -c 'php /var/www/seat/artisan eve:update:sde --force'
```

--------------------------------

### Install Supervisor

Source: https://eveseat.github.io/docs/installation/manual_installation

Installs the supervisor process manager for monitoring background jobs.

```bash
apt-get install supervisor
```

--------------------------------

### Install and configure the migrator package

Source: https://eveseat.github.io/docs/upgrading/from_seat_2_0

Commands to install the migrator package, register the service provider, and execute the migration wizard.

```bash
composer require warlof/seat-migrator
```

```bash
php artisan vendor:publish --force
```

```bash
php artisan migrate
```

```bash
php artisan seat:migrator:upgrade
```

--------------------------------

### Enable MariaDB Service

Source: https://eveseat.github.io/docs/installation/manual_installation

Configures the MariaDB service to start automatically on system boot.

```bash
systemctl enable mariadb.service
```

--------------------------------

### Run Automated Bootstrap Script

Source: https://eveseat.github.io/docs/installation/docker_installation

Executes the bootstrap script to check for and install Docker and Docker Compose, then starts the SeAT stack.

```bash
bash <(curl -fsSL https://raw.githubusercontent.com/eveseat/seat-docker/master/bootstrap.sh)
```

--------------------------------

### SeAT startup log output

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Example of the console output indicating that SeAT has successfully upgraded and is ready to serve requests.

```text
2023-06-02 09:49:33          ****////////////                                                   
2023-06-02 09:49:33      ***                 ///                                                   
2023-06-02 09:49:33   ***                      //                                                 
2023-06-02 09:49:33   **     **  //   ///        //                                                
2023-06-02 09:49:33  **      ***  ///             //      ////////@@@@@@@@@@@@@@@(/////@@@//////////
2023-06-02 09:49:33            **/   ///   /////////     *///&@@@@@@@&/////#@@@@%//%///#@@@@@(///@ 
2023-06-02 09:49:33  **     *** //////// /                @///////@@///@@@///@@@///@@///@@@@@(///@ 
2023-06-02 09:49:33  **      ***   ///   //       //      @@@@@////@/////////@@//////////@@@@(///@ 
2023-06-02 09:49:33   **         ///  //   /     //      *////////@@@///////@@///@@@@@@///@@@(///@ 
2023-06-02 09:49:33    ***         //// ///    ///                                              
2023-06-02 09:49:33       ***                ///                                              
2023-06-02 09:49:33          ****////////////
2023-06-02 09:49:33 
2023-06-02 09:49:33 
2023-06-02 09:49:33 SeAT is now ready to serve requests
2023-06-02 09:49:33 
2023-06-02 09:49:33 Open your browser and go to 'https://seat.domain.tld'
2023-06-02 09:49:33 Run 'docker compose exec front php artisan seat:admin:login' to get a temporary link in order to sign-in as built-in admin user account (or use bellow one)
2023-06-02 09:49:33 
2023-06-02 09:49:33 SeAT Admin Login URL Generator
2023-06-02 09:49:33 Checking if 'admin' is a super user
2023-06-02 09:49:33 Generating authentication token
2023-06-02 09:49:33 
2023-06-02 09:49:33 Your authentication URL is valid for 60 seconds.
2023-06-02 09:49:33 https://seat.domain.tld/auth/login/admin/aDvMAcd7GQPXFfhS3aIH9dh4opwcvASB
2023-06-02 09:49:33 
2023-06-02 09:49:33 
2023-06-02 09:49:33 AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.19.0.4. Set the 'ServerName' directive globally to suppress this message
2023-06-02 09:49:33 AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.19.0.4. Set the 'ServerName' directive globally to suppress this message
2023-06-02 09:49:33 [Fri Jun 02 07:49:33.524019 2023] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.56 (Debian) PHP/8.2.6 configured -- resuming normal operations
2023-06-02 09:49:33 [Fri Jun 02 07:49:33.524084 2023] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
```

--------------------------------

### Booting the SeAT stack with a custom reverse proxy

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Command to start the SeAT stack using the custom proxy configuration file.

```bash
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.proxy.yml up
```

--------------------------------

### Configure .env Database Settings

Source: https://eveseat.github.io/docs/installation/manual_installation

Example database configuration block for the .env file.

```ini
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=seat
DB_USERNAME=seat
DB_PASSWORD=s_p3rs3c3r3tp455w0rd # <-- this is the value you probably need to edit.
DB_DEBUG=false
```

--------------------------------

### Enable Redis Service

Source: https://eveseat.github.io/docs/installation/manual_installation

Configures the Redis service to start automatically on boot.

```bash
systemctl enable redis-server.service
```

--------------------------------

### Start SeAT 4 stack

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/docker

Starts the SeAT stack in the foreground to monitor the initial upgrade procedure.

```bash
docker-compose up
```

--------------------------------

### Install SeAT 2.0

Source: https://eveseat.github.io/docs/upgrading/from_seat_1_0

Download the new SeAT 2.0 code using Composer.

```bash
$ cd /var/www
$ composer create-project eveseat/seat seat --no-dev
Installing eveseat/seat (2.0.0)
  - Installing eveseat/seat (2.0.0)
    Loading from cache

Created project in seat
> php -r "file_exists('.env') || copy('.env.example', '.env');"
Loading composer repositories with package information
Updating dependencies

[ ... snip ... ]
```

--------------------------------

### Booting the SeAT stack with Traefik

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Command to start the SeAT stack using the Traefik configuration file.

```bash
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.traefik.yml up
```

--------------------------------

### Install PHP Packages

Source: https://eveseat.github.io/docs/installation/manual_installation

Installs required PHP 8.2 extensions and development libraries.

```bash
apt-get install libpng-dev libfreetype6-dev libjpeg-dev
apt-get install openssl zip php8.2-bz2 php8.2-cli php8.2-curl php8.2-dom php8.2-gd php8.2-gmp php8.2-intl php8.2-mbstring php8.2-mysql php8.2-opcache php8.2-redis php8.2-zip
```

--------------------------------

### Install PHP 8.2 and Extensions

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/bare_metal

Update system packages and install the required PHP 8.2 environment for SeAT 5.

```bash
apt-get update
apt-get install libpng-dev libfreetype6-dev libjpeg-dev
apt-get install openssl zip php8.2-fpm php8.2-bz2 php8.2-cli php8.2-curl php8.2-dom php8.2-gd php8.2-gmp php8.2-intl php8.2-mbstring php8.2-mysql php8.2-opcache php8.2-redis php8.2-zip
```

--------------------------------

### Run diagnostics on host installs

Source: https://eveseat.github.io/docs/troubleshooting

Execute the diagnostic command as the worker user, typically www-data, from the SeAT installation directory.

```bash
su -c 'php artisan seat:admin:diagnose' -s /bin/sh www-data
```

--------------------------------

### Install Docker Compose Plugin

Source: https://eveseat.github.io/docs/installation/docker_installation

Updates the package list and installs the Docker Compose plugin on Linux systems.

```bash
sudo apt-get update
sudo apt-get install docker-compose-plugin
```

--------------------------------

### SeAT Startup Log Output

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Example of the expected log output during the initial SeAT 5 startup process.

```text
seat_local-front-1  | mysqld is alive
seat_local-front-1  | PONG
seat_local-front-1  | starting web service
seat_local-front-1  | Processing plugins from SEAT_PLUGINS
seat_local-front-1  | Loading composer repositories with package information
seat_local-front-1  | Info from https://repo.packagist.org: #StandWithUkraine
seat_local-front-1  | Updating dependencies
```

--------------------------------

### Monitor database migrations

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/docker

Example output showing the migration process for SeAT services.

```text
... 
seat-web_1     | starting web service
seat-web_1     | Starting first run routines
seat-web_1     | Migrating: 2018_06_05_110000_drop_assets_from_outposts
seat-web_1     | Migrated:  2018_06_05_110000_drop_assets_from_outposts (0.02 seconds)
seat-web_1     | Migrating: 2019_02_09_110731_drop_type_from_notification_groups
seat-web_1     | Migrated:  2019_02_09_110731_drop_type_from_notification_groups (0.01 seconds)
seat-web_1     | Migrating: 2019_05_11_164831_add_permission_role_filter

...
```

--------------------------------

### Install specific plugin version via Composer

Source: https://eveseat.github.io/docs/community_packages

Use this command to install a specific version of a package via the command line.

```bash
sudo -H -u www-data bash -c 'composer require <package vendor>/<package-name>:<version-name>'
```

--------------------------------

### Example Admin Login Output

Source: https://eveseat.github.io/docs/admin_guides/admin_login

The expected output format after running the admin login command, providing a temporary authentication URL.

```text
SeAT Admin Login URL Generator
User 'admin' does not exist. It will be created.
Checking if 'admin' is a super user
Adding 'admin' to the Superuser role
Generating authentication token

Your authentication URL is valid for 60 seconds.
http://localhost/auth/login/admin/9G3sb8hjMvrbIJrIf10KKtIj1c8e9mL5
```

--------------------------------

### Create override.json for local development

Source: https://eveseat.github.io/docs/developer_guides/developer_installation

Example command to generate an override.json file for mapping a local web package source.

```bash
cat > packages/override.json << EOL
{
  "autoload": {
    "Seat\\Web\\": "packages/eveseat/web/src/"
  }
}
EOL
```

--------------------------------

### Configure SEAT_PLUGINS in .env

Source: https://eveseat.github.io/docs/community_packages

Define installed plugins in the .env file using a comma-separated list.

```text
# SeAT Plugins
# This is a list of the all of the third party plugins that you
# would like to install as part of SeAT. Package names should be
# comma seperated if multiple packages should be installed.

SEAT_PLUGINS=denngarr/seat-fitting,cryptaeve/seat-squad-sync
```

--------------------------------

### Stop the stack gracefully

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/docker

Example output when stopping the stack using Ctrl+C.

```text
^CGracefully stopping... (press Ctrl+C again to force)
Stopping seat-docker_seat-cron_1   ...
Stopping seat-docker_seat-worker_1 ...
Stopping seat-docker_seat-web_1    ...
Stopping seat-docker_traefik_1     ... done
Stopping seat-docker_redis_1       ...
```

--------------------------------

### Tail Application Logs on Host

Source: https://eveseat.github.io/docs/troubleshooting

Command to stream the current day's application logs in real-time on a host installation.

```bash
tail -f /var/www/seat/storage/logs/laravel-$(date +%Y-%m-%d).log
```

--------------------------------

### Rename Environment Configuration File

Source: https://eveseat.github.io/docs/installation/docker_installation

Renames the example environment file to the active .env file.

```bash
mv /opt/seat-docker/.env.example /opt/seat-docker/.env
```

```powershell
Rename-Item -Path "c:\seat-docker\.env.example" -NewName ".env"
```

--------------------------------

### Secure MariaDB Installation

Source: https://eveseat.github.io/docs/installation/manual_installation

Runs the security script to remove anonymous access and set the root password.

```bash
mariadb-secure-installation
```

--------------------------------

### Check PHP Version

Source: https://eveseat.github.io/docs/upgrading/from_seat_1_0

Verify the installed PHP version to ensure compatibility with SeAT 2.0 requirements.

```bash
$ php -v
PHP 7.0.14 (cli) (built: Dec  7 2016 10:25:25) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
```

--------------------------------

### Full supervisor configuration for SeAT 2.0

Source: https://eveseat.github.io/docs/upgrading/from_seat_1_0

A complete example of a supervisor program block for SeAT 2.0. Ensure the user and path values match your specific environment.

```ini
[program:seat]
command=/usr/bin/php /var/www/seat/artisan queue:work --queue=high,medium,low,default --tries 1 --timeout=86100
process_name = %(program_name)s-80%(process_num)02d
stdout_logfile = /var/log/seat-80%(process_num)02d.log
stdout_logfile_maxbytes=100MB
stdout_logfile_backups=10
numprocs=4
directory=/var/www/seat
stopwaitsecs=600
user=www-data
```

--------------------------------

### Upgrade docker-compose binary

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/docker

Downloads and installs the latest version of docker-compose to support variable expansion in .env files.

```bash
curl -L https://github.com/docker/compose/releases/download/1.26.2/docker-compose-$(uname -s)-$(uname -m) -o /usr/local/bin/docker-compose
chmod +x /usr/local/bin/docker-compose
```

--------------------------------

### Boot SeAT 5 in Detached Mode

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Commands to start the SeAT stack in the background using the -d flag.

```bash
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.traefik.yml up -d
```

```bash
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.proxy.yml up -d
```

--------------------------------

### Run diagnostics on Docker installs

Source: https://eveseat.github.io/docs/troubleshooting

Execute the diagnostic command within the running container from the directory containing the docker-compose.yml file.

```bash
docker-compose exec seat-web php artisan seat:admin:diagnose
```

```bash
docker compose exec front php artisan seat:admin:diagnose
```

--------------------------------

### Generate Admin Login URL for Bare Metal

Source: https://eveseat.github.io/docs/admin_guides/admin_login

Use this command for bare metal installations, ensuring it runs as the web server user.

```bash
sudo -H -u www-data bash -c 'php /var/www/seat/artisan seat:admin:login'
```

--------------------------------

### Create Working Directory

Source: https://eveseat.github.io/docs/installation/docker_installation

Sets up the base directory for SeAT Docker files.

```bash
mkdir -p /opt/seat-docker
cd /opt/seat-docker
```

```powershell
mkdir C:\seat-docker
cd C:\seat-docker
```

--------------------------------

### Configure ESI Environment Variables

Source: https://eveseat.github.io/docs/configuration/esi_configuration

Set these variables in the .env file of your SeAT installation using credentials from the EVE Online Developers portal.

```text
EVE_CLIENT_ID=null
EVE_CLIENT_SECRET=null
EVE_CALLBACK_URL=http://seat.test/auth/eve/callback
```

--------------------------------

### Update SeAT Docker Installation

Source: https://eveseat.github.io/docs/upgrading/general

Commands to pull the latest images, restart the stack, and clean up dangling images for various Docker configurations.

```bash
# Update to the latest dockerhub images
docker-compose pull

# Take the stack down
docker-compose down

# Bring the stack back up
docker-compose up -d

# Cleanup any dangling images
docker image prune -f
```

```bash
# Update to the latest dockerhub images
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.traefik.yml pull

# Take the stack down
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.traefik.yml down

# Bring the stack back up
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.traefik.yml up -d

# Cleanup any dangling images
docker image prune -f
```

```bash
# Update to the latest dockerhub images
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.proxy.yml pull

# Take the stack down
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.proxy.yml down

# Bring the stack back up
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.proxy.yml up -d

# Cleanup any dangling images
docker image prune -f
```

--------------------------------

### Bring application live

Source: https://eveseat.github.io/docs/community_packages

Exit maintenance mode to resume normal operations.

```bash
sudo -H -u www-data bash -c 'php artisan up'
```

--------------------------------

### Download new environment template

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Download the latest .env template to prepare for configuration updates.

```bash
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/.env.example -o .env
```

--------------------------------

### Rename SeAT directory

Source: https://eveseat.github.io/docs/upgrading/from_seat_2_0

Move the existing SeAT 2.0 installation to a new directory to prepare for the SeAT 3.0 installation.

```bash
mv /var/www/seat /var/www/seat2
```

--------------------------------

### Backup configuration files

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Create backups of the current environment and compose files.

```bash
cp .env .env.seat4.bak
```

```bash
cp docker-compose.yml docker-compose.yml.seat4.bak
```

--------------------------------

### Clear SeAT cache

Source: https://eveseat.github.io/docs/community_packages

Clear the application cache after installation to avoid conflicts.

```bash
sudo -H -u www-data bash -c 'php artisan seat:cache:clear'
```

--------------------------------

### Start Supervisor Service

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/bare_metal

Restarts the supervisor service to resume background jobs.

```bash
service supervisor start
```

--------------------------------

### Run Database Migrations

Source: https://eveseat.github.io/docs/installation/manual_installation

Executes database migrations to set up the SeAT schema.

```bash
sudo -H -u www-data bash -c 'php /var/www/seat/artisan migrate'
```

--------------------------------

### Deploy SeAT 5.0

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/bare_metal

Use Composer to create a new SeAT 5.0 project.

```bash
composer create-project eveseat/seat /var/www/seat "5.0" --no-dev --no-interaction
```

--------------------------------

### Rename SeAT Directory

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/bare_metal

Move the existing SeAT 4 directory to prepare for a fresh installation.

```bash
mv /var/www/seat /var/www/seat4
```

--------------------------------

### Initial Package File Structure

Source: https://eveseat.github.io/docs/developer_guides/package_development

The basic file layout for a new SeAT package including the required service provider.

```text
├── composer.json
└── src
    └── ApiServiceProvider.php
```

--------------------------------

### Require package via Composer

Source: https://eveseat.github.io/docs/community_packages

Install the desired package using the composer package manager.

```bash
sudo -H -u www-data bash -c 'composer require <package vendor>/<package-name>'
```

--------------------------------

### Put SeAT into maintenance mode

Source: https://eveseat.github.io/docs/community_packages

Use this command to prevent external requests during the installation process.

```bash
sudo -H -u www-data bash -c 'php artisan down'
```

--------------------------------

### Verify worker processing

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/docker

Example output confirming that the worker service is successfully processing jobs.

```text
seat-worker_1  | [2020-08-19 21:11:45][2] Processing: Seat\Eveapi\Jobs\Status\Status
seat-worker_1  | [2020-08-19 21:11:45][1] Processing: Seat\Eveapi\Jobs\Status\Esi
seat-worker_1  | [2020-08-19 21:11:46][2] Processed:  Seat\Eveapi\Jobs\Status\Status
seat-worker_1  | [2020-08-19 21:11:46][1] Processed:  Seat\Eveapi\Jobs\Status\Esi
```

--------------------------------

### Download new .env file

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/docker

Backs up the current .env file and downloads the updated template for SeAT 4.

```bash
mv .env .env.back
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/4.x/.env -o .env
```

--------------------------------

### Define package permissions

Source: https://eveseat.github.io/docs/developer_guides/package_development

Create a configuration file returning an array of permission definitions, where keys act as unique identifiers.

```php
[
    'sheet' => [
        'label'       => 'Grant access to Character Sheet',
        'description' => 'The Character Sheet contains basic information....',
        'division'    => 'financial',
    ],
    'intel' => [
        'label'       => 'web::permissions.character_intel_label',
        'description' => 'web::permissions.character_intel_description',
        'division'    => 'military',
    ],
    'planetary' => [
        'label'       => 'web::permissions.character_planetary_label',
        'description' => 'web::permissions.character_planetary_description',
        'division'    => 'industrial',
    ],
];
```

--------------------------------

### Configure Nginx for SeAT

Source: https://eveseat.github.io/docs/installation/manual_installation

Creates the Nginx site configuration file for serving the SeAT application.

```bash
cat > /etc/nginx/sites-available/seat << EOL
server {

    listen 80;
    listen [::]:80;

    # If you are hosting this instance on a domain, set that
    # name here.
    #server_name  seat.yourdomain.com;

    # SeAT public directory. This is the only directory that
    # should be exposed by the webserver. If one has to expose
    # the parent directory then things like the .env file will
    # be available for anyone to download.
    root /var/www/seat/public;

    index index.php;

    location / {
       try_files $uri $uri/ /index.php?$query_string;
    }

    # PHP-FPM configuration.
    location ~ \.php$ {
       try_files $uri /index.php =404;
       fastcgi_pass unix:/run/php/php8.2-fpm.sock;
       fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
       include fastcgi_params;
    }

    # Even though .htaccess rules mean nothing in the nginx
    # world, prevent those from being downloaded anyways.
    location ~ /\.ht {
       deny all;
    }

    # In case someone messes up, prevent .env files from
    # being downloaded as well.
    location ~ /\.env {
       deny all;
    }
}
EOL
```

--------------------------------

### Run SeAT Database Seeders

Source: https://eveseat.github.io/docs/upgrading/general

Commands to seed static data, specific to the SeAT version installed.

```bash
php artisan db:seed --class=Seat\Console\database\seeds\ScheduleSeeder
```

```bash
php artisan db:seed --class=Seat\Services\Database\Seeders\PluginDatabaseSeeder
```

--------------------------------

### Create ACME Configuration

Source: https://eveseat.github.io/docs/installation/docker_installation

Prepares the directory and file for Traefik ACME certificate storage.

```bash
mkdir acme
touch acme/acme.json
chmod 600 acme/acme.json
```

--------------------------------

### Locate Laravel log files

Source: https://eveseat.github.io/docs/about/reporting_bugs

Path to the Laravel log file relative to the SeAT installation directory.

```text
storage/logs/laravel-<todays-date>.log
```

--------------------------------

### Update .env Configuration File

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Backs up the current environment file and downloads the new SeAT 5 template.

```bash
mv .env .env.seat4.bak
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/.env.example -o .env
```

--------------------------------

### Access Docker Container Shell

Source: https://eveseat.github.io/docs/troubleshooting

Commands to enter a shell within the SeAT web container for Docker installations.

```bash
docker-compose exec seat-web sh
```

```bash
docker compose exec front sh
```

--------------------------------

### Download SeAT Source

Source: https://eveseat.github.io/docs/installation/manual_installation

Uses Composer to create the SeAT project in the current directory.

```bash
composer create-project eveseat/seat:5.0 --no-dev --no-interaction
```

--------------------------------

### Download new Docker configuration files

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Fetch the updated Docker compose and override files from the official repository.

```bash
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/docker-compose.yml -o docker-compose.yml`
```

```bash
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/docker-compose.mariadb.yml -o docker-compose.mariadb.yml
```

```bash
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/docker-compose.traefik.yml -o docker-compose.traefik.yml
```

```bash
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/docker-compose.proxy.yml -o docker-compose.proxy.yml
```

--------------------------------

### Remove old SeAT 2.0 directory

Source: https://eveseat.github.io/docs/upgrading/from_seat_2_0

Clean up the old SeAT 2.0 installation directory after a successful migration.

```bash
rm -R /var/www/seat2
```

--------------------------------

### Download SeAT Docker Template

Source: https://eveseat.github.io/docs/installation/docker_installation

Downloads the SeAT Docker template archive.

```bash
curl -fsSL https://github.com/eveseat/seat-docker/archive/refs/heads/master.zip -o seat-docker.zip
```

```powershell
Invoke-WebRequest -Uri https://github.com/eveseat/seat-docker/archive/refs/heads/master.zip -OutFile seat-docker.zip
```

--------------------------------

### Enable Nginx Site Configuration

Source: https://eveseat.github.io/docs/installation/manual_installation

Symlinks the configuration file to sites-enabled and removes the default configuration.

```bash
ln -s /etc/nginx/sites-available/seat /etc/nginx/sites-enabled/seat
rm /etc/nginx/sites-enabled/default
```

--------------------------------

### Configure PHP Repository

Source: https://eveseat.github.io/docs/installation/manual_installation

Adds the ondrej PHP PPA to the system sources list for different Ubuntu releases.

```bash
echo "deb http://ppa.launchpad.net/ondrej/php/ubuntu jammy main" >> /etc/apt/sources.list.d/php.list
echo "deb-src http://ppa.launchpad.net/ondrej/php/ubuntu jammy main" >> /etc/apt/sources.list.d/php.list
```

```bash
echo "deb http://ppa.launchpad.net/ondrej/php/ubuntu focal main" >> /etc/apt/sources.list.d/php.list
echo "deb-src http://ppa.launchpad.net/ondrej/php/ubuntu focal main" >> /etc/apt/sources.list.d/php.list
```

```bash
echo "deb http://ppa.launchpad.net/ondrej/php/ubuntu bionic main" >> /etc/apt/sources.list.d/php.list
echo "deb-src http://ppa.launchpad.net/ondrej/php/ubuntu bionic main" >> /etc/apt/sources.list.d/php.list
```

--------------------------------

### Download new docker-compose file

Source: https://eveseat.github.io/docs/upgrading/from_seat_3_0/docker

Backs up the existing docker-compose.yml and retrieves the SeAT 4 version.

```bash
mv docker-compose.yml docker-compose.yml.back
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/4.x/docker-compose.yml -o docker-compose.yml
```

--------------------------------

### Blade Installation Maintenance and Updates

Source: https://eveseat.github.io/docs/upgrading/general

Standard commands for putting the application into maintenance mode, updating dependencies, and running migrations.

```bash
php artisan down
```

```bash
composer self-update
```

```bash
composer update --no-dev
```

```bash
php artisan vendor:publish --force --all
```

```bash
php artisan migrate
```

```bash
php artisan up
```

```bash
php artisan cache:clear
```

--------------------------------

### Configure Database Environment Variables

Source: https://eveseat.github.io/docs/upgrading/from_seat_1_0

Required database connection keys to be populated in the .env file.

```text
DB_HOST=
DB_PORT=
DB_DATABASE=
DB_USERNAME=
DB_PASSWORD=
```

--------------------------------

### Authenticate with SeAT API using cURL

Source: https://eveseat.github.io/docs/developer_guides/seat_api

Perform a GET request to the API using an authentication token in the X-Token header.

```bash
$ curl -X GET -H "X-Token:123456" -H "Accept: application/json" http://localhost:8000/api/v1/key
*   Trying ::1...
* Connected to localhost (::1) port 8000 (#0)
> GET /api/v1/key HTTP/1.1
> Host: localhost:8000
> User-Agent: curl/7.43.0
> Accept: application/json
> X-Token:123456
>
< HTTP/1.1 200 OK
< Host: localhost:8000
< Connection: close
< Cache-Control: no-cache
< Date: Sat, 28 Nov 2015 22:27:12 GMT
< Content-Type: application/json
```

--------------------------------

### Run database migrations

Source: https://eveseat.github.io/docs/community_packages

Update the database schema to support the new package.

```bash
sudo -H -u www-data bash -c 'php artisan migrate'
```

--------------------------------

### Tail ESI Logs on Host

Source: https://eveseat.github.io/docs/troubleshooting

Command to stream the current day's ESI request logs in real-time on a host installation.

```bash
tail -f /var/www/seat/storage/logs/eseye-$(date +%Y-%m-%d).log
```

--------------------------------

### Restart stack with proxy configuration

Source: https://eveseat.github.io/docs/installation/docker_installation

Apply configuration changes by restarting the stack using the base, MariaDB, and proxy compose files.

```bash
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.proxy.yml up -d
```

--------------------------------

### Download SeAT 5 Docker Compose Files

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Backs up the existing docker-compose file and downloads the updated configuration files for SeAT 5.

```bash
mv docker-compose.yml docker-compose.yml.seat4.bak
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/docker-compose.yml -o docker-compose.yml
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/docker-compose.mariadb.yml -o docker-compose.mariadb.yml
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/docker-compose.traefik.yml -o docker-compose.traefik.yml
curl -L https://raw.githubusercontent.com/eveseat/seat-docker/master/docker-compose.proxy.yml -o docker-compose.proxy.yml
```

--------------------------------

### Enable Supervisor Service

Source: https://eveseat.github.io/docs/installation/manual_installation

Reloads and enables the supervisor service to apply the new configuration.

```bash
systemctl enable supervisor.service
```

--------------------------------

### Run Database Migrations

Source: https://eveseat.github.io/docs/upgrading/from_seat_1_0

Execute database migrations to update the schema to version 2.0.

```bash
$ cd /var/www/seat
$ php artisan migrate
```

--------------------------------

### Customize Login Page Layout

Source: https://eveseat.github.io/docs/styling

Example CSS for the login page using custom-layout-mini.css. Valid corporation or alliance IDs can be used for the logo section.

```css
/**
 * SeAT login page layout
 */
@media all {
    html, body {
        height: auto;
    }

    .login-page, .register.body {
        color: rgb(255,255,255);
        background-image: url(https://web.ccpgamescdn.com/aws/eveonline/sso/background.jpg);
        background-position: center center;
        background-repeat: no-repeat;
        background-size: cover;
        background-attachment: fixed;
    }

    .login-box, .register-box {
        width: 360px;
        margin: 0;
        position: absolute;
        top: 50%;
        left: 50%;
        background: rgba(48,48,48,.8);
        transform: translate(-50%, -50%);
        border: 5px solid #ecf0f1;
        border-radius: 40px;
        box-shadow: 0 1px 1px rgba(0,0,0,0.05);
    }

    .login-logo, .register-logo {
        font-size: 35px;
        text-align: center;
        margin-bottom: 25px;
        font-weight: 300;
        content: url(https://images.evetech.net/corporations/98482334/logo?size=128);
        margin-top: 50px;
    }

    .login-logo::before, .register-logo::before {
        display: block;
        width: 128px;
        height:128px;
        margin: 0 auto;
        border-radius: 50%;
        margin-bottom: 50px;
    }

    .login-box-body, .register-box-body {
        background: transparent;
        padding: 20px;
        border-top: 0;
        color: inherit;
    }
}
```

--------------------------------

### Migrate Database

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/bare_metal

Run artisan commands to publish assets, migrate the database, seed plugins, and update the SDE.

```bash
sudo -H -u www-data bash -c 'php /var/www/seat/artisan vendor:publish --force --all'
sudo -H -u www-data bash -c 'php /var/www/seat/artisan migrate'
sudo -H -u www-data bash -c 'php /var/www/seat/artisan db:seed --class=Seat\\Services\\Database\\Seeders\\PluginDatabaseSeeder'
sudo -H -u www-data bash -c 'php /var/www/seat/artisan eve:update:sde --force'
```

--------------------------------

### Access MariaDB Client

Source: https://eveseat.github.io/docs/installation/manual_installation

Opens the MariaDB command-line interface as the root user.

```bash
mariadb -uroot -p
```

--------------------------------

### SeAT Successful Startup Log Output

Source: https://eveseat.github.io/docs/upgrading/from_seat_4_0/docker

Log output indicating that the Apache web server has successfully resumed operations.

```text
seat_local-front-1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.25.0.5. Set the 'ServerName' directive globally to suppress this message
seat_local-front-1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.25.0.5. Set the 'ServerName' directive globally to suppress this message
seat_local-front-1  | [Sun May 21 21:10:46.869842 2023] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.56 (Debian) PHP/8.1.19 configured -- resuming normal operations
seat_local-front-1  | [Sun May 21 21:10:46.869944 2023] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
```

--------------------------------

### Add GPG Signing Key

Source: https://eveseat.github.io/docs/installation/manual_installation

Downloads and adds the repository GPG key to the system keychain.

```bash
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 4F4EA0AAE5267A6C
```

--------------------------------

### Configuring SeAT Plugins

Source: https://eveseat.github.io/docs/admin_guides/docker_admin

Add plugin package names to the SEAT_PLUGINS variable in the .env file to enable them upon container restart.

```text
# SeAT Plugins
# This is a list of the all of the third party plugins that you
# would like to install as part of SeAT. Package names should be
```

--------------------------------

### Configure Supervisor for Horizon

Source: https://eveseat.github.io/docs/installation/manual_installation

Creates a configuration file for Supervisor to manage the SeAT Horizon process.

```bash
cat > /etc/supervisor/conf.d/seat.conf << EOL
[program:seat]
command=/usr/bin/php /var/www/seat/artisan horizon
process_name = %(program_name)s-80%(process_num)02d
stdout_logfile = /var/log/seat-80%(process_num)02d.log
stdout_logfile_maxbytes=100MB
stdout_logfile_backups=10
numprocs=1
directory=/var/www/seat
stopwaitsecs=600
user=www-data
EOL
```

--------------------------------

### Generate Application Key

Source: https://eveseat.github.io/docs/installation/docker_installation

Generates and sets a unique application key in the .env file.

```bash
sed -i -- 's/APP_KEY=insecure/APP_KEY='$(head /dev/urandom | tr -dc A-Za-z0-9 | head -c32 ; echo '')'/g' .env
```

```powershell
$appkey = (-join ((65..90) + (97..122) | Get-Random -Count 32 | % {[char]$_})); (Get-Content .env -Raw) -replace "APP_KEY=insecure", "APP_KEY=$appkey" | Set-Content .env
```

--------------------------------

### Publish Assets and Migrations

Source: https://eveseat.github.io/docs/installation/manual_installation

Publishes vendor assets and database migrations using the www-data user.

```bash
sudo -H -u www-data bash -c 'php /var/www/seat/artisan vendor:publish --force --all'
```

--------------------------------

### Run SDE Updater with Local Configuration

Source: https://eveseat.github.io/docs/configuration/sde_overload

Execute the artisan command with the --local flag to apply the version specified in the .env file.

```bash
php artisan eve:update:sde --local
```

--------------------------------

### Register package migrations

Source: https://eveseat.github.io/docs/developer_guides/package_development

Load database migrations from the package directory within the service provider.

```php
$this->loadMigrationsFrom(__DIR__ . '/database/migrations/');
```

--------------------------------

### Restart SeAT 5.x Docker Containers (Proxy)

Source: https://eveseat.github.io/docs/configuration/esi_configuration

Use these commands to rebuild the SeAT 5.x application using the proxy configuration.

```bash
docker compose down
docker compose -f docker-compose.yml -f docker-compose.mariadb.yml -f docker-compose.proxy.yml up -d
```
Tokens:
Raw