[pgpool-general: 3140] Re: user setup issue

Megan . nagemnna at gmail.com
Wed Sep 3 21:53:07 JST 2014


Please disregard.  i figured out my issue.  Pgpool was pointing my
connection over to my db2 instead of db1 and i only had db1's pg_hba
configured.



On Wed, Sep 3, 2014 at 8:35 AM, Megan . <nagemnna at gmail.com> wrote:
> 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