Installation

Linux (Windows and Mac available on request. Contact us.)

curl -fsSL https://qbc.com/asql/install | sudo bash

The script picks the release built for your system, checks its SHA-256 and its QBC signature, installs it under /opt/aios, and starts the aios-compute service. A first install gets a standalone server on 127.0.0.1:3307 with a login of its own:

mysql -h 127.0.0.1 -P 3307 -u asql -p"$(sudo cat /opt/aios/mysql.pass)"

Running it again upgrades the binaries and leaves /etc/aios/asql.conf alone.

Option	Effect
`--dry-run`	print every change, make none
`--version <build>`	install that build instead of the newest
`--no-start`	install and enable the service, but do not start it
`--no-service`	files, user and config only (containers; also the default where there is no systemd)

Pass options after bash -s --, for example curl -fsSL https://qbc.com/asql/install | sudo bash -s -- --dry-run.

Requirements

Requirement
CPU	x86-64
System	glibc 2.17 or newer; systemd for the service
Ports	3307 (MySQL), 7311 (JSON RPC); both on 127.0.0.1 until you change them
Memory	enough to hold your data compressed, plus room for queries

Manual install

Download the archive for your system from the downloads page, then:

sha256sum aios-asql-*.tar.gz            # compare with the published SHA-256
tar xzf aios-asql-*.tar.gz
cd aios-asql-*/
sudo ./install-asql.sh --dry-run         # see what it will do
sudo ./install-asql.sh

The archive's own installer creates the aios user, /opt/aios, /etc/aios/asql.conf (if missing) and the aios-compute unit, keeps the previous binary, and rolls back if the service does not start.

Upgrade

Run the install command again. It keeps your configuration, password and databases, backs up the old program (/opt/aios/bin/aios.bak-<date>) and service file, restarts ASQL, and puts the old version back if the new one does not start.

Uninstall

Back up first if you want your data (see Back up and restore). Then:

sudo systemctl disable --now aios-compute
sudo rm -f /etc/systemd/system/aios-compute.service
sudo systemctl daemon-reload
sudo rm -rf /opt/aios /etc/aios
sudo userdel aios
sudo groupdel aios

The rm -rf deletes your databases.

Trial and license

ASQL runs for 30 days from its first start. After that, aios and aios-webserver need a license file from QBC.

/opt/aios/bin/aios license status
sudo /opt/aios/bin/aios license install customer.license
sudo systemctl restart aios-compute

The license is looked for in $AIOS_LICENSE, <root>/license, /etc/aios/license and ~/.aios/license, in that order. It is a signed text file; it needs no account and no network.