Need to transfer a file from F50 to Network

[KOG]

Hi Folks

I have a scheduled script running every night to extract CSV file and the plan is to transfer it over to network L:\ drive. I have the IP address of this network.

I am trying to run a small FTP script (not too certain if this is correct), included the network IP address and its hostname in the /etc/hosts and .rhosts and still received an error message. Any idea why?

$ ftp ****************
ftp: connect: Connection refused
ftp>

Thanking you all in advance.

Regards

K

 

[alexhu]

Can you do the transfer manually ?

Alex

 

[KOG]

No I could not, that is what is bothering me do I need an access right to an NT domain for F50 or J40 (for tests use only) users?

And how? Any other aix system files I need to update i.e. /etc/hosts , .rhosts etc?

Have any of you done this?

Regards

K

 

[alexhu]

Is your NT server running the FTP service ?

Alex

 

[KOG]

Hi Alex

I am transferring the file from RS/6000 server to another NT server, is it necessary for the other NT server to have FTP service?

My n/w manager said

"You cannot link an RS box and NT/2000 servers.
The security for an NT domain is only governed by an NT security system with NT user accounts and groups.
It is only interlinking into netware systems and apple macs, and then they have to adopt NT users."

If that is the case then how do I overcome this problem?

 

[alexhu]

Well, either your n/w manager did not understand what you wanted or he's wrong.

Go to Google - Groups and select comp.unix.aix

do a search in that group for "ftp nt service" and you will find many posts about what you are trying to achieve.

I don't work with NT, but I know that we do ftp from our RS/6000 systems to / from NT servers for interfaces & printing - it does work.

Also ftp client is loaded by default with NT but server needs extra install / config

Alex

 

[alexhu]

Apparently it is also possible to NFS mount NT directories on AIX and AIX filesystems on NT, but you need extra software to do that

Alex

 

[KOG]

Is it possible just to run a simple ftp script to webserver (change of plan now)?

Only prob I am having now is how to avoid the prompt of username/password request?

Is there any ftp script where I can incorporate all the commands in one single command i.e. ftp ********* username/password?

Cheers

K

 

[alexhu]

Put this in a file

ftp -nv <hostname> << EOF
user <username> <password>
<command>
<command>
<command>
by
EOF

Alex

 

[KOG]

what does -nv mean?

Is it ok to enter IP address rather than hostname?

Many thks for your quick response.

Cheers

K

 

[KOG]

Hi

Sorry to bother you but is there a way I can incorporate all these commands in ONE single command line (for Oracle OEM scheduled job).

i.e.

ftp -nv <IP> << EOF user <name> <pwd> A put by EOF

Tried this and tried separating each command with : no luck.

Any suggestions many thanks

K

 

[alexhu]

1.

Yes IP / Hostname

From the ftp man pages;

-n Prevents an automatic login on the initial connection. Otherwise, the ftp command searches for a $HOME/.netrc entry that describes the login and initialization process for the remote host. See the user subcommand.

-v Displays all the responses from the remote server and provides data transfer statistics. This display mode is the default when the output of the ftp command is to a terminal, such as the console or a display.

2.

No idea - never done it - try an Oracle Forum ?

Alex

 

[damir]

Try with Microsoft Services for Unix! Install it on your NT box, on AIX mount NFS file system, and make some simple script in KSH...
Damir

 

[baskar43]

Try this
On the Command Prompt of your NT Workstation, type FTP <ipadd>
it will attempt to connect to the host and prompt you with the username as
User (<ip addressnone)) : Provide the user name
331 Password required for <username>
Password : Provide the password
230 User logged in
ftp>

on this prompt change directory to the folder /etc/hosts (for eg) and type &quot;Send <filename>&quot;
if this doesnt work, something wrong in your configuration of hosts file on NT workstation

 

[KOG]

Hi folks

I have figured a way around this problem. By using AIX netrc file (copy it from /usr/samples/tcpip/netrc to oracle home directory), amend it to include the following

machine <IP Address> login <loginname> password <password>
macdef init
ascii
cd \bsndata
put /oracledata3/oradata/BLB/bsndata.LST
bye

It works if the file to be transferred is within oracle home directory where it is ftping from but when I instruct it to get and transfer the file from /oracledata3 directory it failed to find the file?

I am using Oracle OEM job scheduler to create the LST file and transfer it from F50 to webserver every night.

Any suggestions?

(From Oracle OEM)
Connected to 212.126.99.153.
220 webserver01 Microsoft FTP Service (Version 4.0).
331 Password required for birmcham.
230 User birmcham logged in.
ascii
200 Type set to A.
cd bsndata
250 CWD command successful.
put /oracledata3/oradata/BLB/bsndata.LST
200 PORT command successful.
550 /oracledata3/oradata/BLB/bsndata.LST: The system cannot find the path specified.
bye
221

Cheers

K