tPOP usage

One Star

tPOP usage

I'm trying to use tPOP compoment to retrieve emails from a Novell-Groupwise system
After having setup all necessary data (host,port, user,pwd,etc..) , if I run the job it remains running with no way to know what is doing and if there are any issue
Is the component working or has some bugs ?
How else could I retrieve emails ?
Community Manager

Re: tPOP usage

Hello
Which type of email do you use? Which version of TOS?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tPOP usage

TOS 3.0.0
Novell Groupwise 6.5.7
One Star

Re: tPOP usage

I'm trying to use IMAP protocol....
One Star

Re: tPOP usage

I've seen that thare was a bug but now resolved
I've downloaded the zip archive of the files changed in the component tPOP and I've overwritten previous files
Now I get the following error
Exception in component tPOP_1
javax.mail.MessagingException: Connect failed;
nested exception is:
java.io.IOException: Unexpected response: * OK GroupWise Server Ready
at com.sun.mail.pop3.POP3Store.protocolConnect(POP3Store.java:148)
at javax.mail.Service.connect(Service.java:275)
at cegedim.insert_update_cegedim_sugar_0_1.insert_update_cegedim_sugar.tPOP_1Process(insert_update_cegedim_sugar.java:175)
at cegedim.insert_update_cegedim_sugar_0_1.insert_update_cegedim_sugar.runJobInTOS(insert_update_cegedim_sugar.java:373)
at cegedim.insert_update_cegedim_sugar_0_1.insert_update_cegedim_sugar.main(insert_update_cegedim_sugar.java:287)
Caused by: java.io.IOException: Unexpected response: * OK GroupWise Server Ready
at com.sun.mail.pop3.Protocol.simpleCommand(Protocol.java:361)
at com.sun.mail.pop3.Protocol.<init>(Protocol.java:91)
at com.sun.mail.pop3.POP3Store.getPort(POP3Store.java:201)
at com.sun.mail.pop3.POP3Store.protocolConnect(POP3Store.java:144)
... 4 more
One Star

Re: tPOP usage

latest tentative....
I missed to select imap in the new dropdown of the component !
But now I get the following error message
Exception in component tPOP_1
java.io.IOException: No content
at com.sun.mail.imap.IMAPInputStream.fill(IMAPInputStream.java:111)
at com.sun.mail.imap.IMAPInputStream.read(IMAPInputStream.java:158)
at cegedim.insert_update_cegedim_sugar_0_1.insert_update_cegedim_sugar.tPOP_1Process(insert_update_cegedim_sugar.java:209)
at cegedim.insert_update_cegedim_sugar_0_1.insert_update_cegedim_sugar.runJobInTOS(insert_update_cegedim_sugar.java:366)
at cegedim.insert_update_cegedim_sugar_0_1.insert_update_cegedim_sugar.main(insert_update_cegedim_sugar.java:280)
One Star

Re: tPOP usage

I'm trying to debug the problem and I've used the debugger
I end up with a File Not found exception "\C:\Program Files\Java\jre1.6.0_05\lib\sunrsasign.jar"
I cannot find the specified file
What I can do to solve this problem ?
Is it the correct cause of the error "java.io.IOException: No content" ?
One Star

Re: tPOP usage

I TRY TO use tpop to recover mail , but the file result doesn't contains the mail content but information about mail, IP adress , receiver , sender....
How I can recover only content of mail ?
any idea please.
Community Manager

Re: tPOP usage

Hello raja
After you featch the email form server and save it on local machine, then use a tFileInputMail to extrac data from the file, contains body, subject etc...
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tPOP usage

Hi , please in the file result of execution of tpop
body of mail don't apper
what i do i need the body ?
Is have reklated of some fnt in code or there are a error ?
pleeeeese help me it is so urgent
thanks
One Star

Re: tPOP usage

my result of execution:
Exception in component tPOP_1
java.io.IOException: error fetching POP3 content
at javax.mail.internet.MimePartDataSource.getInputStream(MimePartDataSource.java:106)
at javax.activation.DataHandler.getInputStream(Unknown Source)
at javax.mail.internet.MimeMessage.getInputStream(MimeMessage.java:1277)
at test.pop_0_1.pop.tPOP_1Process(pop.java:243)
at test.pop_0_1.pop.runJobInTOS(pop.java:628)
at test.pop_0_1.pop.main(pop.java:547)
Job pop terminé à 13:48 21/08/2009.
but the result don't content the body of mail
One Star

Re: tPOP usage

IF someone can help me i would to have such result the body of mail .
One Star

Re: tPOP usage

Hi, this my resut of execution when i use tpop
Exception in component tPOP_1
java.io.IOException: error fetching POP3 content
at javax.mail.internet.MimePartDataSource.getInputStream(MimePartDataSource.java:106)
at javax.activation.DataHandler.getInputStream(Unknown Source)
at javax.mail.internet.MimeMessage.getInputStream(MimeMessage.java:1277)
at test.tpop_0_1.tpop.tPOP_1Process(tpop.java:238)
at test.tpop_0_1.tpop.runJobInTOS(tpop.java:404)
at test.tpop_0_1.tpop.main(tpop.java:323)
Job tpop terminé à 23:48 22/08/2009.
How can i solve it?
Community Manager

Re: tPOP usage

Hi raja
Can you upload some screenshots of your job?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tPOP usage

