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

Problem with Database Schema Installer / Updater

Scheduled Pinned Locked Moved Solved
FOG Problems
2
15
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.
  • K
    koelhomem
    last edited by Nov 10, 2016, 2:24 PM

    Hi there.

    I installed FOG on a Virtualbox virtual machine on a Windows 10 (ugh… don’t ask…) host.
    After the instalation of FOG, when accessing for the first time through Web UI, the following error appears:

    “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.”

    MySQL is up and running. Credentials are correct on config.class.php file. Database is working (that goes without saying) and the server is newly installed with only 22% of the hard drive occupied.

    Anyone else had the same issue?

    Cheers!

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Nov 10, 2016, 2:26 PM

      We need much more information.

      What version of FOG is installed?

      What OS is the FOG Server installed on?

      Is firewall enabled?

      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

      K 1 Reply Last reply Nov 10, 2016, 2:30 PM Reply Quote 0
      • K
        koelhomem @Tom Elliott
        last edited by Nov 10, 2016, 2:30 PM

        Hi!

        @Tom-Elliott:

        FOG version: 1.3.0-RC-21
        OS: Ubuntu 16.04
        Firewall: disabled (no ufw, no iptables)

        T 1 Reply Last reply Nov 10, 2016, 2:37 PM Reply Quote 0
        • T
          Tom Elliott @koelhomem
          last edited by Nov 10, 2016, 2:37 PM

          @koelhomem Does mysql have a password set?

          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

          K 1 Reply Last reply Nov 10, 2016, 2:39 PM Reply Quote 0
          • K
            koelhomem @Tom Elliott
            last edited by Nov 10, 2016, 2:39 PM

            Yes. And the password is the correct one set on the php file.

            T 1 Reply Last reply Nov 10, 2016, 2:54 PM Reply Quote 0
            • T
              Tom Elliott @koelhomem
              last edited by Nov 10, 2016, 2:54 PM

              @koelhomem So you can access the db by running:

              mysql -u root -p'YourPassHere'

              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

              K 1 Reply Last reply Nov 10, 2016, 2:56 PM Reply Quote 0
              • K
                koelhomem @Tom Elliott
                last edited by Nov 10, 2016, 2:56 PM

                @Tom-Elliott Yes.

                T 1 Reply Last reply Nov 10, 2016, 2:58 PM Reply Quote 0
                • T
                  Tom Elliott @koelhomem
                  last edited by Nov 10, 2016, 2:58 PM

                  @koelhomem Does your password contain any special characters? Double/Single quotes, $ symbol?

                  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

                  K 1 Reply Last reply Nov 10, 2016, 2:59 PM Reply Quote 0
                  • K
                    koelhomem @Tom Elliott
                    last edited by Nov 10, 2016, 2:59 PM

                    @Tom-Elliott No. Alphanumeric only.

                    T 1 Reply Last reply Nov 10, 2016, 3:00 PM Reply Quote 0
                    • T
                      Tom Elliott @koelhomem
                      last edited by Nov 10, 2016, 3:00 PM

                      @koelhomem Then something seems really off.

                      If you login to the DB then via command line:

                      Try running:

                      ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<YourPasswordHere>';

                      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

                      K 1 Reply Last reply Nov 10, 2016, 3:10 PM Reply Quote 0
                      • K
                        koelhomem @Tom Elliott
                        last edited by Nov 10, 2016, 3:10 PM

                        @Tom-Elliott That solved it. But this issue occurred after the default automated installation.

                        For now, this is only a test server. Later on, if everything going ok, it will be implemented on a production environment. Hope everything goes ok from here.

                        Thanks a lot for your help!

                        T 1 Reply Last reply Nov 10, 2016, 3:11 PM Reply Quote 0
                        • T
                          Tom Elliott @koelhomem
                          last edited by Nov 10, 2016, 3:11 PM

                          @koelhomem When you installed initially, did you set the password AFTER it ran through once?

                          I say this because that ALTER statement only runs if the password is initially blank (in which case it sounds like it was originally).

                          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

                          K 1 Reply Last reply Nov 10, 2016, 3:21 PM Reply Quote 0
                          • K
                            koelhomem @Tom Elliott
                            last edited by Nov 10, 2016, 3:21 PM

                            @Tom-Elliott Yes I did set the password after. I don’t know what went wrong with it, but after the installation finished, I ran through the configurations (and its passwords), in order to verify if everything was ok.

                            Anyway, all ok and going to test the image capture/deployment tasks.

                            Thanks a bunch.

                            1 Reply Last reply Reply Quote 0
                            • T
                              Tom Elliott
                              last edited by Nov 10, 2016, 3:22 PM

                              I’ve modified the code base slightly to help prevent this problem in the future.

                              Of note:

                              The installer will adjust the alter syntax to whatever value is stored in snmysqlpass now. It will only run on known versions of mysql/mariadb that will accept the ALTER USER syntax. It does not set the mysql user password FOR you. It ONLY set’s the alter user syntax (which can break your system if you simply enter a password and ALTER USER is not accepted on your version.) I don’t know what setting this without runnign through GRANT on system that accept this will do.

                              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

                              K 1 Reply Last reply Nov 10, 2016, 3:56 PM Reply Quote 0
                              • K
                                koelhomem @Tom Elliott
                                last edited by Nov 10, 2016, 3:56 PM

                                @Tom-Elliott Perfect. You can mark this topic as “Solved”.

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

                                147

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project