Tero: I have not tried it with Oracle yet, but it works on SQL Server.
My external database setup is exactly as yours. I have noticed (and confirmed with IpSwitch) that if I try and set the FTPMAXSPACE to a number over 2 gigs it crashes the system. I am getting ready to request they fix this or set the amount to something other than bytes so we can feed in a larger number (like 200 gigs). Also, sometimes ftp server is extremely picky about your "Table Name" being upper/lower case correct and if I remember in Oracle it actually returns all Upper case names. You might try changing your table name to "FTPACCOUNT". I have also noticed the fact that adding a user through the Manager does not write into the database. Michael S. Ewles Senior Develper -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 4:05 AM To: [EMAIL PROTECTED] Subject: [WS_FTP Forum] Login gets stucked when using external user database I have problems in login to the FTP server when using external user database (oracle 8.1.7), OS: windows 2000. The FTP server sees users defined in the external database and user properties modification in FTP manager (disable login, etc.) is updated to the database correctly. But when FTP Client (WS_FTP or java client) tries to log on to the FTP server it gets stucked. "Read timed out" occurs after defined timeout (60 secs). Disable extensions is selected. Entry in log file: 1212 10:14:35 (00000338) 172.21.211.183:1408 connected to 172.21.211.183:21 1212 10:14:35 (00000338) xxxxxxxxxx.NOE.Nokia.com D(0) 172.21.211.183 UNK USER tre External database configuration in the FTP server: DLL: c:\iFtpSvc\odbcuser.dll ODBC Source Name: ipdc_db7;UID=tero;PWD=tero Table Name: ftpaccount SQL> desc ftpaccount Nimi Tyhj� arvo? Tyyppi ----------------------------------------- -------- ---------------------------- USERID NOT NULL VARCHAR2(8) PASSWORD NOT NULL VARCHAR2(20) FULLNAME NOT NULL VARCHAR2(50) FTPMAXSPACE NOT NULL NUMBER(38) FTPMAXFILES NOT NULL NUMBER(38) FTPFLAGS NOT NULL NUMBER(38) Values in the DB: USERID PASSWORD FULLNAME -------- -------------------- -------------------------------------------------- FTPMAXSPACE FTPMAXFILES FTPFLAGS ----------- ----------- ---------- tre tre tero 1000000 2000 800 I also noticed that when adding a new user with FTP server manager nothing happens, no user in DB, no error/log messages. Tero Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list.
