Report Scheduler

[ktrinad]

By: Javy Dreamer - javydreamercsw

Report Scheduler

2006-07-12 06:27

I'm still struggling with the scheduler but I think I found the reason. I'm using Gmail as SMTP server (smtp.google.com) and getting the following eror:

 

javax.mail.MessagingException: Could not connect to SMTP host: smtp.google.com,

port: 25, response: -1

at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1270)

at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:37

0)

at javax.mail.Service.connect(Service.java:275)

at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailS

enderImpl.java:373)

at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSen

derImpl.java:326)

at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSen

derImpl.java:322)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecut

ionJob.sendMailNotification(ReportExecutionJob.java:467)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecut

ionJob.sendToDestinations(ReportExecutionJob.java:290)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecut

ionJob.execute(ReportExecutionJob.java:128)

at org.quartz.core.JobRunShell.run(JobRunShell.java:195)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j

ava:520)

 

I noticed that the port 25 is used by default but Google use port 426 I think. I'll raise a feature request in a minute in order to allow for port specification thru the setting.

 

Also once you installed if you commited an error(i.e. smtp server name) there's no way to fix it besides unistalling and reinstalling. I'll raise a feature request also on this.

 

Thanks in advance...

 

 

By: Lucian Chirita - lucianc

RE: Report Scheduler

2006-07-12 06:56

Follow-up regarding the SMTP port here

https://sourceforge.net/tracker/index.php?func=detail&aid=1521193&group_id=162962&atid=825864

 

Regards,

Lucian

[kelly]

I have sending email problem too.

it always gave me the error says:

Code:

Job: test (ID: 11)
Report unit: /reports/samples/SalesByMonth
Quartz Job: ReportJobs.job_11
Quartz Trigger: ReportJobs.trigger_11_0
Mail server connection failed; nested exception is javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25;
  nested exception is:
	java.net.ConnectException: Connection refused: connect
org.springframework.mail.MailSendException; nested exceptions (0) are:
Caused by: javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25;
  nested exception is:
	java.net.ConnectException: Connection refused: connect
	at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1282)
	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:595)
	at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendToDestinations(ReportExecutionJob.java:357)
	at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:278)
	at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:148)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	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)
	... 11 more

i tried to change the js.mail.properties and add the property too. but still the same error message. is there anybody know how to fix it?

thanks in advance.

 

Best regards.

 

Kelly