We just purchased the Jasper Bi jumpbox and we are having problems with the emailing. It never asked us to set up a SMTP server during the initial setup and I can't figure out where to configure it. When we try to send out reporting via email we get this error :
The Job Failed To Execute
Job: Background Execution (ID: 3)
Report unit: /analysis/reports/FoodmartSalesMondrianReport
Quartz Job: ReportJobs.job_3
Quartz Trigger: ReportJobs.trigger_3_0
Exceptions:
An error occurred while sending job error notification.
org.springframework.mail.MailSendException; nested exceptions (0) are:
Caused by: javax.mail.MessagingException: Unknown SMTP host: mail.localhost;
nested exception is:
java.net.UnknownHostException: mail.localhost
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1280)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370)
at javax.mail.Service.connect(Service.java:275)
at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:382)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:335)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:331)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:922)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:395)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:188)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.net.UnknownHostException: mail.localhost
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:516)
at java.net.Socket.connect(Socket.java:466)
at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:232)
at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:189)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1250)
... 10 more
Anyone know how to fix this?
Jasper Bi Emailing
By default, every application installed on a JumpBox is supposed to use the local mail daemon to deliver mail. Then the JumpBox can be configured to use a mail relay at the system level, if needed:
http://wiki.jumpbox.com/doc/runtime/faq/configure_email_relaying
However, this error makes it look like the JumpBox is trying to deliver email through the host mail.localhost. If thats the case, then it is a misconfiguration. I will file a ticket to have that looked at. In the meantime, you might be able to trick it by editing the /etc/hosts file on the JumpBox and add 'mail.localhost' at the end of the 127.0.0.1 line, then restart the JumpBox (or at least Jasper BI, and probably postfix).
Austin
Email Account
One more quick question. As is, it is sending from admin@localhost. How do I change that to display a different email address?
Thanks
Thanks for the help. It seems that configuring the relay host properly and adding the mail.localhost to the hosts file has fixed the issue.