Installation / Database

While JAS can operate without a "proper" database it isn't recommended since its internal database is relatively slow. Therefore installing MariaDB (or MySQL if you prefer) or PostgreSQL is highly recommended.

MariaDB (aka MySQL)

Maria DB version 10 or MySQL version 5.1 and up should do you nicely. There are no required configuration options however it may be wise to review the following configurations options:

Options

my.cnf

[mysqld]
ft_min_word_len = 3 ; enables full text index search of at least 3 characters

key_buffer_size = 256M
table_open_cache = 256
query_cache_size = 64M
max_allowed_packet = 16M

MySQL 5.7 and up

As of MySQL 5.7 the NO_ZERO_DATE sql_mode setting is enabled by default. As JAS needs zero dates this setting will need to be disabled:

The blunt way

SET GLOBAL sql_mode = '';

Alternatively you can retrieve all current settings, remove the NO_ZERO_DATE from the list and set the remainder:

Get sql_mode

SELECT @@GLOBAL.sql_mode;

PostgresSQL

As of JAS 1.1 PostgreSQL is supported (although with some limitations for now). PostgreSQL 9.5 is supported so it's safe to assume any later version should work. JAS requires network support and password login so you'll need to set this up accordingly:

Network support

postgresql.conf

listen_addresses = 'localhost'

Password login

pg_hba.conf

host all all 127.0.0.1/32 md5
host all all ::1/128 md5

Limitations

PostgreSQL support is still in its early stages so expect issues:

Full text search isn't supported just yet
Aggregation hasn't been tested but is expected to fail
Database info works but expect it to be slow and it doesn't support deletions
Don't use the "API database info" call to check for new updates, it'll probably grind your system to a halt.
Database owner needs to be the JAS user in order to update database changes
This means JAS also has things like "drop table" privileges which obviously isn't preferable.