[pgpool-general: 4625] Re: md5 authentication with pgpool

Lucas Luengas lucasluengas at gmail.com
Fri Apr 8 03:52:27 JST 2016


Hello
You can check pgpool log and postgresql log when you run that psql command.
Regards.
On Apr 6, 2016 8:30 PM, "Daniel Gallo" <danielito.gallo at gmail.com> wrote:

> Dear I'm trying to run the following and I get the following error and I
> can not figure out what the problem is , I could help ?
>
>
> Any information that need be notified me and sent them
>
>
>
> Thanks a lots!!!!!
>
>
>
>
>
> -bash-4.2$ psql -h localhost -U postgres -p 5432
>
> psql (9.4.4)
>
> Digite «help» para obtener ayuda.
>
>
>
> postgres=#
>
>
>
>
>
> *-bash-4.2$ psql -h localhost -U postgres -p 9999*
>
> *psql: ERROR:  unable to read message length*
>
> *DETALLE:  message length (12) in slot 1 does not match with slot 0(8)*
>
>
>
> Any idea?
>
>
>
>
>
>
>
> *pg_hba.conf*
>
>
>
> # TYPE  DATABASE        USER            ADDRESS                 METHOD
>
>
>
> # "local" is for Unix domain socket connections only
>
> local   all             all                                     md5
>
> # IPv4 local connections:
>
> host    all             all             127.0.0.1/32            md5
>
> host    all             all             0.0.0.0/0               md5
>
> # IPv6 local connections:
>
> # Allow replication connections from localhost, by a user with the
>
> # replication privilege.
>
> local   replication     postgres                                trust
>
> host    replication     replication        0.0.0.0/0            trust
>
> #host    replication     postgres        ::1/128                 trust
>
>
>
> -rwxrw-r--. 1 apache apache 33283 abr  1 15:49 pgpool.conf
>
>
>
> *pgpool.conf*
>
>
>
> # - Authentication -
>
>
>
> enable_pool_hba = on
>
>                                    # Use pool_hba.conf for client
> authentication
>
> pool_passwd = 'pool_passwd'
>
>                                    # File name of pool_passwd for md5
> authentication.
>
>                                    # "" disables pool_passwd.
>
>                                    # (change requires restart)
>
> authentication_timeout = 60
>
>                                    # Delay in seconds to complete client
> authentication
>
>                                    # 0 means no timeout.
>
>
>
>
>
>
> -rw-r--r--. 1 apache root      42 feb 29 18:28 pool_passwd
>
>
>
> postgres:5c0435eee0f211f150e980e459151xxx
>
>
>
>
>
> -rwxrw-r--. 1 root   root    3295 mar  3 18:19 pool_hba.conf
>
>
>
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>
>
>
> # "local" is for Unix domain socket connections only
>
> local   all         all                               md5
>
> # IPv4 local connections:
>
> host    all         all         127.0.0.1/32          md5
>
> host    all         all         0.0.0.0/0             md5
>
> #host    all         all         ::1/128               trust
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160407/f31a8b2f/attachment.html>


More information about the pgpool-general mailing list