[pgpool-general: 3098] Re: pg_md5 issue
ishii at postgresql.org
Tue Aug 12 00:36:30 JST 2014
> Hi all,
> I was trying to document my procedure for setting up pgpool for my QA
> folks when I stumbled across an issue with pg_md5.
> If I issue: /usr/bin/pg_md5 --md5auth <password> where <password> is
> the user's actual password, pg_md5 writes an entry to the pool_passwd
> file like:
> but if I issue the command as /usr/bin/pg_md5 <password> what gets
> spit out to terminal is:
> Now, I know md5 can have multiple strings evaluate to the same answer,
> but the value written into the pool_passwd file does NOT work,
Are you sure that:
enable_pool_hba = on
and set up pool_hba.conf correctly?
> whereas, if I edit the pool_passwd file and write the second string
> ending in 679 to it, then it does work. I noticed this when I copied
> and pasted the entry into the /etc/pgpool-II/pcp.conf file. Attempting
> to use any pcp_* command fails authentication with the first string,
> but works when the second string is in the file.
> I'm using centO/S 6.5 and V.3.3.3-4 of pgpool if that makes a
> difference, but I'd like to know why it works differently in these
> cases with one being OK to use, and the other failing miserably.
> pgpool-general mailing list
> pgpool-general at pgpool.net
More information about the pgpool-general