Dear Murtuza, Wow, it works, thank you so much.
Thank you and best regards, Đỗ Ngọc Trí Cường (Mr.) | Software Development Department | +84 28 3715 5325 From: "Murtuza Zabuawala" <murtuza.zabuaw...@enterprisedb.com> To: "Đỗ Ngọc Trí Cường" <dntcu...@digi-texx.vn> Cc: "Dave Page" <dp...@pgadmin.org>, pgadmin-support@lists.postgresql.org Sent: Tuesday, November 28, 2017 2:52:37 PM Subject: Re: pgAdmin 4 | Changing Mail From information! Oh You were talking about the security email sender, I thought it's for SMTP login. Anyways you can changed it via SECURITY_EMAIL_SENDER option in config_local.py. SECURITY_EMAIL_SENDER = os.environ['MAIL_USERNAME'] -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Tue, Nov 28, 2017 at 1:02 PM, Đỗ Ngọc Trí Cường < dntcu...@digi-texx.vn > wrote: Dear Murtuza, Thank you so much for your support. But unfortunately, it stills not work. Then I think maybe that sender have been hard-code in a file stored somewhere, so I try to find the key-word in all folder. Luckily, I find it, in the file "site-packages/flask_security/core.py" there is one line: BQ_BEGIN 'EMAIL_SENDER': 'no-reply@localhost' After that, I edit that file such as BQ_BEGIN import os 'EMAIL_SENDER': os.environ['MAIL_USERNAME'] BQ_END And it works. I don't know this is a bug or not, but I think maybe we can consider it as a environment option in the future. Once again, thank you so much for your support. I love all of you. Thank you and best regards, Đỗ Ngọc Trí Cường (Mr.) | Software Development Department | +84 28 3715 5325 From: "Murtuza Zabuawala" < murtuza.zabuaw...@enterprisedb.com > To: "Đỗ Ngọc Trí Cường" < dntcu...@digi-texx.vn > Cc: "Dave Page" < dp...@pgadmin.org >, pgadmin-support@lists.postgresql.org Sent: Tuesday, November 28, 2017 12:15:24 PM Subject: Re: pgAdmin 4 | Changing Mail From information! Then MAIL_USERNAME & MAIL_DEFAULT_SENDER should be same, MAIL_USERNAME = os.environ['MAIL_USERNAME'] MAIL_DEFAULT_SENDER = os.environ['MAIL_USERNAME'] On Tue, Nov 28, 2017 at 7:36 AM, Đỗ Ngọc Trí Cường < dntcu...@digi-texx.vn > wrote: BQ_BEGIN 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. BQ_BEGIN MAIL_DEFAULT_SENDER = ' mail_d...@digi-texx.vn ' BQ_END Thank you and best regards, Đỗ Ngọc Trí Cường (Mr.) | Software Development Department | +84 28 3715 5325 From: "Murtuza Zabuawala" < murtuza.zabuaw...@enterprisedb.com > To: "Đỗ Ngọc Trí Cường" < dntcu...@digi-texx.vn > Cc: "Dave Page" < dp...@pgadmin.org >, pgadmin-support@lists.postgresql.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_d...@digi-texx.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 < dntcu...@digi-texx.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_d...@digi-texx.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" < dp...@pgadmin.org > To: "Đỗ Ngọc Trí Cường" < dntcu...@digi-texx.vn > Cc: pgadmin-support@lists.postgresql.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 < dntcu...@digi-texx.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@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:< dntcu...@digi-texx.vn >\r\n' reply: b'553 5.7.1 <no-reply@localhost>: Sender address rejected: not owned by user mail_d...@digi-texx.vn \r\n' reply: retcode (553); Msg: b'5.7.1 <no-reply@localhost>: Sender address rejected: not owned by user mail_d...@digi-texx.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 BQ_END BQ_END
