Connecting To SFTP with Private Key

dtaylor

• April 08, 2014 00:00

• Answered

Follow

I'm trying to set up a connection to an SFTP server with a private key, but I can't figure out how to set up the connection. I know what I want to do should be possible per the CloverETL documentation, but there are no instructions in the documentation on what that URL should look like. We're currently on CloverETL 3.5.0.

• 

  dtaylor

  • May 22, 2014 19:12

  0

  Comment actions Permalink

  Are you sure CloverETL Server really accepted your setting and used the correct version of Java? Could you please copy+paste and post the value you see in Configuration -> System Info -> System properties -> java.home?

  
  
  C:\Program Files\Java\jdk1.7.0_55\jre
  
  

  And the other important thing, is your keystore set correctly in CloverETL Server configuration? Could you please post (without passwords) also your certificate setting for both CloverETL Designer and CloverETL Server and the value of Configuration -> System Info -> JVM -> Input arguments passed to the Java virtual machine?

  
  Where would I find the keystore setting and the certificate setting?
  
  Input Arguments:
  

  [-Dcatalina.base=C:\apache-tomcat-6.0.35, -Dcatalina.home=C:\apache-tomcat-6.0.35, -Djava.endorsed.dirs=C:\apache-tomcat-6.0.35\endorsed, -Djava.io.tmpdir=E:\sgi-dev\tomcat_tmp, -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager, -Djava.util.logging.config.file=C:\apache-tomcat-6.0.35\conf\logging.properties , -XX:MaxPermSize=512m, -Dverbose:gc , -XX:MaxDirectMemorySize=256m, -Dcom.sun.management.jmxremote, -Dcom.sun.management.jmxremote.port=8080, -Dcom.sun.management.jmxremote.ssl=false, -Dcom.sun.management.jmxremote.authenticate=false, -Djava.rmi.server.hostname=<Removed IP Address>, -XX:+UseConcMarkSweepGC, -XX:+CMSClassUnloadingEnabled, -XX:+CMSPermGenSweepingEnabled, -Xms128m, -Xmx6144m]

• 

  slechtaj

  • May 26, 2014 14:34

  0

  Comment actions Permalink

  Hi DTaylor,
  
  Thank you for the information. We have added some extra logging into the library, so now we will get more information that should help us finding the cause. In order to update reach this, I would like to do the following steps:
  Replace JSch library (jsch-0.1.50.jar) from your CloverETL Server installation with the attached jar file. The library is located under <TOMCAT_HOME>/webapps/clover/WEB-INF/lib/
  Restart your Tomcat server.
  Run attached EnableJSchLoggingFixed.grf
  Run your graph in DEBUG mode.
  After you run the graph, please share the resulting log with us.
  
  Thanks

  • Update.zip
• 

  dtaylor

  • July 24, 2014 13:34

  0

  Comment actions Permalink

  This has been resolved and I'll own up to my idiocy. Somehow an extra character had made it's way into the parameter I use for the address. This extra character was on the username (an asterisk for the curious) and I overlooked it repeatedly whenever I looked at it. Thanks for your help.
• 

  sammy66

  • July 30, 2014 11:59

  0

  Comment actions Permalink

  I don't know how to get the stack trace. I get this error when trying to validate the connection during connection setup. It tells me it couldn't connect and lists that exception as the reason. But that's all it says, it doesn't actually present me with a stack trace.
• 

  dtaylor

  • July 30, 2014 12:56

  0

  Comment actions Permalink

  Earlier in the thread, they determined that there is actually a bug when trying to use connection setup to test a connection with a private key.

Please sign in to leave a comment.