EFT - Using an Oracle database for authentication


THE INFORMATION IN THIS ARTICLE APPLIES TO:

  • EFT, all versions

DISCUSSION

You can use an Oracle database for authentication. EFT Server use ADO to communicate with the authentication databases using 'generic' SQL statements.

Verify that you are able to connect to the Oracle database by creating a site with the System DSN as the ODBC Auth Provider source. If you do not get any errors stating that the ODBC Auth Provider could not be initialized, then you have successfully connected to the data source.

The following fields are used by the INSERT statement:

name, password, description, type, password_type, md_iter, 
otp_seed, anonymous, anonymous_email, enabled

Make sure they are all present with these exact names in the table "ftpserver_users", and that the account that is used to log on to the database has Insert privileges on that table.

If you receive any errors, try using a tool to monitor SQL statements that are executed on the server. In Microsoft SQL Server there is a tool such as "SQL Profiler." Other options include tools like "tkprof" or you can turn on "autotrace." Ask your DBA for additional assistance.

If there no records in the ftpserver_users table after you attempt creation of a user in the GUI or there are rows and they are simply not showing up in the GUI, try a simple SQL statement external to your program that matches what your system is trying to do. For example:

INSERT INTO ftpserver_users(name, password, description, type, 
password_type, md_iter, otp_seed, anonymous, anonymous_email, 
enabled) VALUES('foo', GOAD BYTE WADE SHUT EVEN RUE', 
'Description for FOO', 1, 0, 9999, NULL, 0, 0, 1)
For details of using an Oracle DB with EFT, refer to the "Auditing and Reporting" help for your version of the EFT. (In the EFT administration interface, press F1 or click About > Help.)