Linode Longview MySQL configuration for Cpanel / WHM
Are you running a Linode with Cpanel? If you are you more than likely are having issues getting Longview to report on MySQL. This is because the Linode is no longer developing Longview for Cpanel. But there is away around this. Simply follow the steps below to get those MySQL stats pumping back into Longview.
First install Longview as you usually would:
curl -s https://lv.linode.com/YOUR-API-KEY-HERE | sudo bash
This will do most of the auto config for you Eg. Set Longview up with your API key etc. But this will install an older unsupported Cpanel version of Linode, this version doesn’t seem to have a driver that works for the MySQL reporting.
To fix this:
Uninstall the old Cpanel version of Longview like so:
yum remove linode-longview-cpanel-1.1-3
Now install latest version:
yum install linode-longview
Your API key should of been stored from the initial install. Check via:
Now you can configure the MySQL service:
Enter the Mysql User / pass you created into this file: (remove or comment out any other details here)
username linode-longview password YOURPASSWORDHERE
Then save the file.
Now restart Longview and you should be good to go! Read the Linode guide here for more info.