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

    Your database connection appears to be invalid

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    8
    23
    7.1k
    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.
    • E
      egregers
      last edited by egregers

      Server
      • FOG Version: 1.3.0 RC19
      • OS: Ubuntu 16.04
      Client
      • Service Version:
      • OS:
      Description

      I get this message when I try and access the fog web page.
      Database Schema Installer / Updater

      Your database connection appears to be invalid. FOG is unable to communicate with the database. There are many reasons why this could be the case. Please check your credentials in /var/www/fog/lib/fog/config.class.php. Also confirm that the database is indeed running. If credentials are correct, and if the Database service is running, check to ensure your filesystem has enough space.

      The system has enough space and it was working up until today.

      Also what do I need to do to upgrade to the lates version of fog?

      Thanks

      1 Reply Last reply Reply Quote 0
      • D
        dbakerwardog
        last edited by

        I am facing this error as well all things were fine until today, Please help!!
        Fog version 1.3.0
        OS: Ubuntu 16.04 LTS

        1 Reply Last reply Reply Quote 0
        • Wayne WorkmanW
          Wayne Workman
          last edited by Wayne Workman

          Both of you, Try to restart mysql.

          service mysql restart
          Then check status:
          service mysql status
          Also look through this, try the tests:
          https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_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!
          Daily Clean Installation Results:
          https://fogtesting.fogproject.us/
          FOG Reporting:
          https://fog-external-reporting-results.fogproject.us/

          E 1 Reply Last reply Reply Quote 0
          • S
            shanerlevy
            last edited by

            I am facing the same issue. FOG version 1.3.0 and Ubuntu Server version 16.04. MySQL service is up and running as well.

            1 Reply Last reply Reply Quote 0
            • Wayne WorkmanW
              Wayne Workman
              last edited by

              Related: https://forums.fogproject.org/topic/9345/database-connection-appears-to-be-invalid

              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!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              1 Reply Last reply Reply Quote 0
              • Wayne WorkmanW
                Wayne Workman
                last edited by Wayne Workman

                @Tom-Elliott @Developers @Moderators @Testers

                This is the fourth report today of this - does anyone know anything?

                FOG Versions are different, 1.3.0, 1.3.3, and 1.3.0 RC 19. The only thing in common is Ubuntu 16.04. Did an OS update break something?

                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!
                Daily Clean Installation Results:
                https://fogtesting.fogproject.us/
                FOG Reporting:
                https://fog-external-reporting-results.fogproject.us/

                1 Reply Last reply Reply Quote 0
                • E
                  egregers @Wayne Workman
                  last edited by

                  @Wayne-Workman

                  I restarted MySQL and now the web interface is just blank. nothing on it. going tread through the document.

                  Tom ElliottT Wayne WorkmanW 2 Replies Last reply Reply Quote 0
                  • Tom ElliottT
                    Tom Elliott @egregers
                    last edited by

                    @egregers remove PHP version stuff from fog settings. Remove packages from fog settings. Rerun installer

                    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

                    D E 2 Replies Last reply Reply Quote 0
                    • Wayne WorkmanW
                      Wayne Workman @egregers
                      last edited by

                      @egregers This sounds more like a PHP issue than a DB one. Look in the apache error logs.

                      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!
                      Daily Clean Installation Results:
                      https://fogtesting.fogproject.us/
                      FOG Reporting:
                      https://fog-external-reporting-results.fogproject.us/

                      1 Reply Last reply Reply Quote 0
                      • D
                        dbakerwardog @Tom Elliott
                        last edited by

                        @Tom-Elliott what steps or terminal commands would I need to do to remove though items?
                        Thanks

                        Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                        • Wayne WorkmanW
                          Wayne Workman @dbakerwardog
                          last edited by Wayne Workman

                          @dbakerwardog

                          cd /opt/fog
                          vim .fogsettings  #or nano
                          

                          locate the line that begins with packages and ver and veradds and remove those lines, save, then re-run the fog installer.

                          Reference:
                          https://wiki.fogproject.org/wiki/index.php?title=.fogsettings
                          and:
                          https://wiki.fogproject.org/wiki/index.php?title=Vi

                          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!
                          Daily Clean Installation Results:
                          https://fogtesting.fogproject.us/
                          FOG Reporting:
                          https://fog-external-reporting-results.fogproject.us/

                          S E 2 Replies Last reply Reply Quote 2
                          • S
                            shanerlevy @Wayne Workman
                            last edited by

                            @Wayne-Workman This seemed to have fixed my issue, thank you very much.

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

                              This also took care of my issue. Do we know what the cause was so it doesn’t happen again?

                              Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                              • Wayne WorkmanW
                                Wayne Workman @FlareImp
                                last edited by

                                @FlareImp Turn off automatic updates - I suspect an automatic OS update is what broke it.

                                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!
                                Daily Clean Installation Results:
                                https://fogtesting.fogproject.us/
                                FOG Reporting:
                                https://fog-external-reporting-results.fogproject.us/

                                F 1 Reply Last reply Reply Quote 0
                                • E
                                  egregers @Wayne Workman
                                  last edited by

                                  This post is deleted!
                                  1 Reply Last reply Reply Quote 0
                                  • F
                                    FlareImp @Wayne Workman
                                    last edited by

                                    @Wayne-Workman Automatic Updates are already disabled on my servers. I do not update the OS once fog has been installed. It tends to break things.

                                    Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                                    • E
                                      egregers @Tom Elliott
                                      last edited by

                                      @Tom-Elliott

                                      This fixed it. I can login to the dashboard now. Thanks!!!

                                      T 1 Reply Last reply Reply Quote 0
                                      • Wayne WorkmanW
                                        Wayne Workman @FlareImp
                                        last edited by

                                        @FlareImp said in Your database connection appears to be invalid:

                                        @Wayne-Workman Automatic Updates are already disabled on my servers. I do not update the OS once fog has been installed. It tends to break things.

                                        Check again. All these different versions of FOG all stopped working for 4 different people… Today. The only thing in common is Ubuntu 16.04. It’s almost surely an OS update that broke it. It really couldn’t have been anything else.

                                        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!
                                        Daily Clean Installation Results:
                                        https://fogtesting.fogproject.us/
                                        FOG Reporting:
                                        https://fog-external-reporting-results.fogproject.us/

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

                                          https://news.fogproject.org/fog-1-3-4-rc-1/

                                          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
                                          • T
                                            Trev-lchs @egregers
                                            last edited by

                                            @egregers what fixed it?

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

                                            222

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project