Had to change mail password, now reports have stopped being mailed.

aaronmartin1651 · 2017-11-14 22:51:54

I went to Administration > File System > FileServer Root > etc > mail to click on the mail.cf file. On the Edit File tab at the bottom I edited the xml file to be as follows:

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<smtp>
<host>smtp.gmail.com</host>
<port>587</port>

<ssl>false</ssl>
<tls>
<enable>true</enable>
<require>true</require>
</tls>
<username>username@gmail.com</username>
<password>password</password>
</smtp>
<mail>
<sender>rs@datenwerke.net</sender>
<forceSender>false</forceSender>
<encryptionPolicy>allow_mixed</encryptionPolicy>
</mail>
</configuration>

I have not been able to receive mail since. I restarted all services as well as the entire server. Is there anywhere on the Linux command line I need to update? This has crippled my capabilities!

phenaut · 2017-11-16 08:27:15

Hello Guy,
I think using <sender>rs@datenwerke.net</sender> is recognize by gmail like a spam and you must have an error like 553 : we do not relay ....
This is a clue, may be ?

eduardo · 2017-11-16 11:10:59

Hi aaronmartin1651,

-do you have the working file? If yes, could you please post it so we see what exactly changed ?
-yes, as phenaut pointed out, you should try changing the "sender".
Don't forget the restart your reportserver or reload the configuration from the terminal using "config reload".

Regards,
Eduardo

aaronmartin1651 · 2017-11-16 13:44:56

phenaut wrote:

Hello Guy,
I think using <sender>rs@datenwerke.net</sender> is recognize by gmail like a spam and you must have an error like 553 : we do not relay ....
This is a clue, may be ?

It has always said this and had no problems in the past although I will certainly try this. The mail only stopped sending once I changed my gmail password.

aaronmartin1651 · 2017-11-16 13:47:04

edulid wrote:

Hi aaronmartin1651,
-do you have the working file? If yes, could you please post it so we see what exactly changed ?
-yes, as phenaut pointed out, you should try changing the "sender".
Don't forget the restart your reportserver or reload the configuration from the terminal using "config reload".
Regards,
Eduardo

Unfortunately I changed it within reportserver administration console which chows the path as a folder tree and I edited it there. When I open the terminal for the reportserver I am unable to locate the file (typed 'locate mail.cf' and linux returns no answers).

I have rebooted the reportserver with the same results.

Are there any logs I can look at to see what kind of error messages may be getting returned?

eduardo · 2017-11-21 10:23:53

Hi aaronmartin1651,

you can find the file in the internal reportserver fileserver: either in your browser: Administration -> File System or using your terminal: type CTRL+ALT+T for opening it. More information here:
https://reportserver.net/en/guides/admi … le-System/ for the file system
https://reportserver.net/en/guides/admi … /Terminal/ for the terminal.

You should check your tomcat logs, located in C:\Bitnami\reportserverenterprise-3.0.2-7\apache-tomcat\logs if you installed using bitnami or in your manual tomcat path if you installed tomcat.

You should compare the old working file and the new non-working file in order to see what changed exactly. This should give you clues of what is wrong.

Regards,
Eduardo

aaronmartin1651 · 2017-11-27 17:28:54

I am running in linux so my logs are at /opt/reportserver-3.0.2-6/apache-tomcat/logs directory.
I have reviewed logs but cannot find anything relating to mail delivery. I have already edited the mail.cf file but it is not sending even after putting the correct email address for the gmail account.re

If I go to the Scheduler section and look at details for the missed email event it gives this metadata of run:

java.lang.RuntimeException: javax.mail.AuthenticationFailedException: 535-5.7.8 Username and Password not accepted. Learn more at
535 5.7.8 https://support.google.com/mail/?p=BadCredentials l126sm6610989qkf.96 - gsmtp

