[Pgpool-general] pgpool pghba woes in parallel mode
mobiledreamers at gmail.com
mobiledreamers at gmail.com
Sat Jun 27 17:12:22 UTC 2009
i tried trust as method of auth, and sometiems it gives error message length
8 and 12 does not match or read auth kind failed
Please show me how to setup pg_hba for pgpool-II in parallel mode
thanks
pgpool node 26.129.113.181
in all the backend node pg_hba.conf
host all all 26.129.113.181 255.255.255.255 trust
in 26.129.113.181
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
tail -f /tmp/pgpool.log
2009-06-27 10:07:23 LOG: pid 23935: pgpool successfully started
2009-06-27 10:07:31 ERROR: pid 23937: pool_read_message_length: message
length (12) in slot 2 does not match with slot 0(8)
2009-06-27 10:07:31 ERROR: pid 23937: Failed to read the authentication
packet length. This is likely caused by the inconsistency of auth method
among DB nodes. In this case you can check the previous error messages
(hint: length field) from pool_read_message_length and recheck the
pg_hba.conf settings.
2009-06-27 10:08:22 ERROR: pid 23938: pool_read_message_length: message
length (12) in slot 2 does not match with slot 0(8)
2009-06-27 10:08:22 ERROR: pid 23938: Failed to read the authentication
packet length. This is likely caused by the inconsistency of auth method
among DB nodes. In this case you can check the previous error messages
(hint: length field) from pool_read_message_length and recheck the
pg_hba.conf settings.
2009-06-27 10:08:58 LOG: pid 23935: received smart shutdown request
tail: /tmp/pgpool.log: file truncated
2009-06-27 10:09:02 ERROR: pid 26198: pool_read_int: data does not match
between between master(0) slot[3] (50331648)
2009-06-27 10:09:02 ERROR: pid 26198: pool_do_auth: read auth kind failed
2009-06-27 10:09:20 LOG: pid 26192: received smart shutdown request
tail: /tmp/pgpool.log: file truncated
2009-06-27 10:09:24 ERROR: pid 26777: pool_read_int: data does not match
between between master(0) slot[4] (50331648)
2009-06-27 10:09:24 ERROR: pid 26777: pool_do_auth: read auth kind failed
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090627/97517af3/attachment.html>
More information about the Pgpool-general
mailing list