BUG? Monit wants to conncet to my MariaDB Installation

[KaeTuuN]

Monit makes four connection attempts every two or four Minutes to my MariaDB. But I don’t Monitor MariaDB at the Moment…

Sample Log Output:

Oct  2 17:42:17 Servername mysqld[3087]: 2020-10-02 17:42:17 11369 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:42:17 Servername mysqld[3087]: 2020-10-02 17:42:17 11370 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:42:17 Servername mysqld[3087]: 2020-10-02 17:42:17 11371 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:42:17 Servername mysqld[3087]: 2020-10-02 17:42:17 11372 [Warning] Access denied for user ''@'localhost' (using password: NO)
...
Oct  2 17:46:17 Servername mysqld[3087]: 2020-10-02 17:46:17 11670 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:46:17 Servername mysqld[3087]: 2020-10-02 17:46:17 11671 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:46:17 Servername mysqld[3087]: 2020-10-02 17:46:17 11672 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:46:17 Servername mysqld[3087]: 2020-10-02 17:46:17 11673 [Warning] Access denied for user ''@'localhost' (using password: NO)
...
Oct  2 17:48:18 Servername mysqld[3087]: 2020-10-02 17:48:18 11726 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:48:18 Servername mysqld[3087]: 2020-10-02 17:48:18 11727 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:48:18 Servername mysqld[3087]: 2020-10-02 17:48:18 11728 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:48:18 Servername mysqld[3087]: 2020-10-02 17:48:18 11729 [Warning] Access denied for user ''@'localhost' (using password: NO)
...
Oct  2 17:50:18 Servername mysqld[3087]: 2020-10-02 17:50:18 11780 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:50:18 Servername mysqld[3087]: 2020-10-02 17:50:18 11781 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:50:18 Servername mysqld[3087]: 2020-10-02 17:50:18 11782 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:50:18 Servername mysqld[3087]: 2020-10-02 17:50:18 11783 [Warning] Access denied for user ''@'localhost' (using password: NO)
...
Oct  2 17:54:18 Servername mysqld[3087]: 2020-10-02 17:54:18 11906 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:54:18 Servername mysqld[3087]: 2020-10-02 17:54:18 11907 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:54:18 Servername mysqld[3087]: 2020-10-02 17:54:18 11908 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:54:18 Servername mysqld[3087]: 2020-10-02 17:54:18 11909 [Warning] Access denied for user ''@'localhost' (using password: NO)
...
Oct  2 17:56:19 Servername mysqld[3087]: 2020-10-02 17:56:19 12163 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:56:19 Servername mysqld[3087]: 2020-10-02 17:56:19 12164 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:56:19 Servername mysqld[3087]: 2020-10-02 17:56:19 12165 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 17:56:19 Servername mysqld[3087]: 2020-10-02 17:56:19 12166 [Warning] Access denied for user ''@'localhost' (using password: NO)

Oct  2 18:00:19 Servername mysqld[3087]: 2020-10-02 18:00:19 12283 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 18:00:19 Servername mysqld[3087]: 2020-10-02 18:00:19 12284 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 18:00:19 Servername mysqld[3087]: 2020-10-02 18:00:19 12285 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 18:00:19 Servername mysqld[3087]: 2020-10-02 18:00:19 12286 [Warning] Access denied for user ''@'localhost' (using password: NO)
...
Oct  2 18:02:19 Servername mysqld[3087]: 2020-10-02 18:02:19 12363 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 18:02:19 Servername mysqld[3087]: 2020-10-02 18:02:19 12364 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 18:02:19 Servername mysqld[3087]: 2020-10-02 18:02:19 12365 [Warning] Access denied for user ''@'localhost' (using password: NO)
Oct  2 18:02:19 Servername mysqld[3087]: 2020-10-02 18:02:19 12366 [Warning] Access denied for user ''@'localhost' (using password: NO)

System: Fresh installed Ubuntu Server 20.04 LTS

I reviewed every active configfile, but i can’t find any reason…

‌

[Tildeslash]

Please investigate your .monitrc config file(s) and also if you have an old Monit instance running which was configured to check mysqld. Monit does not, by itself, decide to check mariadb.

[KaeTuuN]

5.26.0-4 is the newest Version included in Ubuntu 20.04 LTS. I couldn’t find any Repo or PPA to add so unattended-upgrades could manage monit version.

As I said, I reviewed all monit files and I could not find anything…

user@machine:/etc/monit# grep -inr 3306
monitrc:275:#    if failed port 3306 protocol mysql with timeout 15 seconds then alert
conf-available/mysql:6:   if failed host localhost port 3306 protocol mysql with timeout 15 seconds for 3 times within 4 cycles then restart

Line 2 is a comment and should not be interpreted by monit.

Triple checked, that file “mysql” (line 3) is not included Anywhere.

And I can’t see anything related to MariaDB / MySQL at the Monit Web Frontend.

[Lutz Mader]

Hello KaeTuuN,
the most easy way (from my point of view) to check/see the services are used by the monitor is the monit verbose command option, try “monit -v”.

And the “monit validate” or “monit status” show all services too.

Switch to the user used by monit to do the checks.

A suggestion only,
Lutz