at net.datenwerke.rs.scheduler.service.scheduler.mail.MailReportAction$1.handleException(MailReportAction.java:133)
at net.datenwerke.rs.core.service.mail.MailServiceImpl.sendMailSync(MailServiceImpl.java:243)
at net.datenwerke.rs.scheduler.service.scheduler.mail.MailReportAction.doExecute(MailReportAction.java:124)
at net.datenwerke.scheduler.service.scheduler.entities.AbstractAction.execute(AbstractAction.java:59)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeAction(SchedulerTask.java:495)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.executeActions(SchedulerTask.java:385)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.safeCall(SchedulerTask.java:209)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:101)
at net.datenwerke.scheduler.service.scheduler.tasks.SchedulerTask.call(SchedulerTask.java:1)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: javax.mail.AuthenticationFailedException: 535-5.7.8 Username and Password not accepted. Learn more at
535 5.7.8 https://support.google.com/mail/?p=BadCredentials l126sm6610989qkf.96 - gsmtp

at com.sun.mail.smtp.SMTPTransport$Authenticator.authenticate(SMTPTransport.java:823)
at com.sun.mail.smtp.SMTPTransport.authenticate(SMTPTransport.java:756)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:673)
at javax.mail.Service.connect(Service.java:317)
at javax.mail.Service.connect(Service.java:176)
at javax.mail.Service.connect(Service.java:125)
at javax.mail.Transport.send0(Transport.java:194)
at javax.mail.Transport.send(Transport.java:124)
at net.datenwerke.rs.core.service.mail.MailServiceImpl.sendMailSync(MailServiceImpl.java:233)
... 11 more

so based on the above message it is still providing incorrect credentials for some reason. Is there anywhere besides the mail.cf file that credentials could be stored?

edulid wrote:

Hi aaronmartin1651,
you can find the file in the internal reportserver fileserver: either in your browser: Administration -> File System or using your terminal: type CTRL+ALT+T for opening it. More information here:
https://reportserver.net/en/guides/admi … le-System/ for the file system
https://reportserver.net/en/guides/admi … /Terminal/ for the terminal.
You should check your tomcat logs, located in C:\Bitnami\reportserverenterprise-3.0.2-7\apache-tomcat\logs if you installed using bitnami or in your manual tomcat path if you installed tomcat.
You should compare the old working file and the new non-working file in order to see what changed exactly. This should give you clues of what is wrong.
Regards,
Eduardo

eduardo · 2017-11-28 08:05:47

Hi aaronmartin1651,

the response you are getting comes from google, so it seems not to be accepting your credentials.
After searching for the error you are getting, I found this: google seems to have changed the security settings required to use smtp: https://www.digitalocean.com/community/ … -gmail-com
"Google now doesn't accept login from less secure apps. So you need to go to https://myaccount.google.com/security scroll to the bottom and turn ON "Allow less secure apps: ON". Now when you add the SMTP details to "Send as" google will accept them. You need to do this for the email ID you are adding in your Send as section."

The link you are getting from google seems to confirm this:
https://support.google.com/mail/?p=BadCredentials

Not even thunderbird/outlook seem to be able to work: https://support.google.com/accounts/answer/6010255
So please change your google settings and try again.

Regards,
Eduardo

ReportServer Forum

#1 2017-11-14 22:51:54

Had to change mail password, now reports have stopped being mailed.

#2 2017-11-16 08:27:15

Re: Had to change mail password, now reports have stopped being mailed.

#3 2017-11-16 11:10:59

Re: Had to change mail password, now reports have stopped being mailed.

#4 2017-11-16 13:44:56

Re: Had to change mail password, now reports have stopped being mailed.

#5 2017-11-16 13:47:04

Re: Had to change mail password, now reports have stopped being mailed.

#6 2017-11-21 10:23:53

Re: Had to change mail password, now reports have stopped being mailed.

#7 2017-11-27 17:28:54

Re: Had to change mail password, now reports have stopped being mailed.

#8 2017-11-28 08:05:47

Re: Had to change mail password, now reports have stopped being mailed.

Board footer