[pgpool-general: 6936] Re: latest PgpoolAdmin problem
Bo Peng
pengbo at sraoss.co.jp
Fri Mar 13 16:18:55 JST 2020
Hello,
On Thu, 12 Mar 2020 09:50:19 +0100
Radosław Szczygieł <radoslaw.szczygiel at interia.pl> wrote:
> I've found problem!!Even though i don't use ipv6 network it was running and postgres and pgpool use it instead of ipv4 :/strange that in pgpoolAdmin v3.7 this problem was not and it is the same server and the same cluster ...I disable ipv6 on all machines (postgres and pgpool) and restart them. After this pgpool dont show error and now in status page of pgpoolAdmin is:login user: pgpoolsuperuser:
Yes.
The function to check superuser is changed between 3.7 and 4.1.
In 3.7, if host connecting fails, pgpooladmin will try local connetcing using healthcheckuser.
Therefore, you need to make sure you can use the hostname to connect pgpool.
The following SQL is executed:
psql -h `hostname -f` -p 9999 -U template1 -c "SELECT usesuper FROM pg_user WHERE usename = 'xxx'"
> >
> > On Tue, 10 Mar 2020 10:59:06 +0100
> > Radosław Szczygieł wrote:
> >
> > > 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--PozdrawiamRadosł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,
> >
> > Could you try to logout, then login again?
> > If it is not resovled, please show me the screenshot of "pgpool Status",
> > pgpool.conf and pgpool.log.
> >
> > > >
> > > > 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 undefine
d 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
> > > >
> >
> >
> > --
> > Bo Peng
> > SRA OSS, Inc. Japan
> >
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general
mailing list