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

Database Schema Installer / Updater

Scheduled Pinned Locked Moved Solved
FOG Problems
3
16
3.4k
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
    last edited by SOL Apr 28, 2017, 5:39 AM Apr 28, 2017, 11:39 AM

    Server
    • FOG Version: 1.3.4
    • OS: Ubuntu 16.04.2
    Client
    • Service Version:
    • OS:
    Description

    I have been using this server for couple of months now, but this morning I get this error

    Database Schema Installer / Updater
    Your database connection appears to be invalid. FOG is unable to communicate with the database…

    I am unable to use web gui at all.
    I did restart my sql service and I did look through this thread but I don’t see anything that fixes it for me
    https://forums.fogproject.org/topic/9344/your-database-connection-appears-to-be-invalid/18

    This the status of mysql

    sudo service mysql status
    ● mysql.service - MySQL Community Server
       Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
       Active: active (running) since Fri 2017-04-28 07:10:55 EDT; 39s ago
      Process: 17807 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=e
      Process: 17799 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exi
     Main PID: 17806 (mysqld)
       CGroup: /system.slice/mysql.service
               └─17806 /usr/sbin/mysqld
    
    Apr 28 07:10:54 FOGSERV systemd[1]: Starting MySQL Community Server...
    Apr 28 07:10:55 FOGSERV systemd[1]: Started MySQL Community Server.
    
    

    When I try to reset the password with

    ALTER USER 'fog'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPasswordGoesHere';
    

    I get this error

    ERROR 1396 (HY000): Operation ALTER USER failed for 'fog'@'localhost'
    

    Any Ideas ?

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Apr 28, 2017, 11:41 AM

      You have to sudo to mysql, but it seems, to me, that there is no “user” named ‘fog’ for mysql.

      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 2 Replies Last reply Apr 28, 2017, 11:45 AM Reply Quote 0
      • S
        SOL @Tom Elliott
        last edited by Apr 28, 2017, 11:45 AM

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

        T 1 Reply Last reply Apr 28, 2017, 12:09 PM Reply Quote 0
        • S
          SOL @Tom Elliott
          last edited by Apr 28, 2017, 11:51 AM

          @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
          • T
            Tom Elliott @SOL
            last edited by Apr 28, 2017, 12:09 PM

            @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 Apr 28, 2017, 12:14 PM Reply Quote 0
            • S
              SOL @Tom Elliott
              last edited by Apr 28, 2017, 12:14 PM

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

              T 1 Reply Last reply Apr 28, 2017, 12:15 PM Reply Quote 0
              • T
                Tom Elliott @SOL
                last edited by Apr 28, 2017, 12:15 PM

                @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 Apr 28, 2017, 12:22 PM Reply Quote 0
                • S
                  SOL @Tom Elliott
                  last edited by Apr 28, 2017, 12:22 PM

                  @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 Apr 28, 2017, 2:13 PM Reply Quote 0
                  • F
                    fredlwal
                    last edited by Apr 28, 2017, 1:38 PM

                    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 Apr 28, 2017, 2:13 PM

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

                      S 1 Reply Last reply Apr 28, 2017, 2:15 PM Reply Quote 0
                      • S
                        SOL @fredlwal
                        last edited by SOL Apr 28, 2017, 8:22 AM Apr 28, 2017, 2:15 PM

                        @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 Apr 28, 2017, 3:13 PM Reply Quote 0
                        • T
                          Tom Elliott
                          last edited by Apr 28, 2017, 2:22 PM

                          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 Apr 28, 2017, 5:09 PM Reply Quote 0
                          • F
                            fredlwal @SOL
                            last edited by Apr 28, 2017, 3:13 PM

                            @SOL using the ALTER?

                            S 1 Reply Last reply Apr 28, 2017, 3:26 PM Reply Quote 0
                            • S
                              SOL @fredlwal
                              last edited by Apr 28, 2017, 3:26 PM

                              @fredlwal Yes

                              1 Reply Last reply Reply Quote 0
                              • F
                                fredlwal @Tom Elliott
                                last edited by Apr 28, 2017, 5:09 PM

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

                                T 1 Reply Last reply Apr 29, 2017, 12:42 AM Reply Quote 0
                                • T
                                  Tom Elliott @fredlwal
                                  last edited by Apr 29, 2017, 12:42 AM

                                  @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
                                  1 / 1
                                  • First post
                                    10/16
                                    Last post

                                  223

                                  Online

                                  12.0k

                                  Users

                                  17.3k

                                  Topics

                                  155.2k

                                  Posts
                                  Copyright © 2012-2024 FOG Project