[pgpool-general: 3139] user setup issue

Megan . nagemnna at gmail.com
Wed Sep 3 21:35:01 JST 2014


Good Morning,

I apologize for asking a simple question, but I cannot seem to sort
out what i've done wrong.  I read
http://www.pgpool.net/docs/latest/pgpool-en.html#md5 and
http://www.pgpool.net/docs/latest/pgpool-en.html#hba but i still get
an error when my user tries to connect.


Server:  xxx.xxx.xxx.20
Client:   xxx.xxx.xxx.33
pgpool-II-3.3.1-1
postgresql92-server-9.2.6

The client trying to connect into pgpool:

[user at mgmt1-sit ~]$ psql -h xxx.xxx.xxx.33 -p 9999 -U tie tie


In the log I see:
2014-09-03 12:18:08 LOG:   pid 3819: pool_do_auth: maybe protocol
version mismatch (current version 3)


I read that this has to do with postgres's configuration for the user
vs. pgpool.  I tried everything i could but i can't get the user to
connect.


I added the user into pool_passwd with pg_md5

[root at db1-sit pgpool-II]# cat pool_passwd
tie:md5ad4f8e5d8253c246f507573acc6f745b


i added the below into pool_hba.conf

host    tie             tie             xxx.xxx.xxx.33/32         md5


The user/role exists in the postgres database with the same password
as was using in pool_passwd

I have the following in pg_hba.conf:

host   tie              tie          xxx.xxx.xxx.20/32        trust
local   tie     tie                             md5


pgpool and postgres have been restarted.

I've tried changing he host from trust to md5, i've removed the local
entry, tried every combination I can think of, but I still can't get
the user logged in.

Any help?

Thank you so much in advance.


More information about the pgpool-general mailing list