• 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.7k
    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.
    • 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

                        193

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project