Storage Nodes & Disk Info Pie Chart

[Tom Elliott]

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

[Wayne Workman]

@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 = *

[Tom Elliott]

@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)

[Wayne Workman]

@Tom-Elliott said:

FOG Settings)

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

[Neil Underwood]

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.

[Wayne Workman]

Check this out: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_TFTP

Let us know if you need help.

[Neil Underwood]

I got it working! I’m really uncertain exactly what it was that finally did it though

Basically I made the password for user ‘fog’ the same on all 3 machines. I then made sure this user/pass combo was the same for the mysql ‘fog’ user, as well as the tftp & ftp storage user/pass. So in short everything has the same login credentials across the board.

I also created specific grants for each remote user, e.g.

GRANT ALL PRIVILEGES ON *.* TO 'fog'@'192.168.xxx.200' IDENTIFIED BY 'xxxxxxxx' WITH GRANT OPTION;

for each remote ip address.

Thanks to everyone for your assistance. Special thanks to Tom for taking the time to have a private chat session with me to help me get this figured out. You guys are awesome.

PS - Not sure how to mark solved on this forum…

[Neil Underwood]

OK so I’m left with a lingering issue now. I’m trying to deploy an image to make sure everything is working, but the image is only being pushed out from one of the remote nodes to a local machine over the MPLS, giving me a horrible transfer rate of ~ 80MB/min. Why would it not deploy the image from the local server? I’ve witnessed this system deploy an image in under 6.5 minutes. What logs should I be checking to figure this out?

[Wayne Workman]

Are you using the Location Plugin ? If so, double-check those settings. It’s really easy to orphan settings in there when you change things around. If you’re using the location plugin, maybe even re-configure it.

[Neil Underwood]

No, I’m not using the location plugin. Should I be? I had the impression that it was kind of abandoned/for older versions of FOG so I never actually looked into it.

[Neil Underwood]

OK well that did it. I installed the location plugin and now everything is back up to speed. I guess it just needed a little direction and I just got lucky on that first image I deployed to test the remote storage node. Thanks again.

[Wayne Workman]

@Neil-Underwood said:

No, I’m not using the location plugin. Should I be? I had the impression that it was kind of abandoned/for older versions of FOG so I never actually looked into it.

It’s not abandoned at all. It’s in-fact the most important plugin of all.

Let’s figure it out. Where are your storage nodes? Are they separated by WAN links? Are they on different networks (different broadcast domains) ?

[Wayne Workman]

I sit on pages reading… you post fast, didn’t see your last post.

Glad you got it working.