Database Maintenance - Error 1142

[JDnoble18]

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 1.5.9.58

Any help is appreciated!

[Tom Elliott]

@jdnoble18 Why are you connecting using the fogstorage user? You should be using the fogmaster user to run the db cleanup commands.

[JDnoble18]

@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.