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

[Radosław Szczygieł]

I dont have problem with this commend: psql -h 172.31.74.164 -p 9999 -U pgpool template1 -c "SELECT usesuper FROM pg_user WHERE usename = 'pgpool'"Password for user pgpool: usesuper---------- t(1 row)the same problem in pgpoolAdminsuperuser: unknown (Connection error)
                               RegardsRadoslaw Szczygiel--Pozdrawiam
Radosław SzczygiełTemat: Re: [pgpool-general: 6914] Re: latest PgpoolAdmin problemData: 2020-03-10 10:30Nadawca: "Bo Peng" <pengbo at sraoss.co.jp>Adresat: "Radosław Szczygieł" <radoslaw.szczygiel at interia.pl>; DW: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net>; > Hello,
> 
> On Fri, 06 Mar 2020 08:39:43 +0100
> Radosław Szczygieł  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  -p 9999 -U  template1 -c "SELECT usesuper FROM pg_user WHERE usename = ''"
> (input login user password)
>  usesuper 
> ----------
>  t
> ----------------------------
> 
> 
> 
> > > 
> > > I found the following error.
> > > 
> > > ====
> > > [Wed Mar 04 10:05:56.060383 2020] [:error] [pid 9565] [client 172.30.173.36:51097] 
> > > PHP Fatal error:  Call to undefined function hash_equals() in /var/www/html/pgpoolAdmin/login.php on line 85, referer: 
> > > http://172.31.74.164/pgpoolAdmin/login.php
> > > ====
> > > 
> > > Your php version (php-5.4.16) doesn't support hash_equals function.
> > > Your php version must be higher than PHP 5.6 or 7.0.
> > > 
> > > https://www.php.net/manual/en/function.hash-equals.php
> > > 
> > > On Wed, 04 Mar 2020 10:48:12 +0100
> > > Radosław Szczygieł  wrote:
> > > 
> > > > 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 172.30.173.36:51080] PHP Warning:  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 172.30.173.36:51097] PHP Fatal error:  Call to undefined function hash_equa
>  ls() in /v
> > >  ar/www/html/pgpoolAdmin/login.php on line 85, referer: http://172.31.74.164/pgpoolAdmin/login.phpRadoslaw Szczygiel--PozdrawiamRadosław SzczygiełTemat: Re: [pgpool-general: 6893] latest PgpoolAdmin problemData: 2020-03-04 3:50Nadawca: "Bo Peng" Adresat: "Radosław
> > > 
> > > -- 
> > > Bo Peng 
> > > SRA OSS, Inc. Japan
> > > 
> 
> 
> -- 
> Bo Peng 
> SRA OSS, Inc. Japan
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200310/0ef4a7f9/attachment.html>