Disabling the FIPS Mode on the MySQL Server

The following procedure describes how to disable the FIPS mode in Session Monitor on the MySQL server:

Steps to disable the FIPS mode at MySQL server:
  1. Stop the Session Monitor services first using these commands:
    source /opt/oracle/ocsm/ocsm_env.sh
    pld-systemctl stop
    
  2. Navigate to the directory where the Session Monitor zip file was extracted and ensure the FIPS scripts have executable permission. If not, set the execute permission using the following command:
    chmod +x ./scripts/FIPS_Scripts/*.sh
  3. Enable the FIPS mode at MySQL by executing the following command:
    ./scripts/FIPS_Scripts/Disable_FIPS_on_MySQL.sh
  4. Start the Session Monitor services using command:
    pld-systemctl start
  5. After disabling the FIPS mode at the MySQL server, execute the following command at MySQL to verify FIPS status.
    mysql vsp -e 'select md5(8);show warnings;'
    Output should be (there shouldn’t be any warning):
    +----------------------------------+
    | md5(8)                           |
    +----------------------------------+
    | c9f0f895fb98ab9159f51fd0297e236d |
    +----------------------------------+
    
    

    Note:

    If you toggle between enable/disable the FIPS mode, then you must regenerate any keys not created in the FIPS mode. So, you must be careful if you want to disable the FIPS mode after enabling.