Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 3472 views
  • Users 0 members are here
Options
Suggested
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

Sophos Enterprise Console Upgrade/Install

syphuric1977

Hi,

Is there a way to restore a SOPHOS3 database to be used in SOPHOS45?

The upgrade from 3.1 -> 4.5 failed, and as such I had to completely uninstall SOPHOS and then complete a fresh install of 4.5.

I have a backup of the 3.1 database.  Is there a way that this can be easily restored/upgrade to be used in 4.5?  I have tried the restoredb.bat file which restores the DB successfully.  However, when running the upgradedb.exe -debug -sourceVersion=3/=4 I receive the following error:

09.02.2011 20:09:44 Error: DBI exception thrown Could not find stored procedure
'dbo.FromXTo4'.

Any pointers or suggestions would be greatly appreciated.

:8977


This thread was automatically locked due to age.
  • 0

    It sounds as if you've used the restoredb.bat from version 4.5 to restore a sophos3 database (ie you have a file sophos45.mdf that is really a sophos3 database). This is the only reason I can think of that would explain the missing stored procedure.

    Instead you need to:

    1. Stop & disable the Sophos Management Service.
    2. Restore the sophos3.bak backup file to a sophos3 database:
      restoredb sophos3.bak server\instance sophos3
    3. Create a new, empty sophos45 database:
      cd /d "C:\Program Files (x86)\Sophos\Enterprise Console\DB"
      installdb server\instance
    4. Upgrade the sophos3 database to sophos45:
      cd /d "C:\Program Files(x86)\Sophos\Enterprise Console"
upgradedb -debug -sourceVersion=3
    5. Re-enable & restart the Sophos Management Service.

    Let us know if that works for you.

    Kindest regards,

    Tyler

    :9037
  • 0

    @syphuric1977  - did the above work for you?

    I ask because I get exactly the same error message when upgrading from SOPHOS45 to SOPHOS50. My empty SOPHOS50 database (created by InstallDB) only has one stored procedure in it, and that's the one referenced in InstallDBEX (dbo.AccountDomainGet ).

    :23189
  • 0

    Hello Chris_D,

    is there an error in InstallDB.log (this should be in the DB\Core directory)?

    As long as the database is empty (or, if you want, emptier than empty) it is safe to re-run InstallDB.bat. Either this successfully creates the database or there should be an error in the log.

    Christian

    :23191