SSH Auth Binary Account

#1

Do you have any example of creating SSH Auth account to be used in file writer snap? Here is the error message - Please ensure private key is in OpenSSH key file format.

Any help is appreciated here.

#2

@Ksivagurunathan, here is a generic document I put together for my team for creating SSH key pairs. Someone on this forum may have a better approach. However, see step #10 to ensure you get an OpenSSH format.

#3

Thanks for quick response. amn’t able to see any document attached. can you please attach it again

#4

Funny, just staring at the document doesn’t actually attach it! :slight_smile:
Here it is… Generate SSH Key Pair (1).docx (41.6 KB)

#5

Thank you for the document, now I see a following error -

Resolution:
Check for URL syntax and file access permission

I can access the sftp servers from winscp and write files on to it.

Any good debugging points here ?

#6
  • make sure your file format in the file writer is something like sftp://{hostname}/{path}/{filename}
  • also, make sure your node IP addresses are white-listed at the destination and no firewall blocks
#7

Thanks, that is what I suspected. Let me do follow up with my IT team.

#8

Sorry for asking a question in your thread but I am trying to enable SSH Tunneling in MySQL Account. I have host name, username and a private rsa key (want to use as key-file). I have tried various options like using rsa private key directly and .pem key. Nothing is working, any suggestion will be highly appreciated.

#9

Currently we aren’t using MYSQL in our project. but do you think you don’t have enough information in this link - https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438790/MySQL+Account

#10

Thanks @Ksivagurunathan for the link and Yeah I have already been through that information but it doesn’t relate to rsa private key. I just have rsa private key to enable this tunnel. I am able to make this tunnel using puTTY by creating a private key in .ppk format using given rsa private key with help of puTTYgen. It’s just I am trying to figure out any way of doing it through MySQL account in SnapLogic.