Re: pgAdmin 4 | Changing Mail From information!

Dear Murtuza ,

Yes, our email server for some security reason had checked and rejected when the user (used to authenticated) and the "Email From" in Header Section.

The authenticated user can not change, and now I'm trying to change the "Email From" too, but I can't find where I can configure it?

Please note that, I've already try to put config below into config_local.py, and config_distro.py also.

MAIL_DEFAULT_SENDER = ' mail_demo(at)digi-texx(dot)vn '

Thank you and best regards,

Đỗ Ngọc Trí Cường (Mr.) | Software Development Department | +84 28 3715 5325

From: "Murtuza Zabuawala" <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: "Đỗ Ngọc Trí Cường" <dntcuong(at)digi-texx(dot)vn>
Cc: "Dave Page" <dpage(at)pgadmin(dot)org>, pgadmin-support(at)lists(dot)postgresql(dot)org
Sent: Monday, November 27, 2017 10:09:27 PM
Subject: Re: pgAdmin 4 | Changing Mail From information!

Hello,

I suspect that the mail server is rejecting your email because you're trying to send from a username which differs from the username you're logging in as, e.g. you've set the From: to be mail_demo(at)digi-texx(dot)vn , which might be not the same as <MAIL_USERNAME>@ digi-texx.vn

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Mon, Nov 27, 2017 at 5:49 PM, Đỗ Ngọc Trí Cường < dntcuong(at)digi-texx(dot)vn > wrote:

BQ_BEGIN

Dear Dave,

Thankfully for your feedback.
I've add this into the config_local.py, and config_distro.py as below:

##########################################################################
# Mail server settings
##########################################################################

# These settings are used when running in web server mode for confirming
# and resetting passwords etc.
# See: http://pythonhosted.org/Flask-Mail/ for more info
MAIL_SERVER = os.environ['MAIL_SERVER']
MAIL_PORT = int(os.environ['MAIL_PORT'])
MAIL_USE_SSL = os.environ['MAIL_USE_SSL'].lower() in ("yes", "true", "1")
MAIL_USE_TLS = os.environ['MAIL_USE_TLS'].lower() in ("yes", "true", "1")
MAIL_USERNAME = os.environ['MAIL_USERNAME']
MAIL_PASSWORD = os.environ['MAIL_PASSWORD']
MAIL_DEBUG = os.environ['MAIL_DEBUG'].lower() in ("yes", "true", "1")
MAIL_DEFAULT_SENDER = ' mail_demo(at)digi-texx(dot)vn '
##########################################################################

But unfortunately, it stills not work although I've tried to restart the server already.

Could you think is there any config file more?

Thank you and best regards,

Đỗ Ngọc Trí Cường (Mr.) | Software Development Department | +84 28 3715 5325

From: "Dave Page" < dpage(at)pgadmin(dot)org >
To: "Đỗ Ngọc Trí Cường" < dntcuong(at)digi-texx(dot)vn >
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Sent: Monday, November 27, 2017 4:14:19 PM
Subject: Re: pgAdmin 4 | Changing Mail From information!

Hi

On Mon, Nov 27, 2017 at 6:53 AM, Đỗ Ngọc Trí Cường < dntcuong(at)digi-texx(dot)vn > wrote:

BQ_BEGIN

Dear all,

I'm new from pgAdmin4 (I normally used pgAdmin3 in the past).

Now, I'm deploy a server of pgAdmin4 using docker technology ( https://hub.docker.com/r/chorss/docker-pgadmin4/ ). I've deployed successfully. But noư I face an issue.

Our mail-server restricts to send email if the sender does not match with authenticate user (see log below). I've searched in the config and just found out the config about mail server and mail user/password. I can't find the config mail from or mail template.

Could you please help me where I can modify it?

************************************************************************************************
reply: b'235 2.7.0 Authentication successful\r\n'
reply: retcode (235); Msg: b'2.7.0 Authentication successful'
send: 'mail FROM:<no-reply(at)localhost> size=1191\r\n'
reply: b'250 2.1.0 Ok\r\n'
reply: retcode (250); Msg: b'2.1.0 Ok'
send: 'rcpt TO:< dntcuong(at)digi-texx(dot)vn >\r\n'
reply: b'553 5.7.1 <no-reply(at)localhost>: Sender address rejected: not owned by user mail_demo(at)digi-texx(dot)vn \r\n'
reply: retcode (553); Msg: b'5.7.1 <no-reply(at)localhost>: Sender address rejected: not owned by user mail_demo(at)digi-texx(dot)vn '
send: 'rset\r\n'
reply: b'250 2.0.0 Ok\r\n'
reply: retcode (250); Msg: b'2.0.0 Ok'
send: 'quit\r\n'
reply: b'221 2.0.0 Bye\r\n'
reply: retcode (221); Msg: b'2.0.0 Bye'
************************************************************************************************

Looking forward to your feedback.

BQ_END

You should be able to set MAIL_DEFAULT_SENDER to an appropriate address in your environment. There is a full list of available config options at http://pythonhosted.org/Flask-Mail/ which should work in addition to those shown in config.py.

As a sidenote, you should create config_distro.py (alongside config.py) to contain the required settings. Don't edit config.py itself.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

BQ_END