12 Troubleshooting

12.1 Configuration Assistant

Issue: install_configure_mysql.sh fails with "Permission denied" error

Error Message: 
[ERROR] [MY-013276] [Server] Failed to set datadir to '<veridata_installation_dir>/mysql-commercial-8.0.34-linux-glibc2.17-x86_64-minimal/data/' (OS errno: 13 - Permission denied)

Troubleshooting Options

  1. Check Directory Permissions:
    1. Run the following command to check access permissions (Note: "/ogg/app/oracle/veridata/23 is an example path of <veridata_installation_dir>):
      ls -ld /ogg /ogg/app /ogg/app/oracle /ogg/app/oracle/veridata /ogg/app/oracle/veridata/23 /ogg/app/oracle/veridata/23/mysql-commercial-8.0.34-linux-glibc2.17-x86_64-minimal
    2. If any parent directories lack the x (execute) permission, then vdtrepouser is unable to access the data directory.
  2. Verify SELinux Policy:
    1. Switch to the root user.
    2. Navigate to: <veridata_installation_dir>/mysql-commercial-8.0.34-linux-glibc2.17-x86_64-minimal/bin
    3. Run the command: ls -lt ../data
    4. If the directory permission output does not include a trailing "." (for example, drwxr-x---.), then SELinux is not the issue. Otherwise, set SELinux to Permissive or Disabled mode.

Parent topic: Troubleshooting

12.2 MySQL Operation

Issue: Error when trying to log into MySQL (./bin/mysql):

Error Messages:
  • error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
  • error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
Troubleshooting Options
  • Create Symlinks for Missing Libraries (if libtinfo.so.6 and libncurses.so.6 exist in the OS):

    Commands

    ln -s /usr/lib64/libncurses.so.6 /usr/lib64/libncurses.so.5
    ln -s /usr/lib64/libtinfo.so.6 /usr/lib64/libtinfo.so.5
  • Install the Required Package using the following command:
    yum install ncurses-compat-libs

Parent topic: Troubleshooting