Re: pgadmin4 ssl HELP!
| От | Jeff Janes |
|---|---|
| Тема | Re: pgadmin4 ssl HELP! |
| Дата | |
| Msg-id | CAMkU=1xFf_ECfjaSeQR1AEPAGU-BPV7BHzM8Vyr++yi3ZbJ2BA@mail.gmail.com обсуждение исходный текст |
| Ответ на | pgadmin4 ssl HELP! (Иванов Евгений Сергеевич <zhenja86@gmail.com>) |
| Список | pgadmin-support |
On Fri, Aug 11, 2017 at 4:30 AM, Иванов Евгений Сергеевич <zhenja86@gmail.com> wrote:
I can not solve the problem. I use pgadmin4 v 1.6 through the web
(apache2). In the database connection settings in the SSL-mode
parameter, select "Verify-FULL". When I try to connect, I get an
error: "root certificate file" /var/lib/wwwrun/.postgresql/root.crt
"does not exist. Either provide the file or change sslmode to disable
server certificate verification."
Problem: The path by which the application searches for the
"/var/lib/wwwrun/.postgresql/root.crt" certificate is the same for all
users of pgadmin4. That makes it impossible to use this application as
a multi-user application when using SSL.
If multiple users are all using the same machine, then there is already one person they all trust--the person who has root access to that machine. Why wouldn't that person sign all the certs, or arrange for them to be signed?
Cheers,
Jeff
В списке pgadmin-support по дате отправления: