Make Bottius Installer

[Montori]

Installer should:

• set up a new Linux user (for security reasons)
• Check the Bot out from github (always master Branch)
• install npm and nodejs 14
• Install the npm stuff (npm ci)
• Install the PostgreSQL database
• Let the user decide if the database connection should be reachable over the public internet (I guess you need to unlock ports and edit a connection file in the postgres files)
• Create a new database
• Create an ormconfig.json (its where the connection data is stored, located in Bottius root)
• Create a botconfig.json and let the user set it up (located in source/)
• be able to start Bottius (or add a service so that a user can control it without the installer)
• only be supported on 64bit architectures
• compile TypeScript files in the end

[Montori]

ormconfig.json should look like this

{
    "type": "postgres",
    "url": "postgres://!DB_USER!:!DB_PASSWORD!@!DB_HOST!:!DB_PORT!/!DB_NAME!",
    "entities": ["out/Entities/Persistent/*.js"],
    "migrations": ["out/Migration/*.js"],
    "cli": {
        "migrationsDir": "source/Migration"
    }
} 

All fields that are marked with !SOMETHING! should be automatically set by the installer

[Montori]

botconfig.json should look like this

{
  "token": "!BOT_TOKEN!",
  "prefix": "!PREFIX!",
  "masters": ["275355515003863040", "182896862477549577", "!OWNER_DISCORDID!"],
  "activity": "",
  "activityStatus": ""
}

Again, all fields marked with !SOMETHING! should be set by the installer. If the installing user did not set an discord ID then it shouldnt be set in the botconfig either.

[Montori]

@StrangeRanger I created an issue for you so you dont need to scroll all the way up on discord all the time. If new details occur we can add them here as well. If you want to make your own issues you can use the new Topic: Installer label for it

[Montori]

You need to add a line in pg_hba.conf at the host section

host all all 0.0.0.0/0 md5

and you need to edit the

listen_adress in the postgresql.conf to listen_adress='*'

The actions above are just mandatory if a user chooses to make the db open to the internet

if a user chooses to make it open for the internet a password must be mandatory