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

Storage Nodes & Disk Info Pie Chart

Scheduled Pinned Locked Moved Solved
FOG Problems
4
28
14.1k
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.
  • N
    Neil Underwood
    last edited by Jun 2, 2015, 5:04 AM

    I apologize if this has been addressed already but I have spent several days scouring this forum and Google for a solution but I just can’t seem to find it. I’ve recently added 2 remote storage nodes to our FOG system. Everything is working great, even better than expected. Imaging over our MPLS connection previously took 2-3 hours for one PC. It now takes only 6 minutes for a 40GB image using the remote storage nodes.

    My problem is… neither one of my storage nodes shows any disk information on the dashboard. This is FOG 1.2.0, Debian 7.8 master & Linux Mint 17.1 nodes, I should mention. Everything is replicating and imaging just fine. If I click where the pie chart should be it takes me to an info page for the respective storage node. Everything appears to be communicating correctly, I just get the “Failed to connect to” instead of a chart/graph.

    If anyone could point me in the right direction it would be great. I know this is something trivial that I’m just missing because I’m not very familiar with the guts of this system yet.

    Thanks!

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Jun 2, 2015, 8:26 AM

      Your separate nodes are talking with the database properly? Is FTP on the nodes operating properly?

      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
      • N
        Neil Underwood
        last edited by Neil Underwood Jun 2, 2015, 10:44 AM Jun 2, 2015, 4:40 PM

        Yes, I can manually connect via FTP from the node to the master. I just logged into the FTP server from a terminal on one of the nodes and performed a file transfer going both ways successfully.

        I assume the nodes are communicating with the database properly based on the successful replication. Not very familiar with mysql though. Is there a way that I can test that manually?

        C 1 Reply Last reply Jun 2, 2015, 4:50 PM Reply Quote 0
        • C
          ch3i Moderator @Neil Underwood
          last edited by ch3i Jun 2, 2015, 10:50 AM Jun 2, 2015, 4:50 PM

          @Neil-Underwood If you want to test your mysql connection over the LAN between Master and Node :

          mysql --host="ip" --user="your_username" --password="your_password"
          

          Regards,
          Ch3i.

          1 Reply Last reply Reply Quote 0
          • N
            Neil Underwood
            last edited by Jun 2, 2015, 4:58 PM

            Thanks for that. It appears there is an issue connecting to the database. I thought I had set the database to use “root” w/no password. No matter what combination of user/pass I try I get access denied. How do I go about fixing this?

            Here is the relevant section from Config.class.php:

             /**
                    * db_settings()
                    * Defines the database settings for FOG
                    * @return void
                    */
                    private static function db_settings()
                    {
                            define('DATABASE_TYPE',         'mysql');       // mysql or oracle
                            define('DATABASE_HOST',         'xxx.xxx.xxx.xxx');
                            define('DATABASE_NAME',         'fog');
                            define('DATABASE_USERNAME',             'root');
                            define('DATABASE_PASSWORD',             '');
                    }
            
            C 1 Reply Last reply Jun 2, 2015, 5:00 PM Reply Quote 0
            • C
              ch3i Moderator @Neil Underwood
              last edited by Jun 2, 2015, 5:00 PM

              @Neil-Underwood It’s the config of your Storage Node ?

              1 Reply Last reply Reply Quote 0
              • N
                Neil Underwood
                last edited by Neil Underwood Jun 2, 2015, 11:03 AM Jun 2, 2015, 5:01 PM

                No, sorry. This is the config of the mysql server on the master. However they are identical on both master and node.
                Except for the host IP address. The master uses ‘localhost’

                C 1 Reply Last reply Jun 2, 2015, 5:04 PM Reply Quote 0
                • C
                  ch3i Moderator @Neil Underwood
                  last edited by Jun 2, 2015, 5:04 PM

                  @Neil-Underwood On each server you can connect to your Mysql with the root user without password ?

                  1 Reply Last reply Reply Quote 0
                  • N
                    Neil Underwood
                    last edited by Jun 2, 2015, 5:16 PM

                    I’ve only got the one server, but yes, I can connect to the database locally as the root user, no password.

                    1 Reply Last reply Reply Quote 0
                    • T
                      Tom Elliott
                      last edited by Jun 2, 2015, 5:37 PM

                      Try this:

                      mysql -u root -h <IPOFFOGSERVER> fog

                      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
                      • N
                        Neil Underwood
                        last edited by Jun 2, 2015, 6:30 PM

                        These machines are all on different subnets and are communicating over an MPLS network + VPN. The subnets are being advertised by a Meraki MX80 firewall at the same location as the server and are all part of one big VLAN, in a sense.

                        I notice when I try: mysql -u root -h <IPOFFOGSERVER> fog
                        it appends the local IP address to the username.

                        sradmin@mid-fog-node ~ $ mysql -u root -h 192.168.xxx.200 fog
                        ERROR 1045 (28000): Access denied for user 'root'@'192.168.yyy.200' (using password: NO)
                        

                        Could this be causing the authentication failure?

                        C 1 Reply Last reply Jun 2, 2015, 6:56 PM Reply Quote 0
                        • T
                          Tom Elliott
                          last edited by Tom Elliott Jun 2, 2015, 12:55 PM Jun 2, 2015, 6:50 PM

                          And you need to look at turning off bind address for that other eye peas can communicate to your SQL Server

                          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
                          • C
                            ch3i Moderator @Neil Underwood
                            last edited by Jun 2, 2015, 6:56 PM

                            @Neil-Underwood said:

                            These machines are all on different subnets and are communicating over an MPLS network + VPN. The subnets are being advertised by a Meraki MX80 firewall at the same location as the server and are all part of one big VLAN, in a sense.

                            I notice when I try: mysql -u root -h <IPOFFOGSERVER> fog
                            it appends the local IP address to the username.

                            sradmin@mid-fog-node ~ $ mysql -u root -h 192.168.xxx.200 fog
                            ERROR 1045 (28000): Access denied for user 'root'@'192.168.yyy.200' (using password: NO)
                            

                            Could this be causing the authentication failure?

                            The MySQL database is only on the FOG server (sorry for my crap messages to check if node reply to MySQL requests)

                            Now, if you use MPLS it’s layer 2 network, ans there is nothing that drop your traffic…

                            If you can not connect the MySQL server from node storage, you have a network restriction in your MySQL server configuration.

                            1 Reply Last reply Reply Quote 0
                            • N
                              Neil Underwood
                              last edited by Jun 2, 2015, 7:25 PM

                              OK. I believe I have enough info now to straighten this out. It definitely appears that I need to add some GRANTS. Thank you for pointing me in the right direction. SQL is very foreign to me. I will return once I have fixed this to share my final solution. Thanks guys.

                              1 Reply Last reply Reply Quote 0
                              • N
                                Neil Underwood
                                last edited by Jun 3, 2015, 6:35 AM

                                Whoa boy did I muck this up. Somehow I managed to get myself locked out of the web interface, only to be met with the schema updater and a failure to update anything from there. Not sure exactly what I did to piss it off, but I’m back to where I started now. I dumped my current mysql database, completely removed FOG ( except for images ), reinstalled FOG, then re-imported the database and I’m back up.

                                I can most definitely log in to the mysql database from the storage nodes now, but I’m still not getting any disk info. At this point I think I’m OK with that. That was 3 hours of panic that I do not wish to encounter again. Of course this all had to happen on the day we received a dozen new PC’s, just to make it more stressful.

                                So to recap:

                                FTP access - check
                                MySQL access - check
                                Disk Info - Nope

                                Time for some sleep.

                                T 1 Reply Last reply Jun 3, 2015, 8:41 AM Reply Quote 0
                                • T
                                  Tom Elliott @Neil Underwood
                                  last edited by Jun 3, 2015, 8:41 AM

                                  @Neil-Underwood The fix is very simple. All you really need to do is edit the my.cnf file in /etc/mysql/my.cnf. And comment the bind-address line with the # symbol. Once commented and saved, restart the mysql service. That should be it.

                                  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

                                  W 1 Reply Last reply Jun 3, 2015, 11:10 AM Reply Quote 0
                                  • W
                                    Wayne Workman @Tom Elliott
                                    last edited by Jun 3, 2015, 11:10 AM

                                    @Tom-Elliott said:

                                    @Neil-Underwood The fix is very simple. All you really need to do is edit the my.cnf file in /etc/mysql/my.cnf. And comment the bind-address line with the # symbol. Once commented and saved, restart the mysql service. That should be it.

                                    For me, it’s normally two part… Maybe I was doing it wrong the whole time?

                                    GRANT ALL PRIVILEGES ON . TO ‘fog’@‘%’ IDENTIFIED BY ‘PassHere’ WITH GRANT OPTION;

                                    and inside my.cnf, I set
                                    bind-address = *

                                    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!
                                    Daily Clean Installation Results:
                                    https://fogtesting.fogproject.us/
                                    FOG Reporting:
                                    https://fog-external-reporting-results.fogproject.us/

                                    T 1 Reply Last reply Jun 3, 2015, 11:15 AM Reply Quote 0
                                    • T
                                      Tom Elliott @Wayne Workman
                                      last edited by Jun 3, 2015, 11:15 AM

                                      @Wayne-Workman said:

                                      @Tom-Elliott said:

                                      @Neil-Underwood The fix is very simple. All you really need to do is edit the my.cnf file in /etc/mysql/my.cnf. And comment the bind-address line with the # symbol. Once commented and saved, restart the mysql service. That should be it.

                                      For me, it’s normally two part… Maybe I was doing it wrong the whole time?

                                      GRANT ALL PRIVILEGES ON . TO ‘fog’@‘%’ IDENTIFIED BY ‘PassHere’ WITH GRANT OPTION;

                                      and inside my.cnf, I set
                                      bind-address = *

                                      All you need to do is comment the bind-address. The * does the exact same thing as the comment will do. You also don’t need to set a wildcard user as one already exists (AKA fogstorage found in FOG Configuration Page->FOG Settings)

                                      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 1
                                      • W
                                        Wayne Workman
                                        last edited by Jun 3, 2015, 11:19 AM

                                        @Tom-Elliott said:

                                        FOG Settings)

                                        Oh that’s what that’s for… nice.

                                        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!
                                        Daily Clean Installation Results:
                                        https://fogtesting.fogproject.us/
                                        FOG Reporting:
                                        https://fog-external-reporting-results.fogproject.us/

                                        1 Reply Last reply Reply Quote 0
                                        • N
                                          Neil Underwood
                                          last edited by Jun 3, 2015, 2:56 PM

                                          I’ve had bind-address commented out from the inception of this issue. If I uncomment it I get a whole different set of problems.

                                          The problem now is with tftp it seems. My clients are getting a file not found error when attempting to PXE boot. I thought I straightened out all the usernames/passwords.

                                          Config.class.php TFTP_FTP_USERNAME/PASSWORD and STORAGE__FTP_USERNAME/PASSWORD both match the username/pw in the TFTP Server settings on the web interface. The username, ‘fog’, has the same unix password as what is in the aformentioned settings and has full access to /tftp.

                                          The only conflict I now see is the Fog Storage Nodes credentials. I have one set in the web interface fr user “fogstorage”, and in Config.class.php I have this:

                                                          define('DATABASE_TYPE',         'mysql');       // mysql or oracle
                                                          define('DATABASE_HOST',         'localhost');
                                                          define('DATABASE_NAME',         'fog');
                                                          define('DATABASE_USERNAME',             'root');
                                                          define('DATABASE_PASSWORD',             'xxxxxx');
                                                  }
                                          

                                          Should these settings match? I’m confused because updating one doesn’t seems to change the other and I’m unclear on which settings correlate to one another from the config files to the web interface.

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

                                          197

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project