[Can't EMail Reports from Jasper Server on AWS]

OUR FINAL FIX:  

1. Installed PostFix as an SMTP relay on the Jasper box
2. Configured Jasper instance in path /usr/share/tomcat7/webapps/jasperserver-pro/WEB-INF per the other links/articles here, using localhost as the mail host, protocol smtp, port 25
3. Edited js.quartz.properties: to set the correct URL for the hyperlinks sent in reporting e-mails:
    
    

   OLD: report.scheduler.web.deployment.uri=http://jasper.clipinteractive.com013:8080/jasperserver-pro [/code]

   NEW: report.scheduler.web.deployment.uri=http://jasper.clipinteractive.com/jasperserver-pro[/code]

---

I'm also documenting information we received from JasperSoft here for the sake of others who may be working on this issue.  Note that none of this resolved the issue for us.  We have multiple other AWS-hosted servers successfully emailing, some via our own exchange servers and some via Gmail.  This turnkey Jasper server is the only one that could not successfully send email out, so I disagree with the statement below that the issue is not related to Jaspersoft but rather to the AWS environment.  I think it is something unique about the way the Jasper servers are set up in AWS.  With that caveat, here are the recommended points from Jaspersoft:

As the the problem with your JRS not communicating with your Email Server - please make sure they are on the same VCP and security group within AWS - this issues is not related to the Jaspersoft Server but the AWS environment.   If your email server is in your own domain - you could purchase a VPN from amazon - or you could just spin up a email server on AWS in the same VCP and security group and use it just for communications from Jaspersoft

Scheduling via Gmail should work. Connections have to be checked at both JRS instance and network levels and ensured that no traffic is being blocked to access Gmail (and corresponding default ports used by Gmail)

Make sure that connections can be made at both 

  • JRS Instance level (Security Group / Route Table): eg, from traffic outside of VPC ("0.0.0.0"), send to the gateway

  • Network level (Network ACL)

 

[Can't EMail Reports from Jasper Server on AWS]

Thanks for the ideas - We've tried both SMTPS (465) and port 25, and still receive the same error message as before. Anything else to try?

[Can't EMail Reports from Jasper Server on AWS]

Thanks for the ideas - We've tried both SMTPS (465) and port 25, and still receive the same error message as before. Any other ideas?

[Can't EMail Reports from Jasper Server on AWS]

We have an AWS JasperServer instance, but cannot get report emailing to work successfully.  We've searched this forum and StackOverflow and tried many different combinations of options.  The gmail account is used by our other servers to send outgoing mail, so we know the account setup is correctly.  (The submission form spam filter is rejecting my post so I'm going to start trimming content.  If something seems to be missing that is important, let me know).

Any pointers would be appreciated.

CONFIGURATION

/usr/share/tomcat7/webapps/jasperserver-pro/WEB-INF/js.quartz.properties

report.scheduler.web.deployment.uri=http://localhost/jasperserver-pro

 

report.scheduler.mail.sender.host=smtp.gmail.com

report.scheduler.mail.sender.username=username@gmail.com

report.scheduler.mail.sender.password=mypassword

report.scheduler.mail.sender.from=username@gmail.com

report.scheduler.mail.sender.protocol=smtp

report.scheduler.mail.sender.port=587

 

/usr/share/tomcat7/webapps/jasperserver-pro/WEB-INF/applicationContext-report-scheduling.xml 

        <property name="host" value="${report.scheduler.mail.sender.host}"/>

        <property name="username" value="${report.scheduler.mail.sender.username}"/>

        <property name="password" value="${report.scheduler.mail.sender.password}"/>

        <property name="protocol" value="${report.scheduler.mail.sender.protocol}"/>

        <property name="port" value="${report.scheduler.mail.sender.port}"/>

        <property name="javaMailProperties">

            <props>

                <prop key="mail.smtp.auth">true</prop>

                <prop key="mail.smtp.starttls.enable">true</prop>

                <prop key="mail.smtp.starttls.required">true</prop>  <!-- Tried with and without this line -->

            </props>

        </property>

 

Port 587:

2014-08-12 17:46:47,862 ERROR ReportExecutionJob,quartzScheduler_Worker-1:311 - The job error notification was not completed. An error occurred while sending it.

org.springframework.mail.MailSendException: Mail server connection failed; nested exception is javax.mail.MessagingException: Can't send command to SMTP host;

  nested exception is:

        javax.net.ssl.SSLException: Server key. Failed messages: javax.mail.MessagingException: Can't send command to SMTP host;

  nested exception is:

        javax.net.ssl.SSLException: Server key; message exception details (1) are:

Failed message 1:

javax.mail.MessagingException: Can't send command to SMTP host;

  nested exception is:

        javax.net.ssl.SSLException: Server key

        at com.sun.mail.smtp.SMTPTransport.sendCommand(SMTPTransport.java:1420)

<snip>

Caused by: javax.net.ssl.SSLException: Server key

        at sun.security.ssl.Handshaker.throwSSLException(Handshaker.java:1202)

<snip>

        at com.sun.mail.smtp.SMTPTransport.sendCommand(SMTPTransport.java:1418)

        ... 14 more

Caused by: java.security.spec.InvalidKeySpecException: key spec not recognised

        at org.bouncycastle.jcajce.provider.asymmetric.util.BaseKeyFactorySpi.engineGeneratePublic(Unknown Source)

        at org.bouncycastle.jcajce.provider.asymmetric.ec.KeyFactorySpi.engineGeneratePublic(Unknown Source)

        at java.security.KeyFactory.generatePublic(KeyFactory.java:334)

        at sun.security.ssl.HandshakeMessage$ECDH_ServerKeyExchange.<init>(HandshakeMessage.java:1057)

        at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:218)

        ... 24 more

 

 

 

-------------------------

Port 465:

2014-08-12 17:54:44,413 ERROR ReportExecutionJob,quartzScheduler_Worker-1:311 - The job error notification was not completed. An error occurred while sending it.

org.springframework.mail.MailSendException: Mail server connection failed; nested exception is javax.mail.MessagingException: Exception reading response;

  nested exception is:

        javax.net.ssl.SSLException: Server key. Failed messages: javax.mail.MessagingException: Exception reading response;

  nested exception is:

        javax.net.ssl.SSLException: Server key; message exception details (1) are:

Failed message 1:

javax.mail.MessagingException: Exception reading response;

  nested exception is:

        javax.net.ssl.SSLException: Server key