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

      Hello,

      Firstly, thanks to the devs. Fog is excellent.

      I have deployed a storage node and have a couple of questions.

      [LIST]
      []I am using the location plugin, how can I test to be sure the image is being pulled from the correct storage node? Everything seems ok in testing I just can’t find the log to confirm. I don’t want to flood the WAN with image traffic.
      [
      ]The web GUI disk information does not work for my storage node. It just says failed to connect
      [*][IMG]http://s3.postimg.org/z3hpqwmw3/2015_01_29_14_11_42_Dashboard_Dashboard_FOG.png[/IMG]
      [/LIST]
      Any ideas?
      Thanks

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

        I’ve never used the location plugin, so I can’t speak for that.

        I had the failed to connect problem as well and narrowed it down to a MySQL config change. In my.cnf, I had to comment out the bind-address line for 127.0.0.1 and restart mysql. I also had to make sure the server config was correct in Config.class.php. Maybe check those 2 things?

        T 1 Reply Last reply Reply Quote 0
        • C
          Chris_bne
          last edited by

          Thanks Ben.

          I removed the location plugin after a design re-think, but it hasn’t changed the GUI problem.

          Thanks for the suggestions I’ll have a go now.

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

            From the node… can you login to the fog servers mysql database?

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

              I also keep getting the ‘failed to connect error’. Could you please explain to me there the 2 files that you referenced are located so I can check to see if that is where my problem is?

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

                cassie,

                Can you supply the Fog Server OS and the Storage Node OS?

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

                  Hi cassie,
                  The fix for me worked on Fog 1.1.2 on Ubuntu 12.04.

                  For the mysql part, the file I changed is at /etc/mysql/my.cnf Find the line that says bind-address = 127.0.0.1 and put a # in front to comment it out. Save the file and do a “service mysql restart” to reload the configuration.

                  Then in the fog config files, I edited /var/www/fog/lib/fog/Config.class.php and had to enter the correct mysql connection info in the db_settings function.

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

                    Both my fog server and my storage node are using Ubuntu 14.4.

                    can you please elaborate what you mean by “correct mysql connection info in the db_settings function.”

                    Thank you!

                    1 Reply Last reply Reply Quote 0
                    • 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
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            162

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project