I would recommend checking out this commercial product called GoAnywhere Gateway (http://www.goanywheremft.com/products/gateway), which sits in the DMZ and interfaces with various services in the private network.
On Tue, Nov 30, 2010 at 2:34 PM, <brad_qu...@denso-diam.com> wrote: > > > Niklas, > > Thanks for your help. > > I'm using org.apache.commons.dbcp.BasicDataSource for the database > connection, configured in the ftpd.xml file under db-user-manager, and > com.ibm.as400.access.AS400 for the backend server connection and > com.ibm.as400.access.IFSFile and com.ibm.as400.access.IFSFileInputStream > for the file information and the filestream. I just used the DbFile, > DbFileSystemFactory, and DbFileSystemView classes that Brett provided, and > edited them to fit what I needed, and made sure to re-use existing > connections, and close them when I was done with them. > > Then, I wrote a custom FtpLet because I need to mark the file as 'read' in > the database once it's finished downloading. I also use this FtpLet to > setup the connections in onLogin() and close them in onDisconnect(). > > I'll keep looking for the proxy information, and post back if I find > anything useful, or if someone wants that information. > > Thanks again, > > -Brad > > >>On Tue, Nov 30, 2010 at 6:54 PM, <brad_qu...@denso-diam.com> wrote: >>> I even managed to control/close all of the data and database connections > to >>> IFS and the Database (which are on the same server, but separate from > the >>> server used for Apache FTP Server), so that the number of established >>> sockets remains the same after several logins/downloads/disconnects. I > can >>> provide this code if anyone else is interested. >> >>Is this using JTOpen? >> >>> What I need to do next is set up the production environment that this > FTP >>> server will operate in. There is an outward facing server in the DMZ > which >>> users will connect to, but the database access and processing needs to > be >>> done on the application server, behind the firewall. Only the > application >>> server can connect to the database and IFS. >>> >>> Does anyone have any ideas on how to set this up with Apache FTP server? >>> Some type of FTP front-end to handle the connections, and then pass all > the >>> commands to the application server, and receive all the responses and >>> filestreams, etc. >> >>FTP is somewhat hard to proxy due to the complexity with the data >>connections. There are dedicated FTP proxy products but I do not have >>any experience myself. I know that there has been some discussions >>here on similar topics, so there might be others with more experience. >> >>As for FtpServer, we support configuring a external IP for passive >>data connections which should help. >> >>/niklas > The information contained in and transmitted with this Email may be > privileged, proprietary, confidential and protected from disclosure. No > privilege is hereby intended to be waived. This Email is intended only for > the person to whom it is addressed. If you are not the intended > recipient/addressee, any use of the Email and/or its contents, including, but > not limited to, dissemination, distribution or copying is strictly prohibited > and may be unlawful, and you must not take any action in reliance on it. If > you receive this Email in error, please immediately notify the sender and > delete the original message and any copies of it from your computer system. > We deny any liability for damages resulting from the use of this Email by the > unintended recipient, including the recipient in error.