000030157 - IMG:AFX: How to upload an AFX connector jar file if one has already been uploaded

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000030157
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: All
RSA Version/Condition: 6.8.1+6.9+, 6.9.1+
Platform: Linux
Platform (Other): All
O/S Version: Red Hat Enterprise Linux x.x
 
Issue
After uploading a missing jar file into an AFX Connector template (AFX -> Connector Templates -> Under File Content (Upload Missing Files)), it is discovered that the jar file needs to be replaced. There could be several reasons for this such as:
1. Wrong version of the jar file was loaded
2. Corrupt version of the jar file was loaded
3. Newer version of the jar file now supported
4. There is an unidentified problem with the existing jar file
5. Jar file did not come from a reputable source 
Jar files are stored in the database in a table called T_AV_AFX_FILE. There is one row per jar file. The CHECKSUM column in the table determines whether a file has been uploaded or not. When CHECKSUM is NULL, the jar file has not been uploaded and the UI prompts for the missing file to be uploaded. Once a jar file has been uploaded, the CHECKSUM for that jar file has a value.



 
TasksTo upload a jar file into the database that has already been uploaded, execute the following SQL commands:

STEPS:


1. Login to the linux server as 'oracle'
2. Login to SQLPLUS as 'avuser'
3. Verify that you are updating the correct row in the table:
SQL> select * from T_AV_AFX_FILE where name like '%<name of jar file goes here>%';
4. Set the value of CHECKSUM to NULL for the jar file that needs to be uploaded:
SQL> update T_AV_AFX_FILE set CHECKSUM=NULL where NAME='<name of jar file goes here>';
SQL> commit;

5. Verify that CHECKSUM was set to NULL for the appropriate jar file:


SQL> select * from T_AV_AFX_FILE where name like '%<name of jar file goes here>%';
6. In the UI go to AFX -> Connector Templates -> <connector template name that needs new jar file> and note the option to upload the missing jar file is now available.

 

EXAMPLE:


In this example the MySQL connector jar file needs to be uploaded again:
User-added image

SQL> select NAME, DISPLAY_NAME, CHECKSUM from T_AV_AFX_FILE where NAME like '%mysql%';

User-added image



SQL> update T_AV_AFX_FILE set CHECKSUM=NULL where NAME='mysql-connector-java-5.1.25-bin.jar';
SQL> commit;


User-added image



SQL> select NAME, DISPLAY_NAME, CHECKSUM from T_AV_AFX_FILE where NAME like '%mysql%';

User-added image

 
ResolutionEngineering ticket ACM-54120 has been created to add this functionality to the UI
 
NotesThe functionality in ACM-54120 is expected to be added in  6.9.1 P07

Attachments

    Outcomes