How to configure webmin and pgadmin ?

Introduction

Webmin and pgAdmin are powerful web-based administration tools used for managing servers and databases respectively. They provide user-friendly interfaces for system administrators and database managers to configure, monitor, and administer their systems and databases efficiently. This guide will walk you through the installation process of both Webmin and pgAdmin on a CentOS/RHEL-based system.

Prerequisites

Before proceeding with the installation, ensure that you have:

1. Access to a CentOS/RHEL-based server: You should have access to a server running CentOS or RHEL.

2. Root access: You need to have root or sudo privileges to install packages and configure system settings.

3. Basic understanding of Linux commands: Familiarity with basic Linux commands will be helpful in following the installation steps.

Webmin Installation

Step 1: Download the RPM version of Webmin:

  # wget http://prdownloads.sourceforge.net/webadmin/webmin-1.979-1.noarch.rpm

Step 2: Install optional dependencies:

  # dnf install perl perl-Net-SSLeay openssl perl-IO-Tty perl-Encode-Detect

Step 3: Run the rpm command to install Webmin:

  # rpm -U webmin-1.979-1.noarch.rpm

Step 4: Allow port in Firewall:

  # firewall-cmd --zone=public --add-port=10000/tcp

Now you can access Webmin at the URL https://45.56.82.195:10000/ or https://research.kub-dataverse.dk:10000.
Use the server root username and password to log in to the Webmin portal.

pgAdmin Installation

Step 1: Enable the EPEL and pgAdmin Yum repositories:

  # dnf install epel-release # dnf install -y https://ftp.postgresql.org/pub/pgadmin/pgadmin4/yum/pgadmin4-redhat-repo-1-1.noarch.rpm

Step 2: Remove PostgreSQL official yum repositories:

  # dnf remove -y pgdg-redhat-repo

Step 3: Build cache and install pgAdmin:

  # dnf makecache # yum install pgadmin4

Step 4: Start and enable the httpd service:

  # systemctl start httpd # systemctl enable httpd # systemctl status httpd

Step 5: Configure pgAdmin 4:

  # /usr/pgadmin4/bin/setup-web.sh

Follow the prompts to set up login mail ID and password. Restart Apache when prompted.

You can access the pgAdmin web interface at http://research.kub-dataverse.dk/pgadmin4/.

Conclusion

In conclusion, Webmin and pgAdmin are valuable tools for server and database administration on CentOS/RHEL-based systems. By following the steps outlined in this guide, you should be able to successfully install and configure both Webmin and pgAdmin, allowing you to efficiently manage your server and database environments through their intuitive web interfaces.