[pgpool-general: 6935] Re: latest PgpoolAdmin problem
Radosław Szczygieł
radoslaw.szczygiel at interia.pl
Thu Mar 12 17:50:19 JST 2020
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 Thank You,Radoslaw Szczygie--Pozdrawiam
Radosław SzczygiełTemat: [pgpool-general: 6934] Re: latest PgpoolAdmin problemData: 2020-03-12 9:27Nadawca: "Radosław Szczygieł" <radoslaw.szczygiel at interia.pl>Adresat: "Bo Peng" <pengbo at sraoss.co.jp>; DW: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net>; Hi Bo,I found in pgpool log :Mar 12 08:41:25 pgvtest4 pgpool[24357]: 25863 CHILD [No Connection] [No Connection]: FATAL: client authentication failedMar 12 08:41:25 pgvtest4 pgpool[24357]: 25863 CHILD [No Connection] [No Connection]: DETAIL: no pool_hba.conf entry for host "fe80::d356:6494:c469:ab60%enp0s3", user "pgpool", database "template1", SSL offI dont use ipv6... What I need to change in pool_hba.conf to use ipv4??this is pool_hba.conf:# "local" is for Unix domain socket connections onlylocal all all trust# IPv4 local connections:host all all 127.0.0.1/32 md5host all all ::1/128 md5host all all 0.0.0.0/0 md5Regards,Radoslaw Szczygiel--Pozdrawiam Radosław SzczygiełTemat: Re: [pgpool-general: 6914] Re: latest PgpoolAdmin problemData: 2020-03-11 8:44Nadawca: "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 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 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
> > >
>
>
> --
> Bo Peng
> SRA OSS, Inc. Japan
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200312/e58289c9/attachment-0001.html>
More information about the pgpool-general
mailing list