• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login
    1. Home
    2. Neil Underwood
    3. Posts
    N
    • Profile
    • Following 0
    • Followers 0
    • Topics 13
    • Posts 72
    • Best 2
    • Controversial 0
    • Groups 0

    Posts made by Neil Underwood

    • RE: Storage Nodes & Disk Info Pie Chart

      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.

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Storage Nodes & Disk Info Pie Chart

      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.

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Storage Nodes & Disk Info Pie Chart

      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.

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Storage Nodes & Disk Info Pie Chart

      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?

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Storage Nodes & Disk Info Pie Chart

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

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Storage Nodes & Disk Info Pie Chart

      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’

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Storage Nodes & Disk Info Pie Chart

      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',             '');
              }
      
      posted in FOG Problems
      N
      Neil Underwood
    • RE: Storage Nodes & Disk Info Pie Chart

      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?

      posted in FOG Problems
      N
      Neil Underwood
    • Storage Nodes & Disk Info Pie Chart

      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!

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Hostnamechanger index was outside the bounds of the array. fog 1.3.0 rev 2402

      [quote=“Jbob, post: 43736, member: 21733”]The data array contains all of the info returned by the server. The version included in v1.2.0 is broken, as you have discovered. Please note that this client is old and is about to be replaced by a new one. (A beta of the new version can be expected in the coming week(s) )[/quote]

      That’s great news. I looked over the code and I see how it populates now. Looks like the older version overpopulated by default, and didn’t check for null key value. Correct?

      Will an in-place upgrade to the new beta be possible? Or will the server need to be rebuilt?

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Hostnamechanger index was outside the bounds of the array. fog 1.3.0 rev 2402

      I’ve actually got it working now. I thought that recompiling HostNameChanger and changing the passkey was enough, but the out of bounds error is caused by the unpatched MOD_hostnamechanger.cs that is packed with 1.2.0. I cloned the latest version from git, changed the passkey and recompiled and now everything is working great. The error lies in the function at line 362 of MOD_HostnmeChanger.cs. The unpatched version only allows an array size of 6:
      [CODE]if (arData.Length == 6)
      {
      strHostName = strHostResults.Remove(0, 5);
      String strUseAD = arData[1];
      String strD = arData[2];
      String strOU = arData[3];
      String strU = arData[4];
      String strP = arData[5];
      String strKey = arData[6];
      if (strKey != null)
      {
      strKey = strKey.Trim();
      if (strKey.StartsWith(“#Key=”))
      {
      strKey = strKey.Replace(“#Key=”, “”);
      Process scriptProc = new Process();
      scriptProc.StartInfo.FileName = @“cscript”;
      scriptProc.StartInfo.Arguments =@“//B //Nologo c:\windows\system32\slmgr.vbs /ipk " + strKey;
      scriptProc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
      scriptProc.Start();
      scriptProc.WaitForExit();
      scriptProc.Close();
      scriptProc.StartInfo.Arguments =@”//B //Nologo c:\windows\system32\slmgr.vbs /ato";
      scriptProc.Start();
      scriptProc.WaitForExit();
      scriptProc.Close();
      }
      }[/CODE]

      As apposed to the patched version from git that allows for an array size of 6 OR 7:

      [CODE]if (arData.Length == 6 || arData.Length == 7)
      {
      strHostName = strHostResults.Remove(0, 5);
      String strUseAD = arData[1];
      String strD = arData[2];
      String strOU = arData[3];
      String strU = arData[4];
      String strP = arData[5];

                                          if(arData.Length == 7) {
                                              String strKey = arData[6];
                                              if (strKey != null)
                                              {
                                                  strKey = strKey.Trim();
                                                  if (strKey.StartsWith("#Key="))
                                                  {
                                                      strKey = strKey.Replace("#Key=", "");
                                                      Process scriptProc = new Process();
                                                      scriptProc.StartInfo.FileName = @"cscript";
                                                      scriptProc.StartInfo.Arguments =@"//B //Nologo c:\windows\system32\slmgr.vbs /ipk " + strKey;
                                                      scriptProc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
                                                      scriptProc.Start();
                                                      scriptProc.WaitForExit();
                                                      scriptProc.Close();
                                                      scriptProc.StartInfo.Arguments =@"//B //Nologo c:\windows\system32\slmgr.vbs /ato";
                                                      scriptProc.Start();
                                                      scriptProc.WaitForExit();
                                                      scriptProc.Close();
                                                  }
                                              }
                                          }[/CODE]
      

      Not really certain exactly what data the array is accepting, as I haven’t really had the time to scrutinize the code, but that seems to be the issue. Looks like it has something to do with a key value, but that doesn’t make sense because I’m not sending any key values. If anyone could explain what the data is that this array is being populated with that would be great. Otherwise I’ll come back and update when I’ve had the time to figure it out.

      The version I used can be found here: [url]https://github.com/FOGProject/fogproject/tree/4b6a98a5a5ab552fbe066e062af857b33a17a15f/FOGService/src/FOG_HostNameChanger[/url]

      The post on this forum that led me to this solution can be found here: [url]http://fogproject.org/forum/threads/active-directory-registration-not-working-windows-7-x64-client.11514/[/url]

      Many thanks to Jbob for the info.

      posted in FOG Problems
      N
      Neil Underwood
    • RE: Hostnamechanger index was outside the bounds of the array. fog 1.3.0 rev 2402

      Did you ever find a solution to this problem? I’m having the same issue but we do not use product key management through FOG. Is this required for HostNameChanger to work properly?

      EDIT
      I’ve recompiled HostNameChanger myself using VS 2008. Prior to this I was getting an invalid padding error. It’s driving me bonkers.

      posted in FOG Problems
      N
      Neil Underwood
    • 1
    • 2
    • 3
    • 4
    • 4 / 4