othyn

[LINUX] Factorio Headless Server Guide

So, with credit to the Factorio wiki and cbednarski's helpful gist, I managed to eventually setup a Factorio headless server. Although, I thought the process could be nailed down/simplified to be a bit more 'tutorialised' and also to document how I got it all working for my future records.

The specific distro/version I'm using for this guide being Ubuntu Server 16.04.1 LTS. Although, that shouldn't matter, as long as your distro supports systemd (just for this guide, not a Factorio headless requirement, although most distros use it as standard now). The version of Factorio I shall be using is 0.14.20, although should work for any version of Factorio 0.14.12 and higher.

Just a note to newcomers: If there are any issues with the installation steps, people in the comments are doing a good job

othyn

MySQL Database User GRANT permissions for Laravel

For security reasons, you should probably grant select, delete, update and insert to your app user in production.

Have another user who can do alter, create, drop and index when running migrations.

If you run seeders in production, also grant select, insert and references to the migration user.

Yeah, 2 users, migrations are not always run in production everyday and this keeps more secure your database.

othyn

#!/bin/bash
USAGE="\n\x1b[31mUsage:\x1b[0m extract_table_from_mysql_dump.sh my_table /path/to/dump.sql\n\x1b[32mOptional 3rd parameter:\x1b[0m /path/to/export/to\nThe export filename will default to extracted_{my_table}.sql\n"

if [[ -z "$1" ]] ; then
    printf "$USAGE"
    exit 1
fi
# Check the table name was provided

if [[ -z "$2" ]] ; then

othyn

#!/bin/bash

# Globals
TIMESTAMP=$(date +%s)
MOUNT_DIR="/mnt"
BASE_MOUNT_DIR="$MOUNT_DIR/image_$TIMESTAMP"
MOUNT_IMAGE=""

# Usage declaration
display_usage() {

othyn

<?php

/**
 * A quick way, with a bit of overhead, to get nice tabular output
 * from a PHP CLI app.
 *
 * Sometimes I find myself just requiring very quick and dirty
 * tabular output and find this to be the path of least resistance.
 *
 * This method utilises Symfony's Console's Table and BufferedOutput

othyn

#!/bin/sh
set -e

FIRST_LINE=$(head -n 1 "${1}")

# As the scripts can be either JS or shell, determine how to exec!
if [ "${FIRST_LINE}" = "#!/bin/sh" ] || [ "${FIRST_LINE}" = "#!/bin/bash" ]; then
    eval "./$@"
else
    # https://github.com/nodejs/docker-node/blob/master/docker-entrypoint.sh

othyn

<?php

/*
 * app/Http/Controllers/Auth/ChangePasswordController.php
 *
 * Made via the command:
 * $ php artisan make:controller Auth/ChangePasswordController -r
 *
 * This is the custom controller that will do all the heavy lifting for
 * changing the users password.

othyn

<?php

namespace App\Enums;

use BenSampo\Enum\Enum;

/**
 * @method static static Emergency()
 * @method static static Alert()
 * @method static static Critical()

othyn

#!/bin/bash

# System: Darwin x86_64 19.6.0 (macOS 10.15.6 19G2021)
# Author: Othyn (https://github.com/othyn)
# Source: https://gist.github.com/othyn/29b82e39eb8cdd98adf1be77cbb62700
# Dependencies: pv, wimlib
# Licence: MIT

DEFAULT="\x1b[0m"
RED="\x1b[31m"

othyn

Package (in Alphabetical Order)	Description