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 5.5 dont start after update from sec 5.3

Sophos sec5.5 shows the following error and does not start the management server service

This thread was automatically locked due to age.

Parents

0 Christian Gonzalez over 7 years ago
Cancel
Vote Up 0 Vote Down

Cancel
0 QC over 7 years ago in reply to Christian Gonzalez

Hello Christian Gonzalez,

what is the error you get (perhaps check the Windows Event log) when you try to start the service?

Christian
Cancel
Vote Up 0 Vote Down

Cancel

0 Christian Gonzalez over 7 years ago in reply to QC

Hi Christian, 


In advance thanks for taking care of my request.




I try whit the next KB 113946 65420 111429..... but still continued whit the problem.

0 QC over 7 years ago in reply to Christian Gonzalez

Hello Christian Gonzalez,

so what happens when you run UpgradeDB.exe? Could you show the command and its output?

Christian
Cancel
Vote Up 0 Vote Down

Cancel
0 Christian Gonzalez over 7 years ago in reply to QC
Cancel
Vote Up 0 Vote Down

Cancel
0 QC over 7 years ago in reply to Christian Gonzalez

Hello Christian Gonzalez,

sourceVersion=521 should be the correct choice. But I see you also have a SOPHOS540 database - where does it come from?

Please run UpgradeDB.exe -reset and then try again. Might or might not help. It's also safe and worth a try to run InstallDB.bat. to recreate the SOPHOS550 database.

Christian
Cancel
Vote Up 0 Vote Down

Cancel

0 Christian Gonzalez over 7 years ago in reply to QC

I installing the databse SOPHOS540 because i think that this help whit the migration of information between databases.

Another question, what happen if i delete the databases SOPHOS521?

AND... do not work, look the message.

0 Christian Gonzalez over 7 years ago in reply to QC

And the strange thing is that in the company in which the work and had solved an identical situation, but with this if not managed to find the error a weight of which is that has to do with the bases of

+1 QC over 7 years ago in reply to Christian Gonzalez

Hello Christian Gonzalez,

the screenshot shows that the SOPHOS550 database is no longer there. You should run InstallDB.bat (from the %ProgramFiles%\Sophos\Enterprise Console\DB\Core\, make sure it's the correct one, it should contain the line @IF "%3" == "" SET databaseName=SOPHOS550). Afterwards run UpgradeDB.exe -sourceVersion=521.

You don't need (in fact, they are ignored) any "intermediate" database(s) as long as you are on a supported upgrade path. The SEC installer's setup.exe determines the "source" database from the version of the installed Database component and calls UpgradeDB.exe with the according sourceVersion.

If you delete the SOPHOS521 database you lose all your settings, groups, policies, and endpoint data including alerts and events. You're effectively starting from scratch.

Christian
Cancel
Vote Up 0 Vote Down

Cancel

Reply

+1 QC over 7 years ago in reply to Christian Gonzalez

Hello Christian Gonzalez,

the screenshot shows that the SOPHOS550 database is no longer there. You should run InstallDB.bat (from the %ProgramFiles%\Sophos\Enterprise Console\DB\Core\, make sure it's the correct one, it should contain the line @IF "%3" == "" SET databaseName=SOPHOS550). Afterwards run UpgradeDB.exe -sourceVersion=521.

You don't need (in fact, they are ignored) any "intermediate" database(s) as long as you are on a supported upgrade path. The SEC installer's setup.exe determines the "source" database from the version of the installed Database component and calls UpgradeDB.exe with the according sourceVersion.

If you delete the SOPHOS521 database you lose all your settings, groups, policies, and endpoint data including alerts and events. You're effectively starting from scratch.

Christian
Cancel
Vote Up 0 Vote Down

Cancel

Children

+1 Christian Gonzalez over 7 years ago in reply to QC

Thanks..... I Apply the Sophos Support and they provided me an code for make Upgrade...But since I had deleted the database, I managed to open the console but everything was lost

This is the Code, you know for what this Code make for me?

sqlcmd -E -S .\SOPHOS -d SOPHOS550 -q "Update Upgrade Set UpgradeStatus=2"
Cancel
Vote Up 0 Vote Down

Cancel
0 QC over 7 years ago in reply to Christian Gonzalez

Hello Christian Gonzalez,

do you now have the migrated data or not (if not, do you have the backup of SOPHOS521)?

The command sets a value that tells the management service that the migration was successful.

Christian
Cancel
Vote Up 0 Vote Down

Cancel