Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Email passwords being lost again.

Email passwords being lost again. 5 months 1 week ago #65596

  • Bungle
  • Bungle's Avatar
  • Offline
  • Elite Member
  • Posts: 197
  • Thank you received: 2
  • Karma: 3
:(

I have never actually managed to make good use of the email module - but i have wrestled with smtp errors a few times and managed to get email notifications working. All good - until it stops working again, presumably its the upgrades?

At the most basic level.....

My situation now is that If i go to

Admin>Email Settings>Outgoing Mail Configuration and then set the password before clicking "Send Test Email", it works.
But if i click "Send Test Email" a second time it fails with the error "SMTP Error: Could not authenticate"

Attempting to set the password and saving the Email settings also results in the same error.

Basically the "send Test Email" only works immediately after setting the password.


i am slowly losing hope :(
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65600

  • iamreb
  • iamreb's Avatar
  • Offline
  • Senior Member
  • Posts: 48
  • Thank you received: 3
  • Karma: 0
Maybe this can help you: suitecrm.com/suitecrm/forum/suitecrm-7-0...p-credentials-stored

I've experienced the same problem and I ended up having a static SMTP credential for the outbound email as it would always fail to authenticate otherwise.
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65611

  • Bungle
  • Bungle's Avatar
  • Offline
  • Elite Member
  • Posts: 197
  • Thank you received: 2
  • Karma: 3
Hi,

By setting 'static SMTP credential' do you mean setting

$this->Password = 'password';

in the SugarPHPMailer.php file?

That seems to have worked
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65624

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
@Bungle, on which SuiteCRM version are you?

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65749

  • Bungle
  • Bungle's Avatar
  • Offline
  • Elite Member
  • Posts: 197
  • Thank you received: 2
  • Karma: 3
Version 7.10.4
Sugar Version 6.5.25 (Build 344)
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65757

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
Can you please try to check if, despite that error, the account gets properly set up, and works well?

I am just trying to get a better idea of where the bug is.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
Last Edit: 5 months 1 week ago by pgr. Reason: add sentence
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65776

  • Bungle
  • Bungle's Avatar
  • Offline
  • Elite Member
  • Posts: 197
  • Thank you received: 2
  • Karma: 3
Unfortunately it only works if i set the password in SugarPHPMailer.


The test email in Admin>Email Settings is only sent immediately after setting the password box. The second time i click 'send test email' it fails, even though i have not saved the page.

However, in 'Admin>Outgoing Email' the test email works indefinitely - until the settings are saved.
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65778

  • Bungle
  • Bungle's Avatar
  • Offline
  • Elite Member
  • Posts: 197
  • Thank you received: 2
  • Karma: 3
ahh!

Setting the password in 'Admin>Outbound Email' updates the 'mail_smtppass' for the 'system' type account in the 'outbound_email' table; to the correct value - and my workflows send email. All good.

However, setting the password in 'Admin>Email Settings' updates the same field in the table, but with an incorrect value - email stops working.

This may explain why my email stopped working - it wasn't the upgrade, email password changed and i most likely tried to update the password in Admin>Email Settings.

The error must be in the code that writes the password in the 'Admin>Email Settings' page?
Last Edit: 5 months 1 week ago by Bungle.
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65782

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
Hello. I've been trying to reproduce your Issues in my test installation of 7.10.4, but I can't.

I tried the one about sending the test email twice, but it works well both times.

I tried changing the password from the Admin / Email settings screen, but it changes the password correctly for me...

?

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65978

  • Bungle
  • Bungle's Avatar
  • Offline
  • Elite Member
  • Posts: 197
  • Thank you received: 2
  • Karma: 3
Very strange, i haven't customised any code - perhaps my instance hasn't upgraded properly at some point?

For the moment i have a workaround, though not sure how secure it is to have the password in SugarPHPMailer?
The administrator has disabled public write access.

Email passwords being lost again. 5 months 1 week ago #65986

  • iamreb
  • iamreb's Avatar
  • Offline
  • Senior Member
  • Posts: 48
  • Thank you received: 3
  • Karma: 0
You and me both on this one.

Setting the password as static should be relatively safe as long as no one has access to your codes. And who would look into a SugarPHPMailer file?

This just occurred recently for us.
The administrator has disabled public write access.

Email passwords being lost again. 5 months 6 days ago #66008

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
Both of you, please don't give up on getting to a reproducible version of this bug. We need to be 100% relentless with Email bugs, squash all of them one by one until we drive up the quality in this module. This is much needed and my main concern at the moment.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Email passwords being lost again. 5 months 6 days ago #66050

  • Bungle
  • Bungle's Avatar
  • Offline
  • Elite Member
  • Posts: 197
  • Thank you received: 2
  • Karma: 3
i don't want to give up, i just don't have the skill set to find the root of the problem. But i am more than happy to help if i can.

The help file mentions 4 types of email accounts, and one of those is outgoing email accounts. It then goes on to say that you set the default email settings in Admin>Email Settings.

However there is also a system type email account listed in Admin>Outgoing Email.

This is duplicating the way you can set the default settings and is confusing, and its also making it harder to locate the problem.

Getting rid of the Admin>Email Settings page would be the best option - leaving just one page (outgoing Email) where you setup a 'system' type account for default settings.

Now i need to find out why the personal email has stopped working too, its just saying loading in the mail settings page - then crashes the system with a proxy error? The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET /crm/index.php.

:(
The administrator has disabled public write access.

Email passwords being lost again. 5 months 6 days ago #66059

  • iamreb
  • iamreb's Avatar
  • Offline
  • Senior Member
  • Posts: 48
  • Thank you received: 3
  • Karma: 0
On the plus side, we've narrowed it down to the authentication problem. I've also noticed that multiple credentials are stored on the "outbound_email". The problem might lie on the queries that fetch the credentials to be used for the SMTP.
The administrator has disabled public write access.

Email passwords being lost again. 5 months 5 days ago #66074

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
Thanks to both of you.

@iamreb, what do you mean about the outbound_emails table? Do you get more than one row for a single account? If you can paste (obfuscated) contents of your table, I would appreciate it.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.099 seconds
Powered by Kunena Forum