Shell Programming and Scripting

I need to connect to a ftp server-1 from linux server-2 and copy/get a file from server-1 which follows a name pattern of FILENAME* (located on the root directory) and copy on a directory on server-2. Later, I have to use this file for ETL loading... For this I tried using as below

Code:

/usr/bin/ftp -n ftpsitename.com <<EOF
quote USER 12345
quote PASS 12345
cp /FILENAME* /directory_location_to/copy/on_server2/
EOF

I get the error as "?Invalid command".

Please advise if this is the right way to get the file or if there are alternative solution for grabbing the file.

Thanks
Dhruuv

if ftp knows about mkdir or cd, it certainly doesnt know cp... since it uses put, get, mput, mget
alternative would be with ssh: scp
do a man of scp to see if you have it installed and look how it is used...

Hi vbe,

I tried to use SCP as shown below

Code:

scp -P 21 username1@hostname1:/filepattern* username2@hostname2_where_copy_the_file:/directory/to/copy/the/file

I got the error

Code:

ssh: connect to host hostname1 port 22: Connection refused

Any idea on what's happening here? Even though I mentioned the port no. as 21, it's throwing me an error related to port no. 22...

However, I am able to connect to the hostname1 on 21 port using WINSCP tool and get the file onto my local windows machine... Please advise...

You should not specify a port number or certainly not 21 which is for FTP and generaly closed on secured boxes...

I have even tried to give the command without any port number, still I get the same error...

Lets start from the beginning: This server 1 is an FTP server? OK then

Code:

/usr/bin/ftp -n ftpsitename.com <<EOF
quote USER 12345
quote PASS 12345
mget /FILENAME* /directory_location_to/copy/on_server2/
EOF

Should work (we get all files FILENAME* from root of source to destination on server 2 ...)
For invalid command was cp... did not say it would not work with known ftp commands...

I put your code in a file by name, "ftp_test.sh".

Code:

cat ftp_test.sh

gives me

Code:

/usr/bin/ftp -n ftpsitename.com <<EOF
quote USER 12345
quote PASS 12345
mget /FILENAME* /directory_location_to/copy/on_server2/
EOF

and I use
to run the script on server2, I am now getting the following error:
Currently, FILENAME26.txt is the only file available on the server1.

So I tried to give the exact file name which is present on server1 and changed "mget" to "get" to check if this copies the file on server2 location (/directory_location_to/copy/on_server2/) this time, now the script looks like

Code:

cat ftp_test.sh
/usr/bin/ftp -n ftpsitename.com <<EOF
quote USER 12345
quote PASS 12345
get /FILENAME26.txt /directory_location_to/copy/on_server2/
EOF

i get a different error:
However, I checked on server 2 if the directory exists or not, and it does exist... I even tried to get the file on server2 home directory, but I get the same error as above... How does the command know to put the file on the server2(since we are not mentioning about it in the code)??? any further suggestion on this???