Poweradmin : Web UI untuk PowerDNS server

• PowerDNS Server
• Saparate Machine untuk poweradmin (Optional)

apt update

apt install -y nginx php php-fpm php-pgsql php-pdo-pgsql php-gettext php-mbstring php-xml php-curl php-intl php-session wget unzip

Cek versi latest di: https://github.com/poweradmin/poweradmin/releases

cd /tmp
wget https://github.com/poweradmin/poweradmin/archive/refs/tags/v4.1.1.tar.gz

tar -xzvf v4.1.1.tar.gz
sudo mv poweradmin-4.1.1 /var/www/poweradmin
sudo chown -R www-data:www-data /var/www/poweradmin
sudo chmod -R 755 /var/www/poweradmin

sudo -u postgres psql

CREATE USER poweradmin_user WITH PASSWORD 'StrongPassword123!';
GRANT ALL PRIVILEGES ON DATABASE powerdns TO poweradmin_user;
\c powerdns
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO poweradmin_user;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO poweradmin_user;
GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public TO poweradmin_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO poweradmin_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO poweradmin_user;
\q