Admins

Pb nagios :

MySQL    UNKNOWN     2019-11-02 01:22:43     0d 0h 12m 25s     4/4     NRPE: Unable to read output

Diagnostique:

(April) root@photos:/etc[master]# git grep check_mysql
nagios-plugins/config/mysql.cfg:# 'check_mysql' command definition
...

(April) root@photos:/etc[master]# /usr/lib/nagios/plugins/check_mysql
/usr/lib/nagios/plugins/check_mysql: error while loading shared libraries: libmariadb.so.3: cannot open shared object file: No such file or directory

Solution :

(April) root@photos:/etc[master]# apt install libmariadb3
...
(April) root@photos:/etc[master]# /usr/lib/nagios/plugins/check_mysql
Uptime: 948  Threads: 8  Questions: 2115  Slow queries: 0  Opens: 73  Flush tables: 1  Open tables: 67  Queries per second avg: 2.231|Connections=169c;;; Open_files=129;;; Open_tables=67;;; Qcache_free_memory=15958768;;; Qcache_hits=765c;;; Qcache_inserts=490c;;; Qcache_lowmem_prunes=0c;;; Qcache_not_cached=257c;;; Qcache_queries_in_cache=239;;; Queries=2115c;;; Questions=2115c;;; Table_locks_waited=1c;;; Threads_connected=1;;; Threads_running=6;;; Uptime=948c;;;

Passage à php7.3 :

apt-get install libapache2-mod-php7.3 php7.3-mysql
a2dismod php7.0 
a2enmod php7.3
apt-get remove libapache2-mod-php7.0 php7.0-*
apt-get autoremove
systemctl restart apache2

Faire un tail -f sur les logs Apache du site et se promener sur le site, vérifier l'absence d'erreur.

En cherchant à ajouter des images, message d'erreur « la bibliothèque GD est manquante ».

Solution : apt-get install imagemagick php7.3-gd