pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgpool: DETAIL: no pool_hba.conf entry for host
3+ messages / 2 participants
[nested] [flat]
* pgpool: DETAIL: no pool_hba.conf entry for host
@ 2016-02-29 10:41 Michael JOIGNY <mjoigny@neteven.com>
0 siblings, 1 reply; 3+ messages in thread
From: Michael JOIGNY @ 2016-02-29 10:41 UTC (permalink / raw)
To: pgsql-admin
Hi everybody,
I'm looking for some help on Postgresql 9.5 with Pgpool 3.4.
Since the upgrade from postgresql 9.3 to 9.5, i have the same error
message below when i'm trying to connect to pgpool using PGadmin :
/*"pgpool: DETAIL: no pool_hba.conf entry for host "myhost", user
"myuser", database "mydatabase", SSL off"
*/
However i obtain this error message on Windows 10 client with pgadmin
v.1.22 but on my ubuntu client, it works fine with the same pgadmin
version..../*
*/This is my configuration :
* Postgresql : 9.5.1-1.pgdg70+1
o postgresql.conf :
+ ssl = true
o pg_hba :
+ hostssl all all mynetwork md5
* Pgpool : 3.4.3-1.pgdg70+1
o pool_hba
+ hostssl all all mynetwork md5
The same settings works fine with the same configuration on postgresql
9.3.11 / pgpool 3.1.3 with windows/ubuntu clients...
Do you have an idea ? ciphers's problem ? Thanks in advance.
--
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgpool: DETAIL: no pool_hba.conf entry for host
@ 2016-03-14 12:59 Michael JOIGNY <mjoigny@neteven.com>
parent: Michael JOIGNY <mjoigny@neteven.com>
0 siblings, 1 reply; 3+ messages in thread
From: Michael JOIGNY @ 2016-03-14 12:59 UTC (permalink / raw)
To: pgsql-admin
Hi all,
Any idea really ?
Regards
Le 29/02/2016 11:41, Michael JOIGNY a écrit :
> Hi everybody,
>
> I'm looking for some help on Postgresql 9.5 with Pgpool 3.4.
>
> Since the upgrade from postgresql 9.3 to 9.5, i have the same error
> message below when i'm trying to connect to pgpool using PGadmin :
>
> /*"pgpool: DETAIL: no pool_hba.conf entry for host "myhost", user
> "myuser", database "mydatabase", SSL off"
> */
> However i obtain this error message on Windows 10 client with pgadmin
> v.1.22 but on my ubuntu client, it works fine with the same pgadmin
> version..../*
>
> */This is my configuration :
>
> * Postgresql : 9.5.1-1.pgdg70+1
> o postgresql.conf :
> + ssl = true
> o pg_hba :
> + hostssl all all mynetwork md5
>
> * Pgpool : 3.4.3-1.pgdg70+1
> o pool_hba
> + hostssl all all mynetwork md5
>
>
> The same settings works fine with the same configuration on postgresql
> 9.3.11 / pgpool 3.1.3 with windows/ubuntu clients...
>
> Do you have an idea ? ciphers's problem ? Thanks in advance.
>
> --
--
Attachments:
sign_neteven.png (image/png, 20.2K) download
view image
* Re: pgpool: DETAIL: no pool_hba.conf entry for host
@ 2016-03-16 12:51 Feike Steenbergen <feikesteenbergen@gmail.com>
parent: Michael JOIGNY <mjoigny@neteven.com>
0 siblings, 0 replies; 3+ messages in thread
From: Feike Steenbergen @ 2016-03-16 12:51 UTC (permalink / raw)
To: mjoigny@neteven.com; +Cc: pgsql-admin
> "pgpool: DETAIL: no pool_hba.conf entry for host "myhost", user "myuser",
database "mydatabase", SSL off"
It seems pgAdmin3 on your Windows is trying to connect without ssl ("SSL
off").
When creating a connection in pgAdmin3, I have a tab called 'SSL' in my
pgAdmin3, where I can specify the sslmode. Setting it to prefer should
probably do the trick.
http://www.postgresql.org/docs/current/static/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2016-03-16 12:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-02-29 10:41 pgpool: DETAIL: no pool_hba.conf entry for host Michael JOIGNY <mjoigny@neteven.com>
2016-03-14 12:59 ` Michael JOIGNY <mjoigny@neteven.com>
2016-03-16 12:51 ` Feike Steenbergen <feikesteenbergen@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox