Database Maintenance - Error 1142
I’m having trouble running the database maintenance scripts.
First off we have no open slots for new tasks, shown below.
So I tried to run the database maintenance scripts on the WIKI and get this error.
Guest OS is Ubuntu 16.04
Fog version is 126.96.36.199
Any help is appreciated!
@tom-elliott Thanks very much!! That fixed it!
I found the path to the password to that user from another post I’ll copy here in case someone else runs into this problem.
Find the database information in /var/www/html/fog/lib/fog/config.class.php - with FOG 1.5.9 the database user is called fogmaster instead of root that was used in earlier versions.
@jdnoble18 Why are you connecting using the fogstorage user? You should be using the fogmaster user to run the db cleanup commands.