Discussion :

[sasafca]

Bonjour à tous,

Je souhaite déposer un fichier sur un serveur via SFTP et Talend.
Le serveur fonctionne bien via FileZila mais avec Talend (version 6.1.1.20151214_1327) impossible d'établir la connexion.
J'ai essayé pas mal de truc genre ces deux solutions, essayé aussi avec le composant tFTPClose :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
 
put this in the port text box.
context.SFTP_PORT); session_tFTPConnection_1.setConfig("PreferredAuthentications","publickey,keyboard-interactive,password"
It worked .
Thanks Alot.
 
-I tried one more solution,
I downloaded latest jsch.jar and renamed it to jsch-0.1.51 and put it in talend_directory\configuration\lib\java
this solution also worked for me.
 
Thanks,
Pankaj

Mais j'ai toujours la même erreur time-out sur le composant de connexion...

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
Exception in component tFTPConnection_1
com.jcraft.jsch.JSchException: java.net.ConnectException: Connection timed out: connect
	at com.jcraft.jsch.Util.createSocket(Util.java:349)
	at com.jcraft.jsch.Session.connect(Session.java:215)
	at com.jcraft.jsch.Session.connect(Session.java:183)
	at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.tFTPConnection_1Process(ImportToEloquaPicklist.java:2076)
	at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.tMSSqlInput_5Process(ImportToEloquaPicklist.java:1843)
	at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.tWarn_1Process(ImportToEloquaPicklist.java:791)
	at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.runJobInTOS(ImportToEloquaPicklist.java:3031)
	at efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist.runJob(ImportToEloquaPicklist.java:2725)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_12Process(Copy_of_Talend_Eloqua_13.java:8279)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_10Process(Copy_of_Talend_Eloqua_13.java:7875)
[FATAL]: efrontechdev.importtoeloquapicklist_0_1.ImportToEloquaPicklist - tFTPConnection_1 java.net.ConnectException: Connection timed out: connect
[FATAL]: efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13 - tRunJob_12 Child job running failed
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_11Process(Copy_of_Talend_Eloqua_13.java:7720)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_6Process(Copy_of_Talend_Eloqua_13.java:7275)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_5Process(Copy_of_Talend_Eloqua_13.java:6817)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_4Process(Copy_of_Talend_Eloqua_13.java:6358)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_9Process(Copy_of_Talend_Eloqua_13.java:5894)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tSleep_1Process(Copy_of_Talend_Eloqua_13.java:5760)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_8Process(Copy_of_Talend_Eloqua_13.java:5627)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_10Process(Copy_of_Talend_Eloqua_13.java:5484)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_3Process(Copy_of_Talend_Eloqua_13.java:5015)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_2Process(Copy_of_Talend_Eloqua_13.java:4548)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_1Process(Copy_of_Talend_Eloqua_13.java:4080)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_7Process(Copy_of_Talend_Eloqua_13.java:3607)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tREST_1Process(Copy_of_Talend_Eloqua_13.java:3452)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tJava_1Process(Copy_of_Talend_Eloqua_13.java:2574)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tFileList_1Process(Copy_of_Talend_Eloqua_13.java:2263)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13$4.run(Copy_of_Talend_Eloqua_13.java:14473)
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at com.jcraft.jsch.Util.createSocket(Util.java:343)
	... 25 more
Exception in component tRunJob_12
java.lang.RuntimeException: Child job running failed
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_12Process(Copy_of_Talend_Eloqua_13.java:8304)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_10Process(Copy_of_Talend_Eloqua_13.java:7875)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_11Process(Copy_of_Talend_Eloqua_13.java:7720)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_6Process(Copy_of_Talend_Eloqua_13.java:7275)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_5Process(Copy_of_Talend_Eloqua_13.java:6817)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_4Process(Copy_of_Talend_Eloqua_13.java:6358)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_9Process(Copy_of_Talend_Eloqua_13.java:5894)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tSleep_1Process(Copy_of_Talend_Eloqua_13.java:5760)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_8Process(Copy_of_Talend_Eloqua_13.java:5627)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_10Process(Copy_of_Talend_Eloqua_13.java:5484)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_3Process(Copy_of_Talend_Eloqua_13.java:5015)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_2Process(Copy_of_Talend_Eloqua_13.java:4548)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tRunJob_1Process(Copy_of_Talend_Eloqua_13.java:4080)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tWarn_7Process(Copy_of_Talend_Eloqua_13.java:3607)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tREST_1Process(Copy_of_Talend_Eloqua_13.java:3452)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tJava_1Process(Copy_of_Talend_Eloqua_13.java:2574)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13.tFileList_1Process(Copy_of_Talend_Eloqua_13.java:2263)
	at efrontechdev.copy_of_talend_eloqua_13_2_0.Copy_of_Talend_Eloqua_13$4.run(Copy_of_Talend_Eloqua_13.java:14473)

Une aide serait pas de trop s'il vous plait !

Merci

[sasafca]

Le problème venait de l'adresse IP du serveur.
Depuis la machine que j'utilisais, elle ne pouvait pas y accéder (ip public), j'ai du utilisé l'ip (privé) de ce serveur SFTP.