• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Database Maintenance - Error 1142

Scheduled Pinned Locked Moved
General
2
3
305
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J
    JDnoble18
    last edited by JDnoble18 Jan 15, 2021, 2:07 PM Jan 15, 2021, 8:05 PM

    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!

    T 1 Reply Last reply Jan 15, 2021, 8:40 PM Reply Quote 0
    • T
      Tom Elliott @JDnoble18
      last edited by Jan 15, 2021, 8:40 PM

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

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

      J 1 Reply Last reply Jan 15, 2021, 9:20 PM Reply Quote 0
      • J
        JDnoble18 @Tom Elliott
        last edited by Jan 15, 2021, 9:20 PM

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

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        1 / 1
        • First post
          1/3
          Last post

        179

        Online

        12.0k

        Users

        17.3k

        Topics

        155.2k

        Posts
        Copyright © 2012-2024 FOG Project