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

    Storage node testing and disk information not displayed

    Scheduled Pinned Locked Moved
    FOG Problems
    7
    26
    11.2k
    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.
    • cassie_280C
      cassie_280
      last edited by

      I did notice that between my FOG server and the storage node the TFTP_FTP_PASSWORD value was different. I changed that line so they matched and restarted mysql, but I still am receiving the same error.

      1 Reply Last reply Reply Quote 0
      • B
        Ben Warfield
        last edited by

        In the Config.class.php file, there’s a section not too far from the top of the file that starts with “private static function db_settings()”.
        Database_host should most likely be ‘localhost’ unless you have your database stored somewhere else
        Database_name should be fog
        Database_username and Database_password should be an account with access to the fog database. I’ve changed my username/password so I can’t tell you for sure what the default is

        1 Reply Last reply Reply Quote 0
        • cassie_280C
          cassie_280
          last edited by

          On the server username is root, and password is null. On the node the username is fog storage and the password is password.
          I’m guessing that’s where my problem is?

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

            Yes,

            the Storage node password for the (fogstorage) user is found in:

            FOG Configuration Page->FOG Settings->FOG Storage Nodes->FOG_STORAGENODE_MYSQLPASS

            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
            • cassie_280C
              cassie_280
              last edited by

              Tom,

              I changed that password in the GUI because I was unsure what the default was and I had to enter the credentials when I was installing FOG.
              So the credentials in my storage node currently match what is in that location.

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

                If you’re comfortable with the mysql syntax, you’re more likely going to have to change the fogstorage password in the db then.

                To do this the syntax should be:
                [code]SET PASSWORD FOR ‘fogstorage’@‘%’ = PASSWORD(‘new-password-here’); FLUSH PRIVILEGES;[/code]

                This should help out.

                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
                • cassie_280C
                  cassie_280
                  last edited by

                  Where do I enter that?

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

                    You need to login to the mysql instance. From a terminal on the FOG server run the command:

                    [code]mysql -u root fog[/code]

                    Then run the above command.

                    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
                    • cassie_280C
                      cassie_280
                      last edited by

                      Return said “Query OK, 0 rows affected (0.00 sec)”
                      I restarted mysql and I’m still having the same issue.

                      Is it possible that I could just change the password in the GUI and in the node back to the default (whatever that is)?
                      The only reason I changed it was because I had no idea what it was and it was in hidden characters.

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

                        The default is a randomly generated one performed at install time. It only happens the first install.

                        The fact that it reports 0 rows affect tells me, it seems, that updating this field is working properly as well.

                        A test you could do could be to sign in to mysql using the password you set and the same info:

                        [code]mysql -u fogstorage -p’<your-fogstorage-pass-here>’ fog[/code]

                        Does it allow you in with this? Also, is the /etc/my.cnf bind-address commented out?

                        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
                        • cassie_280C
                          cassie_280
                          last edited by

                          Yes, I was able to log in with those credentials, and yes the bind-address is commented out.
                          I restarted the mysql service and I still get the failed to connect error.

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

                            Now,

                            From the storage node, can you perform the same command, just adding -h’IPOFFOGSERVER’

                            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
                            • cassie_280C
                              cassie_280
                              last edited by

                              I was able to fix it.
                              Turns out I had had changed the user and password in the config.class.php file when I was testing to see if that’s what the problem was. I changed it back to fogstorage and password and now it’s working.

                              My issue was just that the mysql db needed updated.

                              Thank You so much!

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

                                No 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

                                1 Reply Last reply Reply Quote 0
                                • L
                                  Lombard
                                  last edited by

                                  Hello,
                                  I have the same problem, and nothing work.
                                  I have a ubuntu 14.04 server and fog 1.2.
                                  Thanks

                                  1 Reply Last reply Reply Quote 0
                                  • L
                                    Lombard
                                    last edited by

                                    [LEFT]Does it encrypt the password in GUI “FOG_STORAGENODE_MYSQLPASS” ?
                                    [/LEFT]

                                    1 Reply Last reply Reply Quote 0
                                    • W
                                      Wolfbane8653 Developer
                                      last edited by

                                      No the webgui is not encrypted.

                                      1 Reply Last reply Reply Quote 0
                                      • T
                                        Troy @Ben Warfield
                                        last edited by

                                        @Ben-Warfield

                                        Thank you Ben, just updating, simply comment de bind address on my.cnf solves the issue.

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

                                        150

                                        Online

                                        12.0k

                                        Users

                                        17.3k

                                        Topics

                                        155.2k

                                        Posts
                                        Copyright © 2012-2024 FOG Project