[Pgpool-general] problem connecting through pgpool

[Peter Vallero]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20070910/b78b47ff/attachment.html