Can not connect to database; MySQL-client libraries package not installed

Issue

• When accessing CloudLinux Manager UI the following error appears: 
  

  Can not connect to database; MySQL-client libraries package not installed

  
• When running the cloudlinux-summary --send --json the following output can be seen:
  

  [...]
  File "/opt/alt/python37/lib/python3.7/site-packages/clcommon/cpapi/plugins/plesk.py", line 113, in resellers
    return [cplogin for (cplogin, ) in query_sql(sql)]
  File "/opt/alt/python37/lib/python3.7/site-packages/clcommon/cpapi/plugins/plesk.py", line 83, in query_sql
    'Can not connect to database; MySQL-client libraries package not installed.'
  clcommon.cpapi.cpapiexceptions.NoPackage: CloudLinux control panel API: Can not connect to database; MySQL-client libraries package not installed.

Environment

CloudLinux OS

Solution

1. Reinstall alt-python packages.
   

   # yum reinstall alt-python37*

2. In case the issue still persists, re-create the lvestats database:
   

   # service lvestats stop
   # tar -zcvf /root/lveinfo_backup_$(date +%Y-%m-%d).tar.gz /var/lve/
   # mv /var/lve/lvestats2.db{,.old}
   # lve-create-db --recreate
   # service lvestats start

Useful links

How to fix lveinfo database error