Automated Script to Copy MYSQL libraries to System Directories and Copy apg-services script file to systemd

SRM 6.0.0.0/6.1.0.0 | Automated Script to Copy MYSQL libraries to System Directories and Copy apg-services script file to systemd


InfoSummary :    This script will copy the required MySQL Libraries and apg-services script file to System directories for SRM/SMR Binary Linux ( RHEL and SUSE ) deployments  . The script should be executed at  SRM/SMR Pre-upgrade level.
  1. Steps to Execute the Script on 4VM or Scaled Linux Application 

  • Copy the script to the Frontend server - Linux_Binary_MySql_Systemd_Automated_Script.zip to <APG-INSTALLED-PATH>/opt
  • Navigate to <APG-INSTALLED-PATH>/opt
  • Execute the below commands and see the README.txt for more information.
    • unzip Linux_Binary_MySql_Systemd_Automated_Script.zip
    • chmod +x Linux_Binary_MySql_Systemd_Automated_Script.sh
    •  Execute the command - ./Linux_Binary_MySql_Systemd_Automated_Script.sh  -i
      • First time execution reads all the SRM servers and enter the password to establish ssh connection  
    •  Re-run the command - ./Linux_Binary_MySql_Systemd_Automated_Script.sh  -i
      • Second time execution it copies the MySQL libraries to system directories (lib and lib64) and apg-services script file to Systemd .


  1. Steps for 1VM SRM And SMR Linux Application 

  • Copy the script to the server
    •   SMR_SRM_AIO_Linux_Binary_MySQL_Systemd_Script.zip to <APG-INSTALLED-PATH>/opt/
  • Navigate to the directory
    • cd <APG-INSTALLED-PATH>/opt
  • Unzip the script package
    •  unzip SMR_SRM_AIO_Linux_Binary_MySQL_Systemd_Script.zip
  • Move into the extracted folder
    • cd SMR_SRM_AIO_Linux_Binary_MySQL_Systemd_Script
  • Contents of this folder include:
    • SMR_SRM_AIO_Linux_Binary_MySQL_Systemd_Script.sh, libraries, README.txt
  • Provide execute permission to the script:
    • chmod +x SMR_SRM_AIO_Linux_Binary_MySQL_Systemd_Script.sh
  • Execute the script:
    • bash SMR_SRM_AIO_Linux_Binary_MySQL_Systemd_Script.sh
  • Enter the Installed Directory
    • Enter installation directory [default: /opt/APG]:
  • This script performs the following actions:

    • Copies MySQL shared libraries (.so files) to system directories (/lib and /lib64)

    • Copies the apg-services script to Systemd.


  • Post SMR Upgrade Steps - After completing the SMR upgrade, restore the environment variables
  •                         export LD_LIBRARY_PATH="$OLD_LD_LIBRARY_PATH"
                            unset OLD_LD_LIBRARY_PATH

Notes
Important Notes:

  • Automated scripts handles the scaled additional backend nodes (which are scaled at pre_upgrade level)
  • Post Upgrade to SRM 6.0.0.0 : Scaling any additional backend doesn't required execution of script.
  • If the customer is using non-default permissions for newly created files and directories, ensure that the required read (r) and execute (x) permissions are granted to group and other users for MySQL-dependent library files.This is necessary to avoid access or runtime issues during application execution.
    Run the following commands:
    chmod go+rx /usr/lib/libabsl_debugging_internal.so
    chmod go+rx /usr/lib/libabsl_demangle_internal.so
    chmod go+rx /usr/lib64/libabsl_debugging_internal.so
    chmod go+rx /usr/lib64/libabsl_demangle_internal.so
    chmod go+rx /opt/APG/bin/.runtime/service/systemd-startup.sh


    • Related Articles

    • SRM vApp External Automated Upgrade Script

      Overview This script automates the SRM update process for vApp environments. It supports both All-in-One (AIO) and Distributed deployments. Important Notes Windows SRM environments are not updated by this script they are skipped and must be handled ...
    • SRM Linux External Automated Upgrade Script

      Overview This script automates the update process for SRM binary linux platforms, including RHEL and SLES. It supports both All-in-One (AIO) and Distributed environments. Important Notes Windows SRM environments are not updated by this script; they ...
    • SRM 6.1.x.x: vApp External Automated Upgrade Script

      Overview This script automates the SRM update process for vApp environments. It supports both All-in-One (AIO) and Distributed deployments. Important Notes Windows SRM environments are not updated by this script they are skipped and must be handled ...
    • SRM 6.1.x.x: Linux External Automated Upgrade Script

      Overview This script automates the update process for SRM binary linux platforms, including RHEL and SLES. It supports both All-in-One (AIO) and Distributed environments. Important Notes Windows SRM environments are not updated by this script; they ...
    • Storage MnR vApp External Automated Upgrade Script

      Overview This script automates the SMR update process for vApp environments. Important Notes Windows servers are not updated by this script; they are skipped and must be handled manually. Prerequisites Before running the script, ensure the following ...