#!/usr/bin/env bash
set -e
apt update
apt install -y freeradius freeradius-mysql mariadb-server php-cli php-curl php-mysql
mysql -e "CREATE DATABASE IF NOT EXISTS radius; CREATE USER IF NOT EXISTS 'radius_user'@'localhost' IDENTIFIED BY 'radius_pass'; GRANT ALL PRIVILEGES ON radius.* TO 'radius_user'@'localhost'; FLUSH PRIVILEGES;"
echo "Import freeradius_schema.sql: mysql radius < freeradius_schema.sql"
echo "Enable sql module: ln -s /etc/freeradius/3.0/mods-available/sql /etc/freeradius/3.0/mods-enabled/sql"
echo "Edit /etc/freeradius/3.0/mods-enabled/sql with DB credentials, then restart freeradius."