Re: pgAdmin 4 | Changing Mail From information!

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:

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.

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