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

snapin hash does not match on storage node (1.5.7.55)

Scheduled Pinned Locked Moved Solved
FOG Problems
4
17
1.9k
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.
  • S
    Sebastian Roth Moderator
    last edited by Nov 27, 2019, 5:16 AM

    @Greg-Plamondon When did you upload/update that snapin last? Possibly the FOGSnapinHash service just didn’t update the hash sum in the database yet.

    Are alll your nodes using the same FOG version?

    Let’s start by looking at the hashes. Run sha512sum /opt/fog/snapins/TeamViewer-AllSites.sfx.exe on your main FOG server, the old storage node and the new storage node. Do they all match?

    Then try the same on your Windows machine by running CertUtil -hashfile C:\Program Files (x86)\FOG\tmp\TeamViewer-AllSites.sfx.exe SHA512 (certutil.exe is supposed to be installed on Windows systems) - or install Powershell v4 and run Get-FileHash C:\Program Files (x86)\FOG\tmp\TeamViewer-AllSites.sfx.exe -Algorithm SHA512 | Format-List (https://docs.microsoft.com/en-us/powershell/module/Microsoft.PowerShell.Utility/Get-FileHash?view=powershell-5.1)

    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

    G 2 Replies Last reply Nov 27, 2019, 2:07 PM Reply Quote 0
    • E
      EduardoTSeoane
      last edited by Nov 27, 2019, 8:25 AM

      Try to verify than the snapin is replicated on the StorageNode.

      I have that problem on my 1.5.6 and my solution was the snapin replication.

      G 1 Reply Last reply Nov 27, 2019, 2:51 PM Reply Quote 0
      • G
        Greg Plamondon Testers @Sebastian Roth
        last edited by Greg Plamondon Nov 27, 2019, 8:15 AM Nov 27, 2019, 2:07 PM

        @Sebastian-Roth said in snapin hash does not match on storage node (1.5.7.55):

        Get-FileHash C:\Program Files (x86)\FOG\tmp\TeamViewer-AllSites.sfx.exe

        fogsnapinhash.log
        [11-26-19 4:43:20 pm]  * Trying Snapin hash for: 01 - MTS-TeamViewer, ID: 129
        [11-26-19 4:43:20 pm]  * Getting snapin hash and size for: 01 - MTS-TeamViewer.
        [11-26-19 4:43:20 pm]  | Hash: 8de8056083825bd98a731ede61073f59f8d472b957e20e4bcbce103abd05c9d722d37c26c633c2e831e9628fb4fdeca998e719ffd9b16dd0f3c4dd63df2ab0af
        
        [root@10fogserver ~]# sha512sum /opt/fog/snapins/TeamViewer-AllSites.sfx.exe
        8de8056083825bd98a731ede61073f59f8d472b957e20e4bcbce103abd05c9d722d37c26c633c2e831e9628fb4fdeca998e719ffd9b16dd0f3c4dd63df2ab0af  /opt/fog/snapins/TeamViewer-AllSites.sfx.exe
        [root@10fogserver ~]#
        
        [root@13Storage ~]# sha512sum /opt/fog/snapins/TeamViewer-AllSites.sfx.exe
        8de8056083825bd98a731ede61073f59f8d472b957e20e4bcbce103abd05c9d722d37c26c633c2e831e9628fb4fdeca998e719ffd9b16dd0f3c4dd63df2ab0af  /opt/fog/snapins/TeamViewer-AllSites.sfx.exe
        [root@13Storage ~]#
        

        alt text

        1 Reply Last reply Reply Quote 0
        • G
          Greg Plamondon Testers @EduardoTSeoane
          last edited by Nov 27, 2019, 2:51 PM

          @EduardoTSeoane It is replicated. I even deleted it and waited for it to replicate again.

          E 1 Reply Last reply Nov 27, 2019, 2:58 PM Reply Quote 0
          • E
            EduardoTSeoane @Greg Plamondon
            last edited by Nov 27, 2019, 2:58 PM

            @Greg-Plamondon
            Have you try to execute the file manually?
            Have you compared the size?
            Maybe the download is not correct.

            G 2 Replies Last reply Nov 27, 2019, 2:59 PM Reply Quote 0
            • G
              Greg Plamondon Testers @EduardoTSeoane
              last edited by Nov 27, 2019, 2:59 PM

              @EduardoTSeoane I can execute the file manually and it installs fine. The file size is a match.

              1 Reply Last reply Reply Quote 0
              • G
                Greg Plamondon Testers @Sebastian Roth
                last edited by Greg Plamondon Dec 2, 2019, 1:59 PM Nov 27, 2019, 3:37 PM

                @Sebastian-Roth said in snapin hash does not match on storage node (1.5.7.55):

                @Greg-Plamondon When did you upload/update that snapin last? Possibly the FOGSnapinHash service just didn’t update the hash sum in the database yet.

                Are alll your nodes using the same FOG version?

                the nodes that are working are on Version: 1.5.7.4

                G 1 Reply Last reply Dec 2, 2019, 7:58 PM Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Nov 27, 2019, 4:23 PM

                  @Greg-Plamondon This is a really strange issue. We see the hashes match perfectly fine on the nodes and replication log. But the file being transfered to the Windows client has a different checksum.

                  Can you please try this: Use WinSCP to copy the file from one of the storage nodes to your Windows client and run Get-FileHash ... again.

                  As well, can you please use the mentioned CertUtil too?

                  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

                  G 1 Reply Last reply Dec 2, 2019, 8:18 PM Reply Quote 0
                  • G
                    Greg Plamondon Testers @Greg Plamondon
                    last edited by Greg Plamondon Dec 2, 2019, 2:03 PM Dec 2, 2019, 7:58 PM

                    @Greg-Plamondon said in snapin hash does not match on storage node (1.5.7.55):

                    @Sebastian-Roth said in snapin hash does not match on storage node (1.5.7.55):

                    @Greg-Plamondon When did you upload/update that snapin last? Possibly the FOGSnapinHash service just didn’t update the hash sum in the database yet.

                    Are alll your nodes using the same FOG version?

                    the nodes that are working are on Version: 1.5.7.4

                    Sorry I was wrong on the storage nodes that were not upgraded to 1.5.7.5 working correctly. They all seem to be having the same issue.

                    If I set the location of the host to the Fogserver instead of the storage node it works as it should. But this is not acceptable as the files are being pulled across the wan.

                    1 Reply Last reply Reply Quote 0
                    • G
                      Greg Plamondon Testers @Sebastian Roth
                      last edited by Greg Plamondon Dec 2, 2019, 2:24 PM Dec 2, 2019, 8:18 PM

                      @Sebastian-Roth said in snapin hash does not match on storage node (1.5.7.55):

                      Get-FileHash

                      I did as you asked and used Winscp to download the file from the storage node and ran Get-FileHash and CertUtil

                      alt text

                      1 Reply Last reply Reply Quote 0
                      • G
                        Greg Plamondon Testers @EduardoTSeoane
                        last edited by Greg Plamondon Dec 2, 2019, 3:27 PM Dec 2, 2019, 9:25 PM

                        @EduardoTSeoane said in snapin hash does not match on storage node (1.5.7.55):

                        @Greg-Plamondon
                        Have you try to execute the file manually?
                        Have you compared the size?
                        Maybe the download is not correct.

                        After doing some more investigating I found that the file sizes are indeed not the same. I was getting the information 2nd hand. I checked the "C:\Program Files(x86)\FOG\tmp folder for the snapin and it is only 1kb in size.

                        Sorry for the confusion.

                        ![alt text](a9baab26-c6b7-4a25-b67b-fad3dfda9121-image.png image url)

                        1 Reply Last reply Reply Quote 0
                        • G
                          Greg Plamondon Testers
                          last edited by Dec 2, 2019, 9:39 PM

                          Here is the access_log:

                          10.13.100.144 - - [02/Dec/2019:16:38:13 -0500] "GET /fog/management/other/ssl/srvpublic.crt HTTP/1.1" 200 1749 "-" "-"
                          10.13.100.144 - - [02/Dec/2019:16:38:13 -0500] "POST /fog/management/index.php?sub=requestClientInfo&authorize&newService HTTP/1.1" 200 326 "-" "-"
                          10.13.100.144 - - [02/Dec/2019:16:38:14 -0500] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 322 "-" "-"
                          10.13.100.144 - - [02/Dec/2019:16:38:14 -0500] "GET /fog/management/index.php?sub=requestClientInfo&mac=00:0C:29:62:EB:A0&newService&json HTTP/1.1" 200 10697 "-" "-"
                          10.13.100.144 - - [02/Dec/2019:16:38:14 -0500] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
                          10.13.100.144 - - [02/Dec/2019:16:38:15 -0500] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 8 "-" "-"
                          10.13.100.144 - - [02/Dec/2019:16:38:16 -0500] "GET /fog/service/snapins.checkin.php?taskid=9546&exitcode=-1&mac=00:0C:29:62:EB:A0&newService&json HTTP/1.1" 200 73 "-" "-"
                          10.13.100.144 - - [02/Dec/2019:16:38:16 -0500] "GET /fog/service/usertracking.report.php?action=login&user=13WIN10-IT%5Cgp1001&mac=00:0C:29:62:EB:A0&newService&json HTTP/1.1" 200 105 "-" "-"```
                          1 Reply Last reply Reply Quote 0
                          • S
                            Sebastian Roth Moderator
                            last edited by Dec 2, 2019, 9:55 PM

                            @Greg-Plamondon said in snapin hash does not match on storage node (1.5.7.55):

                            After doing some more investigating I found that the file sizes are indeed not the same. I was getting the information 2nd hand. I checked the "C:\Program Files(x86)\FOG\tmp folder for the snapin and it is only 1kb in size.

                            Please see if you can open that file (e.g. using Notepad++ or some other good editor) to see what the file looks like. Possibly this might give us a clue what’s going on here.

                            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

                            G 1 Reply Last reply Dec 2, 2019, 10:10 PM Reply Quote 0
                            • G
                              Greg Plamondon Testers @Sebastian Roth
                              last edited by Dec 2, 2019, 10:10 PM

                              @Sebastian-Roth
                              the contents of the file read:

                              "A valid database connection could not be made"
                              
                              1 Reply Last reply Reply Quote 0
                              • G
                                Greg Plamondon Testers
                                last edited by Greg Plamondon Dec 3, 2019, 7:24 AM Dec 3, 2019, 12:58 PM

                                I noticed that the fog version after the upgrade was not showing:

                                alt text

                                After I manually changed the fogstorage password in MySQL the versions started populating for the storage nodes that were upgraded but not for the storage nodes that were not upgraded.
                                is it possible that the upgrade corrupted the fogstorage MySQL password in the database on upgade or was it the mysql dump that was generated by Configuration Save> Export Database in the fog gui?

                                The more I think about it it would have to be the MySQL dump… I installed fog on a new Centos 8 build and imported the database after installing fog.

                                snapins are now downloading with the correct file sizes.

                                Thank you everyone for helping me with this issue!

                                1 Reply Last reply Reply Quote 1
                                • 1 / 1
                                1 / 1
                                • First post
                                  12/17
                                  Last post

                                162

                                Online

                                12.1k

                                Users

                                17.3k

                                Topics

                                155.4k

                                Posts
                                Copyright © 2012-2024 FOG Project