Well, I'm using PostgresPlus Advanced server which is built using X/Open Sockets. on HP-UX. (
HP-UX provides type of Sockets API: + default BSD Sockets + X/Open Sockets ) and the pgpool-II was not built with it. That means it was using BSD sockets. Hence, I rebuilt pgpool-II with "CFLAGS=-D_XOPEN_SOURCE_EXTENDED LIBS=-lxnet" and then everything worked fine. ________________________________ From: Tatsuo Ishii <is...@sraoss.co.jp> To: sandee...@yahoo.com Cc: lgarc...@vnz.uci.cu; jose.mend...@autonomy.com; pgpool-general@pgfoundry.org Sent: Friday, September 16, 2011 3:12 PM Subject: Re: [Pgpool-general] online recovery fails on HPUX Can you please show me more details about the issue? That would be usefull info for those who are using HP. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp > okay. That was some x/open socket issue on HP. Thanks guys. > > > > > ________________________________ > From: Sandeep Thakkar <sandee...@yahoo.com> > To: Lazaro Rubén García Martinez <lgarc...@vnz.uci.cu>; Jose Mendoza > <jose.mend...@autonomy.com>; "pgpool-general@pgfoundry.org" > <pgpool-general@pgfoundry.org> > Sent: Thursday, September 15, 2011 4:27 PM > Subject: Re: [Pgpool-general] online recovery fails on HPUX > > > Thanks. I have the following entry in pg_hba.conf since my pgpool runs on > the same host. > > host replication edb 127.0.0.1/32 trust > > > I also use pcp.conf for online recovery. Is it really needed when I do not > use md5 authentication? > > > So, my configuration looks fine. Then why do I see this error? > > > > ________________________________ > From: Lazaro Rubén García Martinez <lgarc...@vnz.uci.cu> > To: Sandeep Thakkar <sandee...@yahoo.com>; Jose Mendoza > <jose.mend...@autonomy.com>; "pgpool-general@pgfoundry.org" > <pgpool-general@pgfoundry.org> > Sent: Wednesday, September 14, 2011 7:11 PM > Subject: RE: [Pgpool-general] online recovery fails on HPUX > > > > If you want md5 authentication between > postgresql and pgpool, you need enable pool_hba property, configure > pg_hba.conf > and create a pool_passwd file. This file contains an user and password for > connecting pgpool with database server. But, if md5 authentication is not > used, > for instance clear text password (password) the configuration can look like > this: > > In pgpool.conf > > enable_pool_hba = false > > # - online recovery - > # online recovery user > recovery_user = 'postgres' > > # online recovery password > recovery_password > = 'postgres' > > In pg_hba.conf > > # TYPE DATABASE > USER CIDR-ADDRESS METHOD > host > all all {Pgpool IP} password > > In case of trust authentication the > configuration looks like this: > > In pgpool.conf > > enable_pool_hba = false > > # - online recovery - > # online recovery user > recovery_user = 'postgres' > > # online recovery password > recovery_password > = '' > > In pg_hba.conf > > # TYPE DATABASE > USER CIDR-ADDRESS METHOD > host > all all {Pgpool IP} trust > > Regards > > > De:pgpool-general-boun...@pgfoundry.org > [mailto:pgpool-general-boun...@pgfoundry.org] En nombre de Sandeep > Thakkar > Enviado el: miércoles, 14 de septiembre de 2011 07:50 > Para: Sandeep Thakkar; Jose Mendoza; pgpool-general@pgfoundry.org > Asunto: Re: [Pgpool-general] online recovery fails on HPUX > > I have set "enable_pool_hba = false" in pgpool.conf and do not use > pool_hba.conf. Do we need to enable this? How does the client authentication > works when pool_hba.conf is disabled? > > > ________________________________ > > From:Sandeep > Thakkar <sandee...@yahoo.com> > To: Sandeep Thakkar <sandee...@yahoo.com>; Jose Mendoza > <jose.mend...@autonomy.com>; "pgpool-general@pgfoundry.org" > <pgpool-general@pgfoundry.org> > Sent: Wednesday, September 14, 2011 4:33 PM > Subject: Re: [Pgpool-general] online recovery fails on HPUX > I still face this issue and I wonder why do I see the following > error in the pgpool log: > > 2011-09-14 04:48:52 LOG: pid 10268: starting > recovering node 1 > 2011-09-14 04:48:53 ERROR: pid 10268: start_recover: could not connect master > node. > > Please help! Thanks > > > > ________________________________ > > From:Sandeep > Thakkar <sandee...@yahoo.com> > To: Sandeep Thakkar <sandee...@yahoo.com>; Jose Mendoza > <jose.mend...@autonomy.com>; "pgpool-general@pgfoundry.org" > <pgpool-general@pgfoundry.org> > Sent: Tuesday, September 13, 2011 4:52 PM > Subject: Re: [Pgpool-general] online recovery fails on HPUX > I mean, pcp_remote_start contains "$PGCTL -w -D $DESTDIR > start". i.e without SSH > > Sandeep. > > ________________________________ > > From:Sandeep > Thakkar <sandee...@yahoo.com> > To: Jose Mendoza <jose.mend...@autonomy.com>; > "pgpool-general@pgfoundry.org" <pgpool-general@pgfoundry.org> > Sent: Tuesday, September 13, 2011 4:24 PM > Subject: Re: [Pgpool-general] online recovery fails on HPUX > Well, actually my database servers and pgpool running on the same > host, so my pcp_remote_start does not contains "$PGCTL -w -D $DESTDIR > start". i.e without SSH. This works fine on Linux, though. > > Sandeep. > > ________________________________ > > From:Jose > Mendoza <jose.mend...@autonomy.com> > To: pgpool-general@pgfoundry.org > Sent: Friday, September 2, 2011 12:47 PM > Subject: Re: [Pgpool-general] online recovery fails on HPUX > If you already have an sshkey defined and it’s the same user on > both servers then. I am not sure what could be causing the failure but > according to your log its an ssh auth issue. > > Have you tried running a telnet test to the port to check that > is listening… > > Jose > Autonomy Ops > verificare > tua hinc > From:Sandeep Thakkar [mailto:sandee...@yahoo.com] > Sent: Friday, September 02, 2011 12:05 AM > To: Jose Mendoza; pgpool-general@pgfoundry.org > Subject: Re: [Pgpool-general] online recovery fails on HPUX > > Sorry, I didn't get you.. Actually, both the server > instances and the pgpool running on the same host.. Could this be an > issue of loopback? > > ________________________________ > > From:Jose > Mendoza <jose.mend...@autonomy.com> > To: pgpool-general@pgfoundry.org > Sent: Friday, September 2, 2011 12:16 PM > Subject: Re: [Pgpool-general] online recovery fails on HPUX > SSh trust must be created on both server for all the accounts > involved in the recovery process. > I would add the ssh-keys the the user for pgpool and try again. > > > Jose > Autonomy Ops > verificare > tua hinc > From:Sandeep Thakkar [mailto:sandee...@yahoo.com] > Sent: Thursday, September 01, 2011 10:17 PM > To: Jose Mendoza; pgpool-general@pgfoundry.org > Subject: Re: [Pgpool-general] online recovery fails on HPUX > > I can see the following lines in /tmp/pgpool.log: > ...... > 2011-09-01 22:57:34 ERROR: pid 22975: check_replication_time_lag: > DB node is valid but no persistent connection > 2011-09-01 22:57:34 DEBUG: pid 22936: health_check: 1 th DB node status: 3 > 2011-09-01 22:57:36 LOG: pid 23019: starting recovering node 1 > 2011-09-01 22:57:36 ERROR: pid 23019: start_recover: could not connect master > node. > 2011-09-01 22:57:38 DEBUG: pid 22936: starting health checking > 2011-09-01 22:57:38 DEBUG: pid 22936: health_check: 0 th DB node status: 1 > 2011-09-01 22:57:38 DEBUG: pid 22975: pool_ssl: SSL requested but SSL support > is not available > 2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: auth kind: 0 > 2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: parameter status data > received > 2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: parameter status data > received > 2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: backend key data received > 2011-09-01 22:57:38 DEBUG: pid 22975: s_do_auth: transaction state: I > 2011-09-01 22:57:39 DEBUG: pid 22936: health_check: 1 th DB node status: 3 > 2011-09-01 22:57:39 ERROR: pid 22975: connect_inet_domain_socket: connect() > failed: Connection refused > 2011-09-01 22:57:39 ERROR: pid 22975: make_persistent_db_connection: > connection > to localhost(5445) failed > 2011-09-01 22:57:39 DEBUG: pid 22975: do_query: kind: T > 2011-09-01 22:57:39 DEBUG: pid 22975: num_fileds: 1 > 2011-09-01 22:57:39 DEBUG: pid 22975: do_query: kind: D > 2011-09-01 22:57:39 DEBUG: pid 22975: do_query: kind: C > 2011-09-01 22:57:39 DEBUG: pid 22975: do_query: kind: Z > 2011-09-01 22:57:39 ERROR: pid 22975: check_replication_time_lag: DB node is > valid but no persistent connection > 2011-09-01 22:57:43 DEBUG: pid 22936: starting health checking > ...... > > > > ________________________________ > > From:Sandeep Thakkar <sandee...@yahoo.com> > To: Jose Mendoza <jose.mend...@autonomy.com>; > "pgpool-general@pgfoundry.org" <pgpool-general@pgfoundry.org> > Sent: Friday, September 2, 2011 10:10 AM > Subject: Re: [Pgpool-general] online recovery fails on HPUX > # Logging directory > logdir = '/tmp' > > > > ________________________________ > > From:Jose > Mendoza <jose.mend...@autonomy.com> > To: pgpool-general@pgfoundry.org > Sent: Wednesday, August 31, 2011 10:28 PM > Subject: Re: [Pgpool-general] online recovery fails on HPUX > What does your pgpool.conf say about logging: > # Logging directory > logdir = '/var/log' > > > Jose > Autonomy Ops > verificare > tua hinc > From:pgpool-general-boun...@pgfoundry.org > [mailto:pgpool-general-boun...@pgfoundry.org] On Behalf Of Sandeep > Thakkar > Sent: Wednesday, August 31, 2011 4:58 AM > To: Sandeep Thakkar; pgpool-general@pgfoundry.org > Subject: Re: [Pgpool-general] online recovery fails on HPUX > > I see following two lines when the pcp_recovery_node is > fired.. Also, I cannot find recovery.log, but recovery.conf is present in > standby cluster directory.. > > .... > 2011-08-31 05:49:22 LOG: pid 20430: starting > recovering node 1 > 2011-08-31 05:49:22 ERROR: pid 20430: start_recover: could not connect master > node. > .... > > The pg_hba.conf has the following entry: > > # "local" is for Unix domain socket connections only > local > all > all > trust > # IPv4 local connections: > host > all > all > 127.0.0.1/32 > trust > # IPv6 local connections: > host > all > all > ::1/128 > trust > host > replication > edb > 127.0.0.1/32 > trust > > > > ________________________________ > > From:Sandeep Thakkar <sandee...@yahoo.com> > To: "pgpool-general@pgfoundry.org" > <pgpool-general@pgfoundry.org> > Sent: Tuesday, August 30, 2011 2:44 PM > Subject: [Pgpool-general] online recovery fails on HPUX > Hi, > > I'm using Postgres Plus Advanced Server on HP-UX 11.31 and found that the > online recovery does not work here. > > pgPool version is 3.0.3-4 > > $pcp_recovery_node -d 20 localhost 9898 edb edb 1 > DEBUG: send: tos="R", len=41 > DEBUG: recv: tos="r", len=21, data=AuthenticationOK > DEBUG: send: tos="D", len=6 > DEBUG: recv: tos="e", len=20, data=recovery failed > DEBUG: command failed. reason=recovery failed > BackendError > DEBUG: send: tos="X", len=4 > > I can see the following in the log: > .... > LOG: incomplete startup packet > LOG: connection failed during start up processing: user= database= > .... > > Moreover, I do not see pgpool_recovery_node statement in the log, so wondering > if it is really getting executed. I have tried my scripts on Linux and it > worked all fine. So, there is no issue with the pgpool.conf or my basebackup > and other files.. Could this be an issue of HPUX? > > Thanks. > > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general > > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general > > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > > > > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
