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

    no valid Db connection from storage node after upgrade to 1.5.4

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    16
    1.9k
    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
      Sebastian Roth Moderator
      last edited by

      @CoxM Where exactly do you see the failed DB connection error? Can you please take a picture and post here?

      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
      • C
        CoxM
        last edited by

        0_1540387396789_Capture2.PNG

        1 Reply Last reply Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by

          @CoxM Strange thing. Can you please run the following command on your storage node and post results here:

          find /var/www/fog -type f -exec grep "FOG_VERSION" {} /dev/null \;
          

          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

          C 1 Reply Last reply Reply Quote 0
          • C
            CoxM @Sebastian Roth
            last edited by

            @Sebastian-Roth 0_1540544644694_Capture2.PNG

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by

              @CoxM This is strange, not what I expected, can’t replicate the issue and can’t figure out where the message is coming from. Will look into it again.

              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

              C 1 Reply Last reply Reply Quote 0
              • C
                CoxM @Sebastian Roth
                last edited by

                @Sebastian-Roth Thanks

                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Sebastian Roth

                  @CoxM Please check your config on the updated storage node: /var/www/fog/lib/fog/config.class.php
                  Then see if you can connect to the master server’s database using those credentials with the mysql command line client on the storage node:

                  mysql -h POR-FOG -u fogstorage -D fog -p
                  Password:
                  ...
                  

                  This will probably fail. As the other 1.5.3 node you have is not showing the error I kind of doubt the issue is on the master node. But you can still try to reset the credentials in your master node’s database like that:

                  mysql -u root -D mysql -p
                  Password:
                  ...
                  ALTER USER 'fogstorage'@'%' IDENTIFIED WITH mysql_native_password BY 'put_password_here';
                  

                  Please let us know what the issue was. I am wondering if this is something other people run into as well.

                  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

                  C 1 Reply Last reply Reply Quote 0
                  • C
                    CoxM @Sebastian Roth
                    last edited by

                    @Sebastian-Roth Thanks for all your help.

                    The issues turned out to be the mysql credentials held in the config.class.php file. They had been reset and needed the correct details manually adding. Once that was done all worked fine.

                    Thanks again,
                    Matt.

                    1 Reply Last reply Reply Quote 0
                    • S
                      Sebastian Roth Moderator
                      last edited by

                      @CoxM What were the credentials set to. Can you figure out what was wrong. Or did you reset the credentials in the DB to make it work?

                      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

                      george1421G C 2 Replies Last reply Reply Quote 0
                      • george1421G
                        george1421 Moderator @Sebastian Roth
                        last edited by

                        @Sebastian-Roth Is this db information stored in the .fogsettings file? My thinking is that maybe it was changed/reset in the system before 1.5.4 was installed and the fog installer reset things to the way they were set according to the .fogsettings file(??)

                        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!

                        1 Reply Last reply Reply Quote 1
                        • C
                          CoxM @Sebastian Roth
                          last edited by

                          @Sebastian-Roth It had reset the user to ‘root’ and the password blank. I have run the ALTER USER commands previously so perhaps that did it.

                          Once I had manually entered the correct username “fogstorage” and the password, which I still had from the working node, I was up and running.

                          Thanks,

                          Matt.

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

                          234

                          Online

                          12.1k

                          Users

                          17.3k

                          Topics

                          155.3k

                          Posts
                          Copyright © 2012-2024 FOG Project