Re: Question regarding mail server

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Christos Roussidis <xristos(dot)roussidis(at)gmail(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: Question regarding mail server
Date: 2023-07-27 10:50:12
Message-ID: CAM9w-_k09Ert-_Tk4TiFM5F6h21V_BitY3NUkPMUY3TBUH5gPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Christos,

2FA is applicable for server mode only. And I tested in server mode. I used
pgAdmin default config.
Can you please share the screenshot and logs for v7.5?

On Thu, Jul 27, 2023 at 4:05 PM Christos Roussidis <
xristos(dot)roussidis(at)gmail(dot)com> wrote:

> Hello Aditya,
>
> Thank you for your prompt response,
>
> Did it work on the desktop mode or in server mode? I face that problem in
> the server mode.
>
> I will send you the configuration I have set
>
> OS: debian 11
> pgadmin4 version :7.3 (working, but error is being printed in logs), 7.5
> (not working)
> config file location: /etc/pgadmin/config_system.py
>
> Contents of config file
> ##########################################################################
> # Two-factor Authentication Configuration
> ##########################################################################
>
> # Set it to True, to enable the two-factor authentication
> MFA_ENABLED = True
>
> # Set it to True, to ask the users to register forcefully for the
> # two-authentication methods on logged-in.
> MFA_FORCE_REGISTRATION = False
>
> # pgAdmin supports Two-factor authentication by either sending an one-time
> code
> # to an email, or using the TOTP based application like Google
> Authenticator.
> MFA_SUPPORTED_METHODS = ["authenticator"]
>
> # NOTE: Please set the 'Mail server settings' to use 'email' as two-factor
> # authentication method.
>
> # Subject for the email verification code
> # Default: <APP_NAME> - Verification Code
> # e.g. pgAdmin 4 - Verification Code
> MFA_EMAIL_SUBJECT = None
>
>
> These are all the settings that I have and experiencing the issue (also,
> having postfix installed or not doesn't change anything as the issue
> persists on two different machines)
>
> Thank you in advance.
> Kind Regards,
> Christos
>
> On Thu, Jul 27, 2023 at 12:27 PM Aditya Toshniwal <
> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>
>> Hi Christos,
>>
>> I tried simply setting up 2FA without SMTP config and things worked fine.
>> No email required and no errors.
>> The password reset is required to send email as pgAdmin needs to send the
>> reset link for the first "email with password" authentication.
>>
>> On Thu, Jul 27, 2023 at 3:34 PM Christos Roussidis <
>> xristos(dot)roussidis(at)gmail(dot)com> wrote:
>>
>>> Hello,
>>>
>>> I would like to ask you a question regarding the mail server. So when
>>> running pgadmin4 in server mode it requires a mail server to send emails
>>> for things like 2FA and password reset.
>>>
>>> It seems impossible though to disable that function. Our setup doesn't
>>> need a mail server at all as we only use authenticator for the 2FA and
>>> admins are able to configure passwords and change them for the rare case
>>> that the user needs a reset on them.
>>>
>>> On version 7.3 I am getting in logs the error
>>> > 2023-07-27 11:37:09,086: ERROR pgadmin: 'mfa.send_email_code'
>>>
>>> The above error on version 7.5 is not silent anymore and even breaks our
>>> running pgadmin4 instance. It would really help if we had a toggle switch
>>> in the settings where we could completely disable the mail server
>>> functionality.
>>>
>>> Thank you in advance
>>>
>>>
>>
>>
>> --
>> Thanks,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>> <https://www.enterprisedb.com/>
>> "Don't Complain about Heat, Plant a TREE"
>>
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Christos Roussidis 2023-07-27 10:56:56 Re: Question regarding mail server
Previous Message Christos Roussidis 2023-07-27 10:35:07 Re: Question regarding mail server