Uploaded image for project: 'FtpServer'
  1. FtpServer
  2. FTPSERVER-7

Problem when using Database to store/retrieve user info

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • None
    • None
    • None
    • None
    • Installed on Windows 2000 Server.
      Java 1.4.2_04

    Description

      I have been testing the Incubator FTP Server for some time. I have installed it on a Windows 2000 server and configured to store/retrieve user information from an Oracle Database.

      I have observed that sporadically the FTP Server looses connection to the database and that prohibits any authorized user to login to the server. This happens once in a couple of days, and after that if you restat the FTP server, the problem is gone.
      I see the following error message in log files:

      ERROR 2004-10-14 10:31:09.687 [user-man] (): DbUserManager.authenticate()
      java.sql.SQLException: Io exception: Software caused connection abort: socket write error
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
      at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:292)
      at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:311)
      at org.apache.ftpserver.usermanager.DbUserManager.authenticate(DbUserManager.java:393)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      Please let me know if anyone has any thoughts as to why this problem is occurring and how to resolve.

      Attachments

        1. FTPSERVER-7b.txt
          14 kB
          Sergey Vladimirov
        2. FTPSERVER-7b.txt
          14 kB
          Sergey Vladimirov
        3. FTPSERVER-7.txt
          6 kB
          Sergey Vladimirov

        Activity

          People

            Unassigned Unassigned
            sdash123 Surajit Dash
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: