|
List Info
Thread: Re: Keep alive inactive FTP user account
|
|
| Re: Keep alive inactive FTP user account |
 
United States |
2008-02-05 12:10:32 |
|
|
That should work... but if I remember correctly some things must be "hosted out" to execute from Oracle. Not sure if FTP will run from an PL/Sql job without hosting out. But I am sure you can make it work. Might be a little more complicated than a standard Unix script.
;
John Love
jrlove  mindspring .com">jrlovemindspring.com-------------------
"Laughter is the greatest weapon we have and we, as humans, use it the least." - Mark Twain
----------------------
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact
the sender and delete the material from any computer.
----- Original Message -----
Sent: 2/5/2008 1:02:37 PM
Subject: Re: Keep alive inactive FTP user account
Thanks John,
I like your suggestion.
But I am supposed to not run any cron job.
So taking your suggestion and replacing the cron job with an Oracle job could work.
What do you think about the following?
Oracle scheduled job to execute every week or month.
FTP login script executed
Look for file on server
File not found close FTP login
logout.
;
regards
Amlan
On Feb 5, 2008 9:20 AM, john love < jrlove mindspring .com">jrlovemindspring.com> wrote:
How about a scheduled job that would "ATTEMPT" to perform an FTP every week. The FTP would only work if the file existed on the server but the account would be monitored as active due to the weekly attempt of the FTP.
Cron scheduled job to execute every week or month.
FTP login script executed
Look for file on server
File not found close FTP login
File found, perform FTP
logout.
Just a suggestion.
;
John Love
jrlove mindspring .com" target=_blank>jrlovemindspring.com-------------------
"Laughter is the greatest weapon we have and we, as humans, use it the least." - Mark Twain
----------------------
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact
the sender and delete the material from any computer.
----- Original Message -----
Sent: 2/5/2008 12:12:48 PM
Subject: Keep alive inactive FTP user account
Hi All
I need help to a problem I face. I have described my solution and need some feedback if this is going to work or if any better solutions.
I am not sure if this is going to work or just logging into FTP server and doing a directory listing every month through a job will also work.
Problem description:
; Every three months or 6 months, FTP user account is used to transfer a feeder file to a remote server through pl/sql packages as
part of business. But the FTP user account expires if inactive for three months as set in the security policy. The security folks will not
change the security policy. My goal is to keep the FTP user account alive even when there is no business activity.
My Solution:
I log into FTP user account every month running as an Oracle Job and FTP a dummy file to the server.
This will ensure some activity every month and will keep the account alive. But this also means removing the dummy file each time.
I am sending this out to multiple groups, hoping somebody will provide some feddback.
Thanks and regards
Amlan
--
Amlan |
[1]
|
|
|
about | contact Other archives ( Real Estate discussion Medical topics )
|