Configuring a database user by running ocsetup on Linux

You can run the ocsetup file on the DataFabric Manager 5.x server to configure read-only access of the DataFabric Manager 5.x database to OnCommand Workflow Automation.

Steps

  1. Download the wfa_ocsetup.sh file to your home directory on the DataFabric Manager 5.x server using the following command in the terminal: wget https://WFA_Server_IP/download/wfa_ocsetup.sh
    WFA_Server_IP is the IP address (IPv4 or IPv6 address) of your WFA server.

    If you have specified a non-default port for WFA, you must include the port number as follows: wget https://wfa_server_ip:port/download/wfa_ocsetup.sh

    port is the TCP port number that you have used for the WFA server during installation.

    If you are specifying an IPv6 address, you must enclose it with square brackets.
  2. Use the following command in the terminal to change the wfa_ocsetup.sh file to an executable: chmod +x wfa_ocsetup.sh
  3. Run the script by entering the following in the terminal: ./wfa_ocsetup.sh OpenJDK_path
    OpenJDK_path is the path to OpenJDK.
    Example
    /opt/NTAPdfm/java
    The following output is displayed in the terminal, indicating a successful setup:
    Verifying archive integrity... All good.
    Uncompressing WFA OnCommand Setup.....
    *** Welcome to OnCommand Setup Utility for Linux ***
        <Help information>
    *** Please override the default credentials below ***
    Override DB Username [wfa] :
  4. Enter a user name and password to override the default credentials.
    A new database user account is created with access to the DataFabric Manager 5.x database.
    Note: If you do not create a user account, the default credentials are used. You must create a user account for security purposes.
    The following output is displayed in the terminal, indicating a successful setup:
    ***** Start of response from the database *****
    >>> Connecting to database
    <<< Connected
    *** Dropped existing 'wfa' user
    === Created user 'username'
    >>> Granting access
    <<< Granted access
    ***** End of response from the database *****
    ***** End of Setup *****