<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html><body><div>I've found problem!!<br><span class="tlid-translation translation" lang="en"><span title="" class="">Even though i don't use ipv6 network it was running and postgres and pgpool use it instead of ipv4 :/<br></span></span><br><span class="tlid-translation translation" lang="en"><span title="" class=""><span class="tlid-translation translation" lang="en"><span title="" class="">strange that in pgpoolAdmin v3.7 this problem was not and it is the same server and the same cluster ...<br><br></span></span>I disable ipv6 on all machines (postgres and pgpool) and restart them. <br>After this pgpool dont show error and now in status page of pgpoolAdmin is:<br></span></span><ul><li>login user: pgpool</li><li>superuser: yes </li></ul>Thank You,<br><br>Radoslaw Szczygie<br><br><br><br>--<br>Pozdrawiam
<br>Radosław Szczygieł<div class="inpl-collapsed">Temat: [pgpool-general: 6934] Re: latest PgpoolAdmin problem<br>Data: 2020-03-12 9:27<br>Nadawca: "Radosław Szczygieł" <radoslaw.szczygiel@interia.pl><br>Adresat: "Bo Peng" <pengbo@sra<a href="http://oss.co.jp" target="_blank">oss.co.jp</a>>; <br>DW: "pgpool-general@pgpool.net" <pgpool-general@pgpool.net>; <br><br><blockquote style="margin: 0px; padding-left: 1ex; border-left: 1px solid #CCCCCC;" data-mce-style="margin: 0px; padding-left: 1ex; border-left: 1px solid #CCCCCC;"><div>Hi Bo,<br>I found in pgpool log :<br>Mar 12 08:41:25 pgvtest4 pgpool[24357]: 25863 CHILD [No Connection] [No Connection]: FATAL: client authentication failed<br>Mar 12 08:41:25 pgvtest4 pgpool[24357]: 25863 CHILD [No Connection] [No Connection]: DETAIL: no pool_<a href="http://hba.conf" data-mce-href="http://hba.conf">hba.conf</a> entry for host "fe80::d356:6494:c469:ab60%enp0s3", user "pgpool", database "template1", SSL off<br><br>I dont use ipv6... <br>What I need to change in pool_<a href="http://hba.conf" data-mce-href="http://hba.conf">hba.conf</a> to use ipv4??<br><br>this is pool_<a href="http://hba.conf" data-mce-href="http://hba.conf">hba.conf:</a><br><br># "local" is for Unix domain socket connections only<br>local all all trust<br># IPv4 local connections:<br>host all all 127.0.0.1/32 md5<br>host all all ::1/128 md5<br>host all all 0.0.0.0/0 md5<br><br>Regards,<br>Radoslaw Szczygiel<br><br><br><br>--<br>Pozdrawiam <br>Radosław Szczygieł<div class="inpl-collapsed">Temat: Re: [pgpool-general: 6914] Re: latest PgpoolAdmin problem<br>Data: 2020-03-11 8:44<br>Nadawca: "Bo Peng" <pengbo@sraoss.co.jp><br>Adresat: "Radosław Szczygieł" <radoslaw.szczygiel@interia.pl>; <br>DW: "pgpool-general@pgpool.net" <pgpool-general@pgpool.net>; <br><br><blockquote style="margin: 0px; padding-left: 1ex; border-left: 1px solid #CCCCCC;" data-mce-style="margin: 0px; padding-left: 1ex; border-left: 1px solid #CCCCCC;"><pre>> 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@sraoss.co.jp>Adresat: "Radosław Szczygieł" <radoslaw.szczygiel@interia.pl>; DW: "pgpool-general@pgpool.net" <pgpool-general@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
> </pre><br></blockquote><br><br></div></div><br></blockquote><br><br></div></div><style type="text/css">#icselection13 {width: 100% !important; height: 100% !important; padding-top: 0px !important; overflow: visible !important;}</style><style type="text/css">#icselection13 {width: 100% !important; height: 100% !important; padding-top: 0px !important; overflow: visible !important;}</style><style type="text/css">#icselection13 {width: 100% !important; height: 100% !important; padding-top: 0px !important; overflow: visible !important;}</style></body></html>