Hello,

This is probably in the wrong forum, but it seems like more of a networking question than anything.

I'm using SSH to access a sandbox on a client's server. They left a gz file in my userdir containing an SQL dump of a database I need to review.

They have around 27 IPs designated for dev servers and I can tunnel to these fine pointing say localhost:8080 to 192.168.1.x:80 where x is the dev server I want to see.

My account's on the primary server and I don't have a webdir set up. If I create a public_html folder I don't have the permissions to set it to unknown and I'm denied access via HTTP to localhost:8080/~username/.

SFTP and FTP are not running... so I'm kind of at a loss as to how I'm supposed to get this file. I don't have anybody to contact and I want to get some work done tonight so I thought I would ask some of the gurus if I'm missing something obvious here!

Any advice on how to grab that file would be great. Oh, and it is 100MB+ uncompressed so unfortunately I can't just copy/paste the SQL from my
terminal.

I am on Win XP using PuTTY, and it's actually a FreeBSD server IIRC.

Thanks very much in advance.

sftp is included in sshd. if you can ssh into a machine, you should be able to sftp into it also.

I've used putty but don't remember if it has file receive, I think it does. Take a look in the menu and see if it has something like "receive Zmodem", "receive kermit", etc...
I'll give you two examples.

Assume here that your putty has "receive zmodem".
First while connected to the remote computer, type in the ssh terminal the command "sz yourfile.gz", then in putty activate "receive zmodem".

If the remote computer does not have sz, but does have kermit installed, then start kermit on the remote computer, type "fast" command and hit enter followed by the "send yourfile.gz". Then in putty start the "receive kermit".

If all else fails, you could uuencode the .gz file, cat it to stdout, and use putty to capture the console text to a file. Then after the cat is complete you can hand edit the capture file to remove the leading and trailing junk and uudecode the .gz file back out. I hope you don't have to do that, but it does work.

if you have a *nix box that has sshd enabled, after you ssh into that box you can do
'scp /home/username/fileyouneed.gz hostnameofyourbox:/whereyouwanttoputit'
it will prompt you for your ssh password and after that it should transfer to your sshd enabled box

Putty comes with an utility called pscp.exe, if you don't have it check out the Putty website.
you execute something like:

pscp user@server:/path/to/file .

Thank you all very much for your response.

slackwaregeek, you're right SFTP was running I was just being numb. I actually grabbed WinSCP and had the file in no time!

I snagged pscp as well and I'm going to figure that one out.

Thanks again.