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 Jaroslav Kubos,
Am not able to find that file CloverServer.properties. I have installed a stand alone tomcat to run cloverETL server. Where can i find it ? Is there any work around for my situation.
Thanks,
Swathi -
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 -
Hi,
I tried the way u suggested its not helpin me out.
We are using tomcat 6 server and endeca server being 7.4.0
Thanks,
Swathi -
Hi,
Am using apache tomcat 6.0 server to run cloverETL server.
I tried the same parameters but stil getting the same error as
Must issue STARTTLS command first
Can anyone help me regarding this ?
Thanks,
Swathi -
Hi Swathi,
We tested it and unfortunately gmail access is working since 3.4M1 version. Your Data Integrator Server does contain older release and therefore it is not possible to use gmail.
We are sorry for any inconveniences.
Please sign in to leave a comment.
Comments 12