Matillion,
We want to connect the vender's server via SFTP in order to grab csv files at there. However, when we try to use the data transfer component to test the connection with inputting all settings and .ppk private key, the error message 'com.jcraft.jsch.JSchException: invalid privatekey: [B@4d8e5ff5'.
BTW, we have also tested to use another open-source SSH file transfer protocol (desktop version) to connect with there, but it works.
Can you please help check this issue ? Thank you.
Best regards,
Dennis Lee
I'm not sure I have an answer to that one Dennis. You might have to raise a support ticket https://support.matillion.com/ (look for the Submit Ticket button about 1/2 way down the page once you're logged in)
Hi there - I'm also experiencing the same issue.
I generated a public/private key pair on my dev box. Then tested the SFTP connection using Filezilla. This worked.
I setup the SFTP Data Transfer component and entered the private key into the Source SFTP Key field.
When I run the component I get the same error as the OP.
My question, can I use the public/private key pair in Matillion that I generated on my dev box? Do I need to somehow install the ssh public key onto the Matillion server?
Cheers
An updated answer:
This issue happens because Matillion is expecting the RSA formatted (PEM) key not an OPENSSH key.
For example, the private key must be generated as PEM format and begins with -----BEGIN RSA PRIVATE KEY-----.
I experienced the same issue and realised I was using an OPENSSH rsa key. After I regenerated the key to be PEM format as above then the SFTP side of the Data Transfer component worked.