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

    Standard storage nodes or multiple TFTP servers in MPLS cloud?

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    5
    32
    9.8k
    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.
    • Tom ElliottT
      Tom Elliott
      last edited by

      @moses said:

      [Wed Feb 24 16:19:26.046943 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning: mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/mysql.class.php on line 30

      The quoted line is of concern.

      As @Sebastian-Roth requested, can you restart mysql service? Also, can you double check disk usage on the server with df -h?

      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

      mosesM 1 Reply Last reply Reply Quote 0
      • mosesM
        moses @Tom Elliott
        last edited by

        @Sebastian-Roth I can access the web interface on the main FOG server with no issues, and there are no problems there. Mysql is confirmed to be running. This issue is with a storage node, and the web interface is disabled with the “This is a storage node, please do not access the web ui here!” message.

        @Tom-Elliott Plenty of storage space to go around on the node, so no problems there. This the df -h output on the node, the main server is pretty much the same, with about 30 GB of images taken up on sda1:

        Filesystem      Size  Used Avail Use% Mounted on
        udev            1.9G  4.0K  1.9G   1% /dev
        tmpfs           381M  860K  381M   1% /run
        /dev/sda1       290G  3.6G  272G   2% /
        none            4.0K     0  4.0K   0% /sys/fs/cgroup
        none            5.0M     0  5.0M   0% /run/lock
        none            1.9G     0  1.9G   0% /run/shm
        none            100M     0  100M   0% /run/user
        
        Tom ElliottT 1 Reply Last reply Reply Quote 0
        • Tom ElliottT
          Tom Elliott @moses
          last edited by

          @moses Are you running a firewall that’s blocking the node’s access to the FOG Server?

          Is the storage nodes connected using fogstorage and the fogstorage password located on the main server at: FOG Configuration Page->FOG Settings->FOG Storage Nodes->FOG_STORAGENODE_MYSQLPASS/FOG_STORAGENODE_MYSQLUSER?

          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

          mosesM 1 Reply Last reply Reply Quote 0
          • mosesM
            moses @Tom Elliott
            last edited by

            @Tom-Elliott No firewall blocking, these are connected via MPLS on a clean Ubuntu 14.04 install.

            I’ve got the user/pass for fogstorage from the main server, how would I go about checking to make sure that is set correctly on the node?

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

              @moses What’s in the node’s config.class.php (/var/www/html/fog/lib/fog/config.class.php)

              The account information should show up under the mysql information.

              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

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

                @moses By using the mysql command like client: mysql --user root --password (enter PW when prompted)

                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
                • mosesM
                  moses @Tom Elliott
                  last edited by

                  @Tom-Elliott Yes, the username and password for fogstorage match on the node/server.

                  1 Reply Last reply Reply Quote 0
                  • mosesM
                    moses
                    last edited by

                    If it’s at all helpful, here’s a screenshot of the node’s configuration on the main server:

                    alt text

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

                      @moses The picture you provided is off the Storage node, that username and password are not the same as the fogstorage mysql user and password.

                      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
                      • S
                        Sebastian Roth Moderator
                        last edited by

                        @moses Did you try connecting to the DB using the mysql command line client yet? Login to the console of your storage node and run mysql --user root --password (enter PW when prompted)

                        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

                        mosesM 1 Reply Last reply Reply Quote 1
                        • mosesM
                          moses @Sebastian Roth
                          last edited by moses

                          @Sebastian-Roth I never set a mysql password on the storage node. What or where is it?

                          @Tom-Elliott Maybe I don’t know which passwords to use. There appears to be a thousand different usernames/passwords and another thousand different references to them.

                          On the main server, I added the storage node using the “management” username and password that the node spat out when running the installer:

                          alt text

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

                            @Tom-Elliott said:

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

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

                            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
                            • Tom ElliottT
                              Tom Elliott @moses
                              last edited by

                              @moses Information was all correct.

                              The reason there was a problem was ubuntu using bind-address in the my.cnf file.

                              Commented that line and restarted mysql, and everything started working 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

                              Wayne WorkmanW 1 Reply Last reply Reply Quote 1
                              • Wayne WorkmanW
                                Wayne Workman @Tom Elliott
                                last edited by

                                @Tom-Elliott added a bit to the wiki about this. https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#MySQL_credentials_for_FOG_Main_and_Storage_Nodes

                                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
                                • 1
                                • 2
                                • 2 / 2
                                • First post
                                  Last post

                                221

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project