hi, ok sure, first t try to use only tpop compent, but it doesn't works,
it exist eror in fetch content,
The 2 picture show, the code error and the conficuration of tpop compent,

Please any help
One Star

Re: tPOP usage

my job how i would to realise is this:
Six Stars

Re: tPOP usage

The configuration is correct.
I can only suggest to:
- check connectivity
- download and use the last version of open talend ( 3.2 )
- download and use the last version of java
One Star

Re: tPOP usage

Hi, I try the last version of talend, also java ,but the same error appear:
Démarrage du jobpop a 10:40 25/08/2009.
connecting to socket on port 3340
connected
Exception in component tPOP_1
java.io.IOException: error fetching POP3 content
at javax.mail.internet.MimePartDataSource.getInputStream(MimePartDataSource.java:106)
at javax.activation.DataHandler.getInputStream(Unknown Source)
at javax.mail.internet.MimeMessage.getInputStream(MimeMessage.java:1277)
at testpop.pop_0_1.pop.tPOP_1Process(pop.java:241)
at testpop.pop_0_1.pop.runJobInTOS(pop.java:415)
at testpop.pop_0_1.pop.main(pop.java:326)
disconnected
Job pop terminé à 10:40 25/08/2009.

Any help please , I need that this copenent work correctly .
One Star

Re: tPOP usage

Regarding----> File Not found exception "\C:\Program Files\Java\jre1.6.0_05\lib\sunrsasign.jar"
Try ----> "C:\\Program Files\\Java\\jre1.6.0_05\\lib\\sunrsasign.jar"

Regards,
Anish
Six Stars

Re: tPOP usage

I've used your server parameters and Talend connects ok and retrieve the mail...
Sincerely, I don't what to say... It can be all...
- disable maybe some crappy antivirus that disrupt the communication channel
- update java mail components to last version in classpath
- check the communication exchanged with Wireshark and post in in the forum
- .......
One Star

Re: tPOP usage

Hi , i update java, my antivirus is NODE32,
This is my wireshark test of network.
Please I need help, that tpop work correctly is very important for my project.
Six Stars

Re: tPOP usage

- try on another machine ( new installation of talend )
- assure that you have unzipped all the talend installation correctly ( not with the system zip, but with 7zip )
- disable the antivirus
- attach the file in the forum of the full payload pcap trace of wireshark
- look with procmon which version of java jar gets loaded and which file is written and post the procmon trace on forum
...
One Star

Re: tPOP usage

Hi,
I try new instalation of talend which I unzipped it with 7zip, I can't attach full payload pcap of wireshark because of size max is 200KO and only picture.
I use procmon , this is the capture ecran of it and wiresharck one.
Please any help
Six Stars

Re: tPOP usage

Can't help with only images... sorry... we must have the full traces when you run the job.
Anyway, have you tried on another machine?
One Star

Re: tPOP usage

I have all the file but i can't post it in the forum because of size:

Yes I try it and this is the result:
Démarrage du jobpop a 13:42 28/08/2009.
connecting to socket on port 3924
connected
Exception in component tPOP_1
java.io.IOException: java.io.EOFException: EOF on socket
at javax.mail.internet.MimePartDataSource.getInputStream(MimePartDataSource.java:106)
at javax.activation.DataHandler.getInputStream(Unknown Source)
at javax.mail.internet.MimeMessage.getInputStream(MimeMessage.java:1277)
at test.pop_0_1.pop.tPOP_1Process(pop.java:241)
at test.pop_0_1.pop.runJobInTOS(pop.java:414)
at test.pop_0_1.pop.main(pop.java:326)
disconnected
Job pop terminé à 13:43 28/08/2009.
Six Stars

Re: tPOP usage

This should indicate connectivity problem...
are you sure that you have disable all the antivirus and firewalls?
One Star

Re: tPOP usage

hi , can I send you the files with mail , if you haven't problem?
thank you
Six Stars

Re: tPOP usage

I repeat, it is CLEAR a network communication problem, no doubt about that.
Do you see in the wireshark screencapture the red line after the RETR command???
RETR is used to retrieve the message and just after that the communication channel is prematurely shut down ( so the message body is not retrieved and EOFException rise in the java stack because the tcp/ip socket is abruptly close).
Check you software firewall (disable it), antivirus (disable it) or any equipment before you and the internet ( sometimes some cheapo router/firewall/av/all-in-one are very crappy and do weird things on channels).
One Star

Re: tPOP usage

Hi , try all , i disabele firewall and antivirus but the same error appear :
Démarrage du jobtestpop a 12:23 29/08/2009.
connecting to socket on port 4306
connected
Exception in component tPOP_1
java.io.IOException: error fetching POP3 content
at javax.mail.internet.MimePartDataSource.getInputStream(MimePartDataSource.java:106)
at javax.activation.DataHandler.getInputStream(Unknown Source)
at javax.mail.internet.MimeMessage.getInputStream(MimeMessage.java:1277)
at test.testpop_0_1.testpop.tPOP_1Process(testpop.java:242)
at test.testpop_0_1.testpop.runJobInTOS(testpop.java:416)
at test.testpop_0_1.testpop.main(testpop.java:327)
disconnected
Job testpop terminé à 12:23 29/08/2009.
what is the probleme i don't now?
Six Stars

Re: tPOP usage

Surely a network problem... the fact that you have tried on another machine on the same network proves that there is something in between that is doing strange thing to communication sockets...
maybe the firewall/internet device that allows you to share the connection..