Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Get mail of gmail. DI

  1. #1
    Join Date
    Jan 2016
    Posts
    10

    Question Get mail of gmail. DI

    Hello everyone,
    I'm new with Pentaho, and with all the data world, so, maybe, I will still posting doubts here.
    This time I'm trying to get emails of a gmail (personal) account, but, doesnt matter what configuration I put, I cannot connect to the gmail service.
    I try with POP and IMAP, with all the ports (993, 995, 446, 463, 454), but none of the combinations success the connection step. Name:  Captura.jpg
Views: 879
Size:  26.7 KB

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    So long, and thanks for all the fish.

  3. #3
    Join Date
    Jan 2016
    Posts
    10

    Default

    Hello Marabu, thanks for your answer.
    Look at the error that Pentaho present to me, is different with imap and pop, you know why?
    Thanks.

    Name:  Captura.jpg
Views: 780
Size:  24.5 KBName:  Captura2.jpg
Views: 785
Size:  24.2 KB

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Definitely no configuration problem of your Kettle job entry.
    What is the IP address of your Kettle machine?
    Also, can you run a job with only your Get-Mail job entry (and Start of course) with Debug level logging and show your log here?
    So long, and thanks for all the fish.

  5. #5
    Join Date
    Jan 2016
    Posts
    10

    Default

    I do what you say.

    Name:  Captura.PNG
Views: 736
Size:  4.2 KB

    And the log was this

    2016/09/09 13:22:23 - Spoon - Starting job...2016/09/09 13:22:24 - PruebaMails - Start of job execution
    2016/09/09 13:22:25 - PruebaMails - Starting entry [Get Email]
    2016/09/09 13:22:26 - Get Email - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Unexpected error:
    2016/09/09 13:22:26 - Get Email - Error while connecting to host [imap.gmail.com] with username [feragon42@gmail.com] on port [993].
    2016/09/09 13:22:26 - Get Email - Connection refused: connect
    2016/09/09 13:22:26 - Get Email - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2016/09/09 13:22:26 - Get Email - Error while connecting to host [imap.gmail.com] with username [feragon42@gmail.com] on port [993].
    2016/09/09 13:22:26 - Get Email - Connection refused: connect
    2016/09/09 13:22:26 - Get Email -
    2016/09/09 13:22:26 - Get Email - at org.pentaho.di.job.entries.getpop.MailConnection.connect(MailConnection.java:317)
    2016/09/09 13:22:26 - Get Email - at org.pentaho.di.job.entries.getpop.JobEntryGetPOP.execute(JobEntryGetPOP.java:924)
    2016/09/09 13:22:26 - Get Email - at org.pentaho.di.job.Job.execute(Job.java:723)
    2016/09/09 13:22:26 - Get Email - at org.pentaho.di.job.Job.execute(Job.java:864)
    2016/09/09 13:22:26 - Get Email - at org.pentaho.di.job.Job.execute(Job.java:545)
    2016/09/09 13:22:26 - Get Email - at org.pentaho.di.job.Job.run(Job.java:435)
    2016/09/09 13:22:26 - Get Email - Caused by: javax.mail.MessagingException: Connection refused: connect;
    nested exception is:
    java.net.ConnectException: Connection refused: connect
    2016/09/09 13:22:26 - Get Email - at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:670)
    2016/09/09 13:22:26 - Get Email - at javax.mail.Service.connect(Service.java:295)
    2016/09/09 13:22:26 - Get Email - at javax.mail.Service.connect(Service.java:176)
    2016/09/09 13:22:26 - Get Email - at javax.mail.Service.connect(Service.java:125)
    2016/09/09 13:22:26 - Get Email - at org.pentaho.di.job.entries.getpop.MailConnection.connect(MailConnection.java:304)
    2016/09/09 13:22:26 - Get Email - ... 5 more
    2016/09/09 13:22:26 - Get Email - Caused by: java.net.ConnectException: Connection refused: connect
    2016/09/09 13:22:26 - Get Email - at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    2016/09/09 13:22:26 - Get Email - at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at java.net.PlainSocketImpl.connect(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at java.net.SocksSocketImpl.connect(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at java.net.Socket.connect(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at sun.security.ssl.BaseSSLSocketImpl.connect(Unknown Source)
    2016/09/09 13:22:26 - Get Email - at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:321)
    2016/09/09 13:22:26 - Get Email - at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:211)
    2016/09/09 13:22:26 - Get Email - at com.sun.mail.iap.Protocol.<init>(Protocol.java:116)
    2016/09/09 13:22:26 - Get Email - at com.sun.mail.imap.protocol.IMAPProtocol.<init>(IMAPProtocol.java:115)
    2016/09/09 13:22:26 - Get Email - at com.sun.mail.imap.IMAPStore.newIMAPProtocol(IMAPStore.java:685)
    2016/09/09 13:22:26 - Get Email - at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:636)
    2016/09/09 13:22:26 - Get Email - ... 9 more
    2016/09/09 13:22:26 - PruebaMails - Finished job entry [Get Email] (result=[false])
    2016/09/09 13:22:26 - PruebaMails - Job execution finished
    2016/09/09 13:22:27 - Spoon - Job has ended.
    I think is a permitology problem, with the firewall or something.
    Likewise, I download the mail box and try to use the .mbox instead. This time with the transformation step Email messages input.

    Name:  Captura1.jpg
Views: 765
Size:  20.4 KB

    But, when I use the preview option, Pentaho show me this:

    2016/09/09 13:22:23 - Spoon - Starting job...2016/09/09 13:22:27 - Spoon - Job has ended.
    2016/09/09 13:39:10 - C:\Users\fangonzalez\Desktop\Pentaho\trans.ktr : trans - Dispatching started for transformation [C:\Users\fangonzalez\Desktop\Pentaho\trans.ktr : trans]
    2016/09/09 13:39:10 - Email messages input.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Error opening folder 1 : java.lang.NullPointerException
    2016/09/09 13:39:10 - Email messages input.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.lang.NullPointerException
    2016/09/09 13:39:10 - Email messages input.0 - at org.pentaho.di.trans.steps.mailinput.MailInput.openNextFolder(MailInput.java:347)
    2016/09/09 13:39:10 - Email messages input.0 - at org.pentaho.di.trans.steps.mailinput.MailInput.getOneRow(MailInput.java:214)
    2016/09/09 13:39:10 - Email messages input.0 - at org.pentaho.di.trans.steps.mailinput.MailInput.processRow(MailInput.java:75)
    2016/09/09 13:39:10 - Email messages input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
    2016/09/09 13:39:10 - Email messages input.0 - at java.lang.Thread.run(Unknown Source)
    2016/09/09 13:39:10 - Email messages input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
    2016/09/09 13:39:10 - C:\Users\fangonzalez\Desktop\Pentaho\trans.ktr : trans - Transformation detected one or more steps with errors.
    2016/09/09 13:39:10 - C:\Users\fangonzalez\Desktop\Pentaho\trans.ktr : trans - Transformation is killing the other steps!

  6. #6
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Quote Originally Posted by Feragon42 View Post
    I think is a permitology problem, with the firewall or something.
    Why don't you rule out the firewall settings by using a standalone mail client on your Kettle machine?

    BTW: You didn't switch to DEBUG level logging, did you?
    So long, and thanks for all the fish.

  7. #7
    Join Date
    Jan 2016
    Posts
    10

    Default

    I think that connect directly with the mail service will be imposible in this enviroment (enterprise security things). So, I will focus in the use of the .mbox, but I still have the same problem and don't know how to solve it.
    And, no, I have the loggin level in basic.
    Thanks for your help at this point. You now what happend with the mbox error?

  8. #8
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Regarding MBOX, either don't enable "Fetch in batches" or provide the required values for batch processing (check Batch Settings on Settings tab).
    So long, and thanks for all the fish.

  9. #9
    Join Date
    Jan 2016
    Posts
    10

    Default

    Thanks for all the help Marabu.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.