Re: passwords enabled by default

From: Fahar Abbas <fahar(dot)abbas(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Andrew Coleman <penguincoder(at)gmail(dot)com>, pgadmin-hackers <pgadmin-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: passwords enabled by default
Date: 2019-07-04 10:00:09
Message-ID: CAJFwRrMgS=G6FZdVRk2F1CQMHHaa2XqCob9d-dTbSxkoG8O31g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Yes Dave it's working as expected.

On Thu, Jun 27, 2019 at 8:16 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Fahar, can you verify that the Password File option works as expected (or
> not) in a non-containerised environment? It should *not* require PGPASSFILE
> to be set (because that's basically what it should be doing for us).
>
> Thanks.
>
> On Thu, Jun 27, 2019 at 8:27 AM Andrew Coleman <penguincoder(at)gmail(dot)com>
> wrote:
>
>> Recently, while testing my changes to entrypoint.sh in Docker, I noticed
>> that you cannot import or export passwords via the servers.json file. You
>> can get around this by setting the PassFile option in servers.json, but
>> that still doesn't work correctly. For me to make this work, I had to also
>> set the `PGPASSFILE` to the full path location of the pgpass file generated
>> for me by Helm.
>>
>> To clarify, I know how many servers I want to connect to and how to find
>> their passwords in Kubernetes via their secret, and I use Helm to stitch
>> all of that together into a pgpass file that psql and pgadmin4 can use to
>> connect to the servers without user intervention.
>>
>> The presence of the pgpass file and the reference to that file in the
>> servers.json was not enough to allow pgadmin4 to connect to the servers, I
>> also had to set `PGPASSFILE` in my Helm chart to make this work.
>>
>> This seems like another good ticket, no? I know where to add them and
>> I'll put a patch in place, but I could sure use a little bit of guidance on
>> the copy portion of the documentation. I know why it works for me, but
>> would anyone conceivably use this in a non-Dockerized deployment?
>>
>> Thanks,
>> Andrew
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

--
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2019-07-04 10:12:25 Re: passwords enabled by default
Previous Message Akshay Joshi 2019-07-04 08:29:22 [pgAdmin4][Patch]: RM 4393 Edit users with parameters 'all' gives error while saving