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.
    9858caaa-af72-47fe-9aa5-ca8d36b25183-image.png

    So I tried to run the database maintenance scripts on the WIKI and get this error.
    701f7c4c-7f55-443a-8b2b-2c646ba0164c-image.png

    Guest OS is Ubuntu 16.04
    Fog version is 1.5.9.58

    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.

  • Senior Developer

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

285
Online

8.2k
Users

15.0k
Topics

141.5k
Posts