Toad World® Forums

SFTP/SSH session for Trace file browser in Toad 10.1


#1

Hi all,

I am having difficulty in connecting via ssh/sftp in toad 10.1 trace file
browser functionality.

I am getting following error

“Logon to serverXXXX:22 as oracle failed: Authentication (keyboard) failure.”

Saurabh


#2

Saurabh,

This is the response we’re getting back from your SFTP server. How do you
normally SFTP into that server?

Greg


#3

Hi Greg,

thanks for getting back on this.

I use PUTTY for normal ssh session to Oracle RDBMS server. So far i haven’t
tried sftp to box.

Saurabh


#4

Morning Saurabh,

I use PUTTY for normal ssh session to Oracle RDBMS server.
So far i haven’t tried sftp to box.

Ok, Putty is your problem. I use it here as well and I can’t sftp from
within Toad to any box that I can Putty to. The problem is Windows &
Putty storing the server signature in the registry rather than in a .ssh
directory as a file named known_hosts.

If you need to use the Putty keys then you need to use the Putty
supplied version of SFTP as well, it’s called psftp and should be found
in the same folder as your putty executable.

Of course, if you want to login to the oracle user then unless you want
to type the password each time, you need to generate a key for yourself

  • putty keygen - then copy the public part of the key over to the
    appropriate server and in the oracle account, create a .ssh directory
    and append your key to a file names ‘authorized_keys2’.

Then you need to set the permissions on .ssh to RWX for owner and
nothing for everyone else. The file(s) in .ssh are owner RW.

Once this is all done, you need to run pagent in your task tray, right
click it and add key. The key you add is the one you saved earlier but
this time, it’s your private key.

Unfortunately, none of this will let you work with sftp from within Toad
I’m afraid. You need to do it “properly” and none of this new fangled
non-standard Windows stuff! :wink:

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#5

Good Morning Norm,

Thanks for helping me.

what i want to achieve is not the sftp session through toad but ssh2 session,
(and yes we do not use public/private key for login to server)

I wanted to ssh from toad to browse trace files of oracle server instead of
copying it to local desktop and then parsing through toad’s trace file browser.

it seem like this can not be done correct ?

let me know if i misunderstood anything.

Saurabh


#6

You’re going to have to get the file down if you want to use the Trace
File browser, no way to read it directly off the server via Toad

If you have a copy of Spotlight, it can read the trace files directly from the
server…


#7

Jeff, the Trace File Browser has a button on it to open Toad’s FTP window.


#8

#9

My point exactly – they have to ftp the file down, one way or another.


#10

Forwards or backwards, you can generally assume John will be right more times
than I J


#11

Yes – because Jeff went to WVU J


#12

As did former President of Oracle, Ray Lane. He seemed to do all right for
himself J


#13

Thanks all for helping me through this.

Saurabh