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

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 > > ------------------------------ > *From: *"Murtuza Zabuawala" > *To: *"Đỗ Ngọc Trí Cường" > *Cc: *"Dave Page" , 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 > 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 >> >> ------------------------------ >> *From: *"Murtuza Zabuawala" >> *To: *"Đỗ Ngọc Trí Cường" >> *Cc: *"Dave Page" , 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_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 > > 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 >>> >>> ------------------------------ >>> *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 >>> >>> >> >