Re: pgAdmin 4 | Changing Mail From information! - Mailing list pgadmin-support

Oh, so Flask-Security was overriding the setting for MAIL_DEFAULT_SENDER in Flask-Mail? Good catch - I'll add that to the config file for reference purposes. On Tue, Nov 28, 2017 at 8:29 AM, Đỗ Ngọc Trí Cường wrote: > 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 <+84%2028%203715%205325> > > ------------------------------ > *From: *"Murtuza Zabuawala" > *To: *"Đỗ Ngọc Trí Cường" > *Cc: *"Dave Page" , pgadmin-support@lists.postgres > ql.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 > 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: >> >> 'EMAIL_SENDER': 'no-reply@localhost' >> >> After that, I edit that file such as >> >> import os >> 'EMAIL_SENDER': os.environ['MAIL_USERNAME'] >> >> >> 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 <+84%2028%203715%205325> >> >> ------------------------------ >> *From: *"Murtuza Zabuawala" >> *To: *"Đỗ Ngọc Trí Cường" >> *Cc: *"Dave Page" , pgadmin-support@lists.postgres >> ql.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 > > wrote: >> >>> 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@digi-texx.vn' >>> >>> >>> >>> >>> Thank you and best regards, >>> >>> >>> Đỗ Ngọc Trí *Cường* (Mr.) | *Software Development Department* | +84 28 >>> 3715 5325 <+84%2028%203715%205325> >>> >>> ------------------------------ >>> *From: *"Murtuza Zabuawala" >>> *To: *"Đỗ Ngọc Trí Cường" >>> *Cc: *"Dave Page" , pgadmin-support@lists.postgres >>> ql.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@digi-texx.vn, >>> which might be not the same as @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@digi-texx.vn> wrote: >>> >>>> 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@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 <+84%2028%203715%205325> >>>> >>>> ------------------------------ >>>> *From: *"Dave Page" >>>> *To: *"Đỗ Ngọc Trí Cường" >>>> *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 < >>>> dntcuong@digi-texx.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: 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:\r\n' >>>>> reply: b'553 5.7.1 : Sender address rejected: not >>>>> owned by user mail_demo@digi-texx.vn\r\n' >>>>> reply: retcode (553); Msg: b'5.7.1 : Sender >>>>> address rejected: not owned by user mail_demo@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. >>>>> >>>> >>>> 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 >>>> >>>> >>> >> > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company