Solved Storage Nodes & Disk Info Pie Chart

[Neil Underwood]

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

[ch3i]

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

[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’

[ch3i]

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

[Neil Underwood]

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',             '');
        }

[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.

[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?

[Tom Elliott]

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