9 Replies Latest reply on Jun 30, 2017 10:00 AM by cwinning

    Shavlik protect - Add servers or VMs

    tony87 Rookie

      Hello,

       

      We are managing a VMware environment of approx 400 VMs and 30 ESX hosts.

      I am starting to use Shavlik to patch our windows servers. My question is, what would be the benefit of adding machines manually in machine groups or adding them via our vcenter inventory? Is their a disadvantage using the vcenter inventory or something which might be caveat in the future?

       

      Also, after adding our vcenter, I notice it shows the VMs per host and not as in the folder structure as in vCenter itself.

      It's also not possible to search for VMs so when I want to add them to a machine group, I have to know on which ESX host they're currently running and find them like this. Isn't there an easier way?

       

       

      Regards.

        • 1. Re: Shavlik protect - Add servers or VMs
          cwinning CommunityTeam

          Hello,

           

          No advantage or disadvantage from adding machines from the vCenter inventory view.

           

          I would suggest upgrading to Patch for Windows Server (PWS) 9.3 (Protect renamed).  A new version of PWS 9.3  was released Tuesday, we are currently waiting for the link to be updated on the site.  I've uploaded to our FTP site though since upgrading to it would be beneficial to you. Your current key is valid for the upgrade.  ftp.landesk.com/incoming/IvantiPatchForServers_9.3.4440.exe.zip

           

          What this update offers is Machine Group searching which should make it easier to add the hosted VMs to the Machine Group. Help files on this feature.

           

          Simply go into the Hosted Virtual Machines tab and you will see search fields for the VM hosts on the left and one for the actual hosts to the right.  You can search for any data shown in the various columns of this tab.  Like Powered On, IP's, Memory size, host name, VM names etc etc.

           

          Thanks,

          Charles

          • 2. Re: Shavlik protect - Add servers or VMs
            tony87 Rookie

            Hi Charles,

             

            Ok - Thanks!

             

            Edit: link was not working but I was able to download 9.3 from shavlik.com website.

            • 3. Re: Shavlik protect - Add servers or VMs
              cwinning CommunityTeam

              Hello,

               

              I was able to use the link here at work and also from a home PC.  Any chance FTP is being blocking from you side?  This is unfortunately the only method I can share the file...

               

              The link for the new version should be up soon, hopefully today.  You could download the current version of 9.3 then upgrade to the new version once the link is available.

               

              Click on the Trial link on this web page.  The current version is 9.3.4379 and the new version will be 9.3.4440.

              https://go.ivanti.com/Web-Download-Patch-Windows.html

               

              Thanks,

              Charles

              • 4. Re: Shavlik protect - Add servers or VMs
                tony87 Rookie

                Hi Charles,

                 

                I managed to download 9.3.4440 from your FTP, issue was on our end.

                During the installation, I received an error when a link to the existing database is being made.

                Any idea?

                 

                 

                ST.DatabaseConfiguration.log:

                 

                2017-06-29T12:19:45.3112784Z 0001 I Program.cs:212|'G:\Program Files\LANDESK\Shavlik Protect\ST.DatabaseConfiguration.exe' is starting, version: 9.3.4440.0, full name: ST.DatabaseConfiguration, Version=9.3.0.0, Culture=neutral, PublicKeyToken=19306d7375e33918.

                2017-06-29T12:19:45.3581566Z 0001 I Program.cs:238|Database installation wizard started.

                2017-06-29T12:19:45.4362698Z 0001 S Program.cs:147|InstallInteractive|Entering.

                2017-06-29T12:19:52.9049464Z 0001 S InstallWizard.OnTransitionAwayHandlers.cs:16|PrepareConfigureSqlState|Entering.

                2017-06-29T12:19:53.0455702Z 0001 S InstallWizard.OnTransitionAwayHandlers.cs:16|PrepareConfigureSqlState|Leaving.

                2017-06-29T12:19:57.2330009Z 0001 S InstallWizard.TransitionGuardHandlers.cs:43|GetDatabaseConnectionState|Entering.

                2017-06-29T12:19:57.7329898Z 0001 S ConnectionValidator.cs:268|QueryConnectionState|Entering.

                2017-06-29T12:19:57.7486115Z 0001 S ConnectionValidator.cs:268|QueryConnectionState|Leaving.

                2017-06-29T12:19:57.7798652Z 0001 S SqlPrincipalManager.cs:420|QueryNameBySid|Entering.

                2017-06-29T12:19:57.7798652Z 0001 S SqlPrincipalManager.cs:420|QueryNameBySid|Leaving.

                2017-06-29T12:19:57.7798652Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:19:57.7954875Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:19:57.7954875Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:19:57.7954875Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:19:57.7954875Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:19:57.7954875Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:19:57.7954875Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:19:57.7954875Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:19:57.8111128Z 0001 S RoleManager.cs:32|IsInRole|Entering.

                2017-06-29T12:19:57.8111128Z 0001 S RoleManager.cs:32|IsInRole|Leaving.

                2017-06-29T12:19:57.8267395Z 0001 S InstallWizard.TransitionGuardHandlers.cs:43|GetDatabaseConnectionState|Leaving.

                2017-06-29T12:19:57.8423581Z 0001 E Program.cs:78|System.NullReferenceException: Object reference not set to an instance of an object.

                   at ST.Data.SchemaInstaller.SqlPrincipals.RoleManager.IsInRole(String connectionString, String userName, String role)

                   at ST.DatabaseConfiguration.ConnectionValidator.ValidateUpgradePermissions(DatabaseState currentConnectionState, ConnectionStringPair connectionPair)

                   at ST.DatabaseConfiguration.ConnectionValidator.VerifyRequiredPermission(DatabaseState currentConnectionState, Boolean isUpgrade, String connectionString, String servicesConnectionString)

                   at ST.DatabaseConfiguration.InstallWizard.CalculateDatabaseState(String serviceConnectionString, String connectionString, DatabaseState connectionState, Boolean isUpgrade)

                   at ST.DatabaseConfiguration.InstallWizard.GetDatabaseConnectionState(Boolean isUpgrade)

                   at ST.DatabaseConfiguration.InstallWizard.WizardNextClick(Object sender, WizardCommandButtonClickEventArgs e)

                   at DevExpress.XtraWizard.WizardControl.RaiseNextClick(BaseWizardPage page)

                   at DevExpress.XtraWizard.WizardControl.OnNextButtonClick(Object sender, EventArgs e)

                   at System.Windows.Forms.Control.OnClick(EventArgs e)

                   at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)

                   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

                   at System.Windows.Forms.Control.WndProc(Message& m)

                   at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)

                   at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)

                   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

                2017-06-29T12:20:07.7015647Z 0001 S InstallWizard.TransitionGuardHandlers.cs:43|GetDatabaseConnectionState|Entering.

                2017-06-29T12:20:07.8578137Z 0001 S ConnectionValidator.cs:268|QueryConnectionState|Entering.

                2017-06-29T12:20:07.8578137Z 0001 S ConnectionValidator.cs:268|QueryConnectionState|Leaving.

                2017-06-29T12:20:07.8578137Z 0001 S SqlPrincipalManager.cs:420|QueryNameBySid|Entering.

                2017-06-29T12:20:07.8578137Z 0001 S SqlPrincipalManager.cs:420|QueryNameBySid|Leaving.

                2017-06-29T12:20:07.8578137Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:20:07.8578137Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:20:07.8578137Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:20:07.8578137Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:20:07.8578137Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:20:07.8578137Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:20:07.8578137Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:20:07.8734414Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:20:07.8734414Z 0001 S RoleManager.cs:32|IsInRole|Entering.

                2017-06-29T12:20:07.8734414Z 0001 S RoleManager.cs:32|IsInRole|Leaving.

                2017-06-29T12:20:07.8734414Z 0001 S InstallWizard.TransitionGuardHandlers.cs:43|GetDatabaseConnectionState|Leaving.

                2017-06-29T12:20:08.5296698Z 0001 S InstallWizard.TransitionGuardHandlers.cs:43|GetDatabaseConnectionState|Entering.

                2017-06-29T12:20:08.6859202Z 0001 S ConnectionValidator.cs:268|QueryConnectionState|Entering.

                2017-06-29T12:20:08.6859202Z 0001 S ConnectionValidator.cs:268|QueryConnectionState|Leaving.

                2017-06-29T12:20:08.7015486Z 0001 S SqlPrincipalManager.cs:420|QueryNameBySid|Entering.

                2017-06-29T12:20:08.7015486Z 0001 S SqlPrincipalManager.cs:420|QueryNameBySid|Leaving.

                2017-06-29T12:20:08.7015486Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:20:08.7015486Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:20:08.7015486Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:20:08.7015486Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:20:08.7015486Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:20:08.7015486Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:20:08.7015486Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                2017-06-29T12:20:08.7015486Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                2017-06-29T12:20:08.7015486Z 0001 S RoleManager.cs:32|IsInRole|Entering.

                2017-06-29T12:20:08.7015486Z 0001 S RoleManager.cs:32|IsInRole|Leaving.

                2017-06-29T12:20:08.7015486Z 0001 S InstallWizard.TransitionGuardHandlers.cs:43|GetDatabaseConnectionState|Leaving.

                2017-06-29T12:20:23.3106708Z 0001 I Program.cs:129|The user has canceled the database installation.

                2017-06-29T12:20:23.4981652Z 0001 S Program.cs:147|InstallInteractive|Leaving.

                2017-06-29T12:20:23.4981652Z 0001 I Program.cs:277|Database installation complete.

                • 5. Re: Shavlik protect - Add servers or VMs
                  cwinning CommunityTeam

                  Hello,

                   

                  The account you are using to connect to the database doesn't have DBO rights to the database.  This document should help:  SQL Account Configuration - Privilege or Role Requirements for Protect Database

                   

                  You could try use the sysadmin account if you have access to it or another account, or attempt to increase the permissions of the account you are trying to use now.

                   

                  Thanks,

                  Charles

                  • 6. Re: Shavlik protect - Add servers or VMs
                    tony87 Rookie

                    I now have the dbowner role but still no luck:

                     

                     

                    2017-06-29T13:10:10.5343761Z 0001 S InstallWizard.TransitionGuardHandlers.cs:43|GetDatabaseConnectionState|Entering.

                    2017-06-29T13:10:10.6906160Z 0001 S ConnectionValidator.cs:268|QueryConnectionState|Entering.

                    2017-06-29T13:10:10.6906160Z 0001 S ConnectionValidator.cs:268|QueryConnectionState|Leaving.

                    2017-06-29T13:10:10.6906160Z 0001 S SqlPrincipalManager.cs:420|QueryNameBySid|Entering.

                    2017-06-29T13:10:10.6906160Z 0001 S SqlPrincipalManager.cs:420|QueryNameBySid|Leaving.

                    2017-06-29T13:10:10.6906160Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                    2017-06-29T13:10:10.7062865Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                    2017-06-29T13:10:10.7062865Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                    2017-06-29T13:10:10.7062865Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                    2017-06-29T13:10:10.7062865Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                    2017-06-29T13:10:10.7062865Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                    2017-06-29T13:10:10.7062865Z 0001 S PermissionManager.cs:165|HasPermission|Entering.

                    2017-06-29T13:10:10.7062865Z 0001 S PermissionManager.cs:165|HasPermission|Leaving.

                    2017-06-29T13:10:10.7062865Z 0001 S RoleManager.cs:32|IsInRole|Entering.

                    2017-06-29T13:10:10.7062865Z 0001 S RoleManager.cs:32|IsInRole|Leaving.

                    2017-06-29T13:10:10.7062865Z 0001 S InstallWizard.TransitionGuardHandlers.cs:43|GetDatabaseConnectionState|Leaving.

                    2017-06-29T13:10:10.7062865Z 0001 E Program.cs:78|System.NullReferenceException: Object reference not set to an instance of an object.

                       at ST.Data.SchemaInstaller.SqlPrincipals.RoleManager.IsInRole(String connectionString, String userName, String role)

                       at ST.DatabaseConfiguration.ConnectionValidator.ValidateUpgradePermissions(DatabaseState currentConnectionState, ConnectionStringPair connectionPair)

                       at ST.DatabaseConfiguration.ConnectionValidator.VerifyRequiredPermission(DatabaseState currentConnectionState, Boolean isUpgrade, String connectionString, String servicesConnectionString)

                       at ST.DatabaseConfiguration.InstallWizard.CalculateDatabaseState(String serviceConnectionString, String connectionString, DatabaseState connectionState, Boolean isUpgrade)

                       at ST.DatabaseConfiguration.InstallWizard.GetDatabaseConnectionState(Boolean isUpgrade)

                       at ST.DatabaseConfiguration.InstallWizard.WizardNextClick(Object sender, WizardCommandButtonClickEventArgs e)

                       at DevExpress.XtraWizard.WizardControl.RaiseNextClick(BaseWizardPage page)

                       at DevExpress.XtraWizard.WizardControl.OnNextButtonClick(Object sender, EventArgs e)

                       at System.Windows.Forms.Control.OnClick(EventArgs e)

                       at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)

                       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

                       at System.Windows.Forms.Control.WndProc(Message& m)

                       at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)

                       at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)

                       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

                    • 7. Re: Shavlik protect - Add servers or VMs
                      cwinning CommunityTeam

                      Hello,

                       

                      From the log, it's a permission issue, did you verify the other rights need per the document I link? (datereader, stexec etc) Unfortunately the logs won't tell us exactly that is missing.  Did another admin perform the install/upgrade?

                       

                      It may be faster to contact support and have them take a look at your permissions on a WebEx.

                       

                      Thanks,

                      Charles

                      • 8. Re: Shavlik protect - Add servers or VMs
                        tony87 Rookie

                        Thanks - I've opened up a support case.

                        • 9. Re: Shavlik protect - Add servers or VMs
                          cwinning CommunityTeam

                          Hello,

                           

                          Update for for anyone following this thread.  We added sysadmin rights to the account used to connect to the database, this allowed the database upgrade to proceed past the initial error.  The database upgrade failed due to it being mirrored in a SQL cluster which isn't support.  I believe the plan is to remove the database from the SQL cluster and upgrade the database Monday.

                           

                          Thanks,

                          Charles