FTP/SFTP plugin question

[CTzen]

Marco,

I have a question about SFTP part of the plugin. It works well if I use Password authentication, but I cannot make it work with Public key authentication.

Here is what I'm trying to achieve. My Windows logon name is Slava (of cause ). I want to connect as oracle to a Solaris box. I added my public key to oracle keyring it works fine with Putty, F-Secure and Open SSH.

So, first issue, I cannot find how to tell PL/SQL Developer that I want connect as oracle. Adding oracle@ before host name doesn't help. I assume it cannot find host in this case.

Second, what kind of private key does PL/SQL Developer understand? Putty, F-Secure, Open SSH?

 

[Marco Kalter]

I will have to get back to you about this...

 

[Marco Kalter]

The SFTP plugin supports the following private key formats:
- Putty;
- SSH2 encrypted;
- Open SSH;

We have uploaded a fixed version that allows you to specify the username:
http://www.allroundautomations.com/download/ftp206.zip

 

[CTzen]

Marco,

I'm now getting "Incorrect Login" error message. I tried couple different formats of private key.

Not sure if it helps, but I have special characters like '@' in my password.

 

[Marco Kalter]

I have emailed you with a followup.

 

[CTzen]

Thank you, Marco, it is working.

Only thing when I'm saving file back to SSH server, login dialog popups again.

 

[Marco Kalter]

Okay, we'll check it out.