This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Upgrade Sophos 4.7 to 5.2 in a domain environment

Hi

I had 4.7 running fine and had upgraded to 5.1 successfully. Something went wrong during upgrade to 5.2. I now get "unable to install database" 

Typing C:\Users\Administrator>sqlcmd -E -S (local)\SOPHOS -Q "SELECT name, filename from sysdatabases" > C:\databases.txt produced:

name                                                                                                                             filename                                                                                                                                                                                                                                                            -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- master                                                                                                                           C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\master.mdf                                                                                                                                                                                    tempdb                                                                                                                           C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\tempdb.mdf                                                                                                                                                                                    model                                                                                                                            C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\model.mdf                                                                                                                                                                                     msdb                                                                                                                             C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\MSDBData.mdf                                                                                                                                                                                  SOPHOS47                                                                                                                         C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOS47.mdf                                                                                                                                                                                  SOPHOS51                                                                                                                         C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOS51.mdf                                                                                                                                                                                  SOPHOSPATCH51                                                                                                                    C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSPATCH51.mdf                                                                                                                                                                             SOPHOSENC51                                                                                                                      C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSENC51.mdf                                                                                                                                                                               SOPHOS52                                                                                                                         C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOS52.mdf                                                                                                                                                                                  SophosSecurity                                                                                                                   C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SophosSecurity.mdf                                                                                                                                                                            SOPHOSPATCH52                                                                                                                    C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSPATCH52.mdf                                                                                                                                                                             SOPHOSENC52                                                                                                                      C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSENC52.mdf                                                                                                                                                                              

(12 rows affected)

An extract from the install log is below:

Property(S): USERNAME = Windows User Property(S): DATABASE = C:\Windows\Installer\498c87.msi Property(S): OriginalDatabase = C:\sec_52\ServerInstaller\Database64.msi Property(S): UILevel = 2 Property(S): Preselected = 1 Property(S): ACTION = INSTALL Property(S): ROOTDRIVE = X:\ Property(S): CostingComplete = 1 Property(S): OutOfDiskSpace = 0 Property(S): OutOfNoRbDiskSpace = 0 Property(S): PrimaryVolumeSpaceAvailable = 0 Property(S): PrimaryVolumeSpaceRequired = 0 Property(S): PrimaryVolumeSpaceRemaining = 0 Property(S): INSTALLLEVEL = 1 Property(S): DomainOrComputerName = RAVENSCROFT Property(S): SOURCEDIR = C:\sec_52\ServerInstaller\ Property(S): SourcedirProduct = {785EEA74-C97F-4805-B017-112D88248C97} Property(S): ProductToBeRegistered = 1 MSI (s) (80:C8) [09:44:40:911]: Note: 1: 1708 MSI (s) (80:C8) [09:44:40:912]: Product: Sophos Management Database -- Installation failed.

MSI (s) (80:C8) [09:44:40:913]: Windows Installer installed the product. Product Name: Sophos Management Database. Product Version: 5.2.0. Product Language: 1033. Manufacturer: Sophos Limited. Installation success or error status: 1603.

MSI (s) (80:C8) [09:44:40:915]: Deferring clean up of packages/files, if any exist MSI (s) (80:C8) [09:44:40:915]: MainEngineThread is returning 1603 MSI (s) (80:F0) [09:44:40:915]: No System Restore sequence number for this installation. === Logging stopped: 15/07/2013  09:44:40 === MSI (s) (80:F0) [09:44:40:916]: User policy value 'DisableRollback' is 0 MSI (s) (80:F0) [09:44:40:916]: Machine policy value 'DisableRollback' is 0 MSI (s) (80:F0) [09:44:40:916]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (80:F0) [09:44:40:917]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 MSI (s) (80:F0) [09:44:40:917]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 MSI (s) (80:F0) [09:44:40:917]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1 MSI (s) (80:F0) [09:44:40:918]: Restoring environment variables MSI (s) (80:F0) [09:44:40:918]: Destroying RemoteAPI object. MSI (s) (80:D4) [09:44:40:918]: Custom Action Manager thread ending. MSI (c) (2C:2C) [09:44:40:920]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1 MSI (c) (2C:2C) [09:44:40:921]: MainEngineThread is returning 1603 === Verbose logging stopped: 15/07/2013  09:44:40 ===

Please help.

Charles

:41657


This thread was automatically locked due to age.
  • Hello Charles,

    is there a line with Return value 3 in the log? The reason for the failure should be in the preceding lines. Apparently the database has been created so maybe one of the Sophos_Install...  or Sophos_Upgrade... scripts failed (their logs are in the same folder).

    Christian 

    :41697