[pgpool-general: 6926] Re: latest PgpoolAdmin problem

Bo Peng pengbo at sraoss.co.jp
Tue Mar 10 12:09:16 JST 2020


On Fri, 06 Mar 2020 08:39:43 +0100
Radosław Szczygieł <radoslaw.szczygiel at interia.pl> wrote:

> Hi Bo,I was able to run pgpoolAdmin on php version 7.2 but in addition I had to install 
> php-posix (on version 5.6 there was the same error with the hash_equals function and
> according to the documentation in this version this function is there ... strange).

The documentation is old. I will update the documentation.

> Unfortunately, after logging in with postgres user, 
> I have the error "superuser: unknown (Connection error)", but the httpd logs are clean. 
> On the old version 3.7 there was "superuser: yes" and everything was ok.I have configured
> everything in pcp.conf, added correct permissions

I think the DB connetion may fail.
To check if the login user is a superuser the following command is executed.

Can you execute the command below and obtain the result?

# psql -h <pgpoolAdmin_host> -p 9999 -U <login_user_name> template1 -c "SELECT usesuper FROM pg_user WHERE usename = '<login_user_name>'"
(input login user password)

> &gt; 
> &gt; I found the following error.
> &gt; 
> &gt; ====
> &gt; [Wed Mar 04 10:05:56.060383 2020] [:error] [pid 9565] [client] 
> &gt; PHP Fatal error:&nbsp; Call to undefined function hash_equals() in /var/www/html/pgpoolAdmin/login.php on line 85, referer: 
> &gt;
> &gt; ====
> &gt; 
> &gt; Your php version (php-5.4.16) doesn't support hash_equals function.
> &gt; Your php version must be higher than PHP 5.6 or 7.0.
> &gt; 
> &gt; https://www.php.net/manual/en/function.hash-equals.php
> &gt; 
> &gt; On Wed, 04 Mar 2020 10:48:12 +0100
> &gt; Radosław Szczygieł  wrote:
> &gt; 
> &gt; &gt; rpm -qa | grep phpphp-pdo-5.4.16-46.el7.x86_64php-cli-5.4.16-46.el7.x86_64php-common-5.4.16-46.el7.x86_64php-pgsql-5.4.16-46.el7.x86_64php-5.4.16-46.el7.x86_64php-process-5.4.16-46.el7.x86_64httpd log when I try to login to pgpoolAdmin[Wed Mar 04 10:05:45.201459 2020] [:error] [pid 9562] [client] PHP Warning:&nbsp; date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /var/www/html/pgpoolAdmin/templates_c/3a4f6f0d327fc7bc3ea86f63906a1bf934ca50c7.file.footer.tpl.php on line 29[Wed Mar 04 10:05:56.060383 2020] [:error] [pid 9565] [client] PHP Fatal error:&nbsp; Call to undefined function hash_equa
 ls() in /v
> &gt;  ar/www/html/pgpoolAdmin/login.php on line 85, referer: Szczygiel--PozdrawiamRadosław SzczygiełTemat: Re: [pgpool-general: 6893] latest PgpoolAdmin problemData: 2020-03-04 3:50Nadawca: "Bo Peng" Adresat: "Radosław
> &gt; 
> &gt; -- 
> &gt; Bo Peng 
> &gt; SRA OSS, Inc. Japan
> &gt; 

Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan

More information about the pgpool-general mailing list