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

sudo nano /etc/nginx/sites-available/poweradmin

server {
    listen 80;
    server_name _;  # your-domain.com or server IP
 
    root /var/www/poweradmin;
    index index.php index.html;
 
    access_log /var/log/nginx/poweradmin_access.log;
    error_log  /var/log/nginx/poweradmin_error.log;
 
    location / {
        try_files $uri $uri/ /index.php?$args;
    }
 
    location ~ \.php$ {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/run/php/php8.2-fpm.sock;  # adjust PHP version
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }
 
    location ~ /\.ht {
        deny all;
    }
}