Customer Portal

Scheduling a mail

Comments 12

  • Avatar
    admin
    0
    Comment actions Permalink
    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.
  • Avatar
    swathi shankar
    0
    Comment actions Permalink
    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
  • Avatar
    admin
    0
    Comment actions Permalink
    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
  • Avatar
    swathi shankar
    0
    Comment actions Permalink
    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
  • Avatar
    admin
    0
    Comment actions Permalink
    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.
  • Avatar
    swathi shankar
    0
    Comment actions Permalink
    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)
  • Avatar
    admin
    0
    Comment actions Permalink
    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.
  • Avatar
    swathi shankar
    0
    Comment actions Permalink
    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
  • Avatar
    admin
    0
    Comment actions Permalink
    What version of Server do you use?

    Try to use parameter sets mentioned here: http://stackoverflow.com/questions/3860 ... oogle-apps
  • Avatar
    swathi shankar
    0
    Comment actions Permalink
    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
  • Avatar
    swathi shankar
    0
    Comment actions Permalink
    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
  • Avatar
    admin
    0
    Comment actions Permalink
    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.