[Pgpool-general] problem connecting through pgpool

[Tatsuo Ishii]

It indicates that backend 1 failed to connect becauase of an
authentication error. Can you show me the host/ip where pgpool running
on, pgpool.conf and pg_hba.conf for backend 1?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Thanks...  I synched up my pg_hba.conf between the two nodes, and those with pool_hba.conf, and I'm no longer getting that exception.  But I'm still not able to connect; now I'm getting this in the log:
> 
> 2007-09-10 20:56:25 DEBUG: pid 21956: I am PCP 21956
> 2007-09-10 20:56:37 DEBUG: pid 21935: I am 21935 accept fd 5
> 2007-09-10 20:56:37 DEBUG: pid 21935: Protocol Major: 1234 Minor: 5679 database:  user:
> 2007-09-10 20:56:37 DEBUG: pid 21935: SSLRequest: sent N; retry startup
> 2007-09-10 20:56:37 DEBUG: pid 21935: Protocol Major: 3 Minor: 0 database: jacked user: jacked
> 2007-09-10 20:56:37 DEBUG: pid 21935: new_connection: connecting 0 backend
> 2007-09-10 20:56:37 DEBUG: pid 21935: new_connection: connecting 1 backend
> 2007-09-10 20:56:37 ERROR: pid 21935: pool_read_kind: kind does not match between master(69) slot[1] (82)
> 
> Thanks for you help.
> 
> Peter Vallero
> 
> 
> ----- Original Message ----
> From: Tatsuo Ishii <ishii at sraoss.co.jp>
> To: pjvallero at yahoo.com
> Cc: pgpool-general at pgfoundry.org
> Sent: Monday, September 10, 2007 2:17:45 AM
> Subject: Re: [Pgpool-general] problem connecting through pgpool
> 
> 
> My guess is, you have trust authentication(i.e. no password) for
> backend 0, while backend 1 uses md5 or some other password auth
> methods. You need to use same auth method for all DBs and the auth
> method must be one of trust, clear text password and pam.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> 
> > I have configured pgpool-II in replication mode, and when I attempt to connect through pgpool to either of the 2 databases, I get this error:
> > 
> > 2007-09-10 00:24:46 DEBUG: pid 8204: new_connection: connecting 0 backend
> > 2007-09-10 00:24:46 DEBUG: pid 8204: new_connection: connecting 1 backend
> > 2007-09-10 00:24:46 DEBUG: pid 8204: pool_read_message_length: slot: 0 length: 12
> > 2007-09-10 00:24:46 DEBUG: pid 8204: pool_read_message_length: slot: 1 length: 8
> > 2007-09-10 00:24:46 ERROR: pid 8204: pool_read_message_length: message length (8) in slot 1 does not match with slot 0
> > 
> > Can anyone explain what is happening and give any advice to resolve this?
> > 
> > Thanks,
> > 
> > Peter Vallero
> > Database Administrator