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

    Solved Storage Nodes & Disk Info Pie Chart

    FOG Problems
    4
    28
    10258
    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

      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
      • ch3iC
        ch3i Moderator @Neil Underwood
        last edited by

        @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 Neil Underwood

          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’

          ch3iC 1 Reply Last reply Reply Quote 0
          • ch3iC
            ch3i Moderator @Neil Underwood
            last edited by

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

            1 Reply Last reply Reply Quote 0
            • N
              Neil Underwood
              last edited by

              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',             '');
                      }
              
              ch3iC 1 Reply Last reply Reply Quote 0
              • ch3iC
                ch3i Moderator @Neil Underwood
                last edited by ch3i

                @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 Neil Underwood

                  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?

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

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

                    174

                    Online

                    10.6k

                    Users

                    16.5k

                    Topics

                    151.1k

                    Posts
                    Copyright © 2012-2023 FOG Project