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

    Database Schema Installer / Updater

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    3
    16
    3.5k
    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.
    • S
      SOL @Tom Elliott
      last edited by

      @Tom-Elliott I did sudo mysql before running command.

      Is it possible that the fog user disappeared by itself ? It was working just fine until this morning and no one touches that server other than me. So if I create the user that should fix it ?

      Tom ElliottT 1 Reply Last reply Reply Quote 0
      • S
        SOL @Tom Elliott
        last edited by

        @Tom-Elliott I did create the user and I was able to reset its password and restarted the service but still getting same error

        1 Reply Last reply Reply Quote 0
        • Tom ElliottT
          Tom Elliott @SOL
          last edited by

          @SOL FOG, when it runs the installer, does not create a “fog” user for the DB Connectivity. It usually uses ‘root’. So unless somebody totally changed how the installer works, I have doubts that it was setup properly when you looked into a “problem”.

          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

          S 1 Reply Last reply Reply Quote 0
          • S
            SOL @Tom Elliott
            last edited by

            @Tom-Elliott I guess I am confused. Everything was working fine until today. No changes have been made. Are you saying fog was not setup properly when installed ? When I installed fog I pretty much used defaults as far as I can remember.
            Is there a way to get it to work again ?

            Tom ElliottT 1 Reply Last reply Reply Quote 0
            • Tom ElliottT
              Tom Elliott @SOL
              last edited by

              @SOL I’ll guarantee something changed. FOG didn’t do it, but something got updated/changed/moved what ever the case.

              All you need to do is get the ALTER Command to work on your 'root'@'localhost' because if you set it pretty much default, the 'fog'@'localhost' has no bearing at all.

              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

              S 1 Reply Last reply Reply Quote 0
              • S
                SOL @Tom Elliott
                last edited by

                @Tom-Elliott I set the root user password to blank and I am able to use web gui again. I disabled system auto updates just in case for the future.

                Thanks for your help!

                F 1 Reply Last reply Reply Quote 0
                • F
                  fredlwal
                  last edited by

                  I"m also getting this same issue this morning, I restarted MySQL but no luck still the same error.

                  1 Reply Last reply Reply Quote 0
                  • F
                    fredlwal @SOL
                    last edited by

                    @SOL how do you set the root password to blank?

                    S 1 Reply Last reply Reply Quote 0
                    • S
                      SOL @fredlwal
                      last edited by SOL

                      @fredlwal instead of ‘password’ type ‘’ (basically nothing in between)

                      I used this as reference

                      https://wiki.fogproject.org/wiki/index.php?title=Password_Central

                      F 1 Reply Last reply Reply Quote 0
                      • Tom ElliottT
                        Tom Elliott
                        last edited by

                        The quickest and simplest fix is to simply re-run the fog installer.

                        Unfortunately I don’t have control over ubuntu’s Security update system so that’s left to the admin’s of the machines to fix.

                        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

                        F 1 Reply Last reply Reply Quote 0
                        • F
                          fredlwal @SOL
                          last edited by

                          @SOL using the ALTER?

                          S 1 Reply Last reply Reply Quote 0
                          • S
                            SOL @fredlwal
                            last edited by

                            @fredlwal Yes

                            1 Reply Last reply Reply Quote 0
                            • F
                              fredlwal @Tom Elliott
                              last edited by

                              @Tom-Elliott is there a way to do something like a system restore to previous settings instead of doing a reinstall?

                              Tom ElliottT 1 Reply Last reply Reply Quote 0
                              • Tom ElliottT
                                Tom Elliott @fredlwal
                                last edited by

                                @fredlwal that’s basically what a reinstall does.

                                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

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

                                163

                                Online

                                12.1k

                                Users

                                17.3k

                                Topics

                                155.3k

                                Posts
                                Copyright © 2012-2024 FOG Project