I.13 Configuring Password Changes

This section describes how to modify the OFSAA Infrastructure Config Schema and Atomic Schema passwords.

Modifying OFSAA Infrastructure Config Schema password

To change the Config Schema password, follow these steps:

  1. Change the Config schema User Password in the database.
  2. Delete the $FIC_HOME/conf/Reveleus.SEC file.
  3. Shutdown the OFSAAI App service: cd$FIC_APP_HOME/common/FICServer/bin./stopofsaai.sh.
  4. Start the Infrastructure Server in foreground directly on the server or through X-Windows software using the command: ./startofsaai.sh.
  5. At the prompt, enter System Password. Enter the new Config schema password. The service will start and initialize itself if it is able to successfully connect to the DB.

    Post successful start up of the service, if required, the Infrastructure server may be shut down and restarted in the background using nohup mode.

Modifying OFSAA Infrastructure Atomic Schema Password

To change the Atomic Schema password, follow these steps:

  1. Change the Atomic schema User Password in the database.
  2. Login to the application from the browser using SYSADMN account or any user ID, which has System Administrator role mapped.
  3. Navigate to System Configuration > Database Details window. Select the appropriate connection and edit the password.
  4. Navigate to Data Management Tools >Data Sources> Source Designer window. Update the password of the appropriate Source.
  5. If you are using Apache Tomcat as Web server, update the <Context> -> Resource tag details in Server.xml file from the $CATALINA_HOME/conf folder. (In case of Tomcat only Atomic <Resource> will exist).
  6. If you are using WebSphere as Web server:
    1. Login to the WebSphere Administration Console, from the left side menu.
    2. Navigate to Resources >JDBC >Data Sources. A list of data sources will be populated on the right side.
    3. Select the appropriate Data Source and edit the connection details. (In this case, both Config and Atomic data sources will need to be modified).
  7. If you are using WebLogic as Web server:
    1. Login to the WebLogic Administration Console, from the left side menu
    2. Under Domain Structure list box, expand the appropriate Domain and navigate to Services > JDBC >Data Sources. A list of data sources will be populated on the right side.
    3. Select the appropriate Data Source and edit the connection details. (In this case, both Config and Atomic data sources need to be modified).
  8. Restart the OFSAAI services.

Configuring Internal Service (Document Upload/Download)

This step can be ignored if it has already been configured as part of any previous IR/ML installation.

The Document Upload/Download feature has undergone a change and can now be configured to use Internal service for document upload/download instead of the earlier ExeWebService.

To facilitate Internal service for document upload/download, perform the these configurations:

  1. Create the folders download, upload, TempDocument and Temp in the local path of Web application server and provide Read/Write permission.
    1. To find the exact location, execute the following query in CONFIG schema: select localpath from web_server_info.
    2. To create folders with Read/Write permission, execute the command: 
      mkdir -m777 download upload TempDocument Temp
      .
  2. Create DocStorage folder in the FTPSHARE location of APP tier and provide Read/Write permission.
    1. To find the exact location, execute the query in CONFIG schema: select ftpdrivefrom app_server_info.
    2. To create folder with Read/Write permission, execute the command: 
      mkdir -m 777 DocStorage
      .