i want to schedule a mail when particular scheduled graph finishes with status FINISHED_OK. i ve created a event listener for sending a mail. But am getting an error saying smtp host localhost not found and port issues.
where do i need to set these values ?
is there anyway i can send reports to people on weekly basis to give the updated value to concerned ppl after i run my incremental load using scheduler.
Thanks,
Swathi
where do i need to set these values ?
is there anyway i can send reports to people on weekly basis to give the updated value to concerned ppl after i run my incremental load using scheduler.
Thanks,
Swathi
-
Hi Swathi,
Please define server properties with prefix "clover.smtp". List is available here http://doc.cloveretl.com/documentation/ ... rties.html Here is described how to set this properties: http://doc.cloveretl.com/documentation/ ... urces.html
Regarding second question: What about store results you want to send into file. Then prepare scheduled task which will read this file and send mail every week. -
Hi Swathi,
You should change file mentioned in one link I sent you: http://doc.cloveretl.com/documentation/ ... urces.html
[tomcat_home]/conf/Catalina/localhost/clover.xml -
Hi Jaroslav Kubos,
i changed the context.xml to this..but the xml file is not showing any content when opened in IE. is there some format problem ? Pls let me know how to solve this .
<?xml version="1.0" encoding="UTF-8"?><Context path="/clover" crossContext="true"><Resource name="mail/MailSession" auth="Container"type="javax.mail.Session" clover.smtp.transport.protocol="smtp" clover.smtp.host="smtp.gmail.com" clover.smtp.port="587"
clover.smtp.authentication="true" clover.smtp.username="fcs1337@gmail.com" clover.smtp.password="pwd" mail.smtp.socketFactory.class="javax.net.ssl.SSLSocketFactory"
/> <Manager pathname=""/></Context>
Thanks,
Swathi -
Hi,
please change *[tomcat_home]/conf/Catalina/localhost/clover.xml* and NOT "context.xml"
Also according to documentation, correct code in clover.xml is:
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/clover" crossContext="true">
<Parameter name="clover.smtp.transport.protocol" value="smtp" override="false" />
<Parameter name="clover.smtp.host" value="smtp.gmail.com" override="false" />
<Parameter name="clover.smtp.port" value="587" override="false" />
<Parameter name="clover.smtp.authentication" value="true" override="false" />
<Parameter name="clover.smtp.username" value="fcs1337@gmail.com" override="false" />
<Parameter name="clover.smtp.password" value="pwd" override="false" />
<Manager pathname=""/>
</Context>
I hope this helps. -
Hi Jaroslav Kubos,
Thanks for guidance. I tried the way you suggested am getting the following error. So i changed the context.xml as
<Parameter name="clover.smtp.starttls" value="true" override="false" />
But its not helpin me. following is the error:
: 530 5.7.0 Must issue a STARTTLS command first. s8sm921276wif.9 - gsmtp
at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1668)
at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1207)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:735)
at com.cloveretl.server.f.f.process(Unknown Source)
at com.cloveretl.server.events.a.e.doProcess(Unknown Source)
at com.cloveretl.server.events.a.e.process(Unknown Source)
at com.cloveretl.server.events.a.g.a(Unknown Source)
at com.cloveretl.server.events.a.g.notifyListener(Unknown Source)
at com.cloveretl.server.events.ServerEventNotificator$NotifyListenerTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source) -
Hi,
as documentation says http://doc.cloveretl.com/documentation/ ... rties.html , extra SMTP parameters may be passed with "clover.smtp.additional.*" prefix. In your case:
<Parameter name="clover.smtp.additional.starttls" value="true" override="false" />
I hope this helps. -
Hi,
Its not helping me in anyway. Still getting the same error as previous one. how can i proceed ?
error-----------------------------
com.sun.mail.smtp.SMTPSendFailedException: 530 5.7.0 Must issue a STARTTLS command first. k7sm42686208een.8 - gsmtp
at com.sun.mail.smtp.SMTPTransport.issueSendCommand(SMTPTransport.java:1668)
at com.sun.mail.smtp.SMTPTransport.mailFrom(SMTPTransport.java:1207)
at com.sun.mail.smtp.SMTPTransport.sendMessage(SMTPTransport.java:735)
at com.cloveretl.server.f.f.process(Unknown Source)
at com.cloveretl.server.events.a.e.doProcess(Unknown Source)
at com.cloveretl.server.events.a.e.process(Unknown Source)
at com.cloveretl.server.events.a.g.a(Unknown Source)
at com.cloveretl.server.events.a.g.notifyListener(Unknown Source)
at com.cloveretl.server.events.ServerEventNotificator$NotifyListenerTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
-------------------------------------------------------------------------------------
thanks,
Swathi -
What version of Server do you use?
Try to use parameter sets mentioned here: http://stackoverflow.com/questions/3860 ... oogle-apps
Please sign in to leave a comment.
Comments 12