Need help?

Our experts have had an average response time of 11.7 minutes in August 2021 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

“Login disallowed for security reasons” phppgadmin error – How we fix it

by | May 20, 2021

When trying to access phpPgAdmin users often see the error “Login disallowed for security reasons”.

As a part of our Server Management Services, we help our customers to fix requests related phpPgAdmin regularly.

Let us today discuss the possible reasons and fixes for this error.


 

What causes the phpPgAdmin error “Login disallowed for security reasons”?

Recently we received a request that the customer is receiving the error as shown below while accessing PostgreSQL via phpPgAdmin.

login disallowed for security reasons phppgadmin

The users were getting redirected to the login page with the above message. This generally happens when we enable extra login security in the phpPgAdmin configuration file. Let us now discuss how our Support Engineers fix this error.
 

How to fix the phpPgAdmin error “Login disallowed for security reasons”?

As we saw earlier, this error happens mainly when we enable the extra login security. Thus to fix this error, our Support Engineers turn this parameter to false in the configuration file.

First, we need to open the config.inc.php on /etc/phppgadmin with any text editor. Then, change the $conf[‘extra_login_security’] = true; to false.

If extra login security is true, it denies then logins via phpPgAdmin with no password or certain usernames (pgsql, Postgres, root, administrator). Thus, by default the value is true.

Now that we have changed the extra login security settings, we need to restart the PostgreSQL using the command below for the changes to take effect.

sudo systemctl restart postgresql

Finally, we also need to restart the apache service with the command below

sudo systemctl restart apache2

 

Plesk Servers

On a Plesk for Linux server, accessing the PostgreSQL server from Tools & Settings > Database Servers fails with the same error.

To fix the error we need to open the file /usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/conf/config.inc.php. Then, we need to disable the option $conf['extra_login_security'] by turning it to false.

Finally, we need to restart the PostgreSQL service with the command below:

service postgresql restart

[Need any further assistance with PostgreSQL errors? – We’re available 24*7]
 

Conclusion

In short, the “Login disallowed for security reasons” error can trigger when extra login security is enabled in the phpPgAdmin configuration file. Today, we saw how our Support Engineers fix this error.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

SEE SERVER ADMIN PLANS

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF