Can't install phpPgadmin script

I am getting FIDO2 WebAuthen implemented on website logins and as part of it I needed to activate PostgreSQL Database Server.

I went to Virtualmin -> System Settings -> Features & Plugins -> enabled PostgreSQL Database And also Edited Virtual Server and enabled "PostgreSQL Database Enabled?" feature

So far it all seem to have gone fine. I can see PostgreSQL service and it is running and active.

But when I went to Install Scripts for that virtual server and tried to install phpPgAdmin then it is giving this error as below. "This script cannot be installed, as this virtual server does not meet its requirements : phpPgAdmin requires a PostgreSQL database"

So I thought to just download phpPgadmin and unpack it to public_html folder (which is how my phpmyadmin is running) and tried to open the page. But phpPgadmin is not loading and it gives this error as below. "Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option."

What I understood is that the virtual server is not seem to have configured for PostgreSQL database server. Virtual Server already has MariaDB Database Server already running. And when I go to Databases of the virtual server then I only see MariaDB databases.

After Virtualmin configurations I made shouldn't I be able to start using the PostgreSQL databases under this virtual server for which that feature is also enabled?

Status: 
Closed (works as designed)
Virtualmin version: 
6.16
Webmin version: 
1.973

Comments

Ilia's picture
Submitted by Ilia on Thu, 05/06/2021 - 16:22

Hi,

Thanks for contacting us.

I am getting FIDO2 WebAuthen implemented on website logins and as part of it I needed to activate PostgreSQL Database Server.

This is not clear. Can you elaborate, why do you need to use PostgreSQL server over MariaDB?

"This script cannot be installed, as this virtual server does not meet its requirements : phpPgAdmin requires a PostgreSQL database"

You would need to install PostgreSQL client and server using package manager first. Later, you can re-run installation wizard from Virtualmin / System Settings, to enable PostgreSQL. Eventually, you can enable PostgreSQL database as a feature for given virtual server using virtual-server.name - Edit Virtual Server page.

Thanks Ilia for quick response.

1) That is required for Yubikey FIDO2 WebAuthn implementation as I was told by the developer.

2) Thanks for quick comments. I will come back with how this goes. Hopefully this fixes it.

Regards,

Hi again,

I checked in package manager (Webmin -> System -> Software Packages -> Installed Packages) and found following already installed. - libpq 12.4-1.el8_2 - postgresql 10.15-1.module_el8.3.0+619+dbc95fbc - postgresql-server 10.15-1.module_el8.3.0+619+dbc95fbc

So I went ahead and Re-Run the Install Wizard and with YES to PostgreSQL Database Server along with MariaDB. Once wizard completed waited for 10minutes and restarted the server.

Then tried again. But this didn't change any behaviour.

Hi again, I could fix this one below by modifying some file within the phpPgAdmin folder. "So I thought to just download phpPgadmin and unpack it to public_html folder (which is how my phpmyadmin is running) and tried to open the page. But phpPgadmin is not loading and it gives this error as below. "Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option."

But I am still not able to install phpPgAdmin through Virtualmin -> Install Scripts. It keeps giving same error like before. "This script cannot be installed, as this virtual server does not meet its requirements : phpPgAdmin requires a PostgreSQL database."

It is strange error because PostgreSQL database I am able to access through phpPgAdmin now and also PostgreSQL Database feature is also enabled in this virtual server.

How can I fix this error? Does the error indicate that PostgreSQL Database is not seen attached with the virtual server?

Ilia's picture
Submitted by Ilia on Fri, 05/07/2021 - 04:15

"This script cannot be installed, as this virtual server does not meet its requirements : phpPgAdmin requires a PostgreSQL database." How can I fix this error? Does the error indicate that PostgreSQL Database is not seen attached with the virtual server?

Have you enabled PostgreSQL as a feature for the given virtual server on Edit Virtual Server page?

Yes that was done.

By the way developer removed dependency on PostgreSQL and implemented HOTP already successfully soon after removing that dependency. So all good for now. Developer will continue with MySQL for FIDO2 WebAuthn implementation today. So this ticket I am closing now.

Thank you very much for your kind support.