MySQL monitor shows MySQL as offline when it's not
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
I have used various scripts. The most recent is MiniMonitor that comes with WHMXtra. Another I got off my billing software's community forum, which essentially is the same script that the billing software itself uses to monitor the services. All of them show the same results (everything green except mysql).
You may want to look at replacing APF with CSF - APF isn't being developed any more as far as I know and CSF is now in wide use and has a WHM interface available, ie you can control it all from WHM, including updating it when it changes.