sw-sso db versioning problem

[WiReDWolF]

On debian 4.
Attempted to upgrade from 8.6 to 9.0
Solved a number of problems but can't get past this one:

Setting up sw-sso (2.2-r3488) ...

DB file already exists. Let's check for upgrade
DB update failed (Can not upgrade. DB version '1' is too old. You should upgrade it manually up to '4' at least). See log file for detailed output.
dpkg: error processing sw-sso (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
sw-sso
E: Sub-process /usr/bin/dpkg returned an error code (1)

Researching how to upgrade the versioning of the DB - it shows the Schema is version 1, needs 4 according to this error message - but the sso logs show that it's actually looking for version 7. Unfortunately there is nothing that I can find anywhere to help me update the versioning manually. The version of sw-sso is apparently current, just not the DB schema...

Any ideas?

 

[KilianSSL]

i'm also expiriencing this problem.
would be glad to see any suggestions how to fix this...

 

[euphbasio]

Any solution?

I'd also appreciate some suggestions, am having the same problem on 3 boxes (all of which have been brought back to life after the v9 update).

 

[euphbasio]

Any suggestions?

Did anyone find a solution to this? Anyone from Parallels care to offer support?

Thanks

 

[saisgroup.net]

Any solution????????

I have also the same problem.....
Beside I cant' access the server as ftp....

 

[guldi]

Same problem.
No one?

 

[ernsti]

On debian 4.
Attempted to upgrade from 8.6 to 9.0
Solved a number of problems but can't get past this one:

Setting up sw-sso (2.2-r3488) ...

DB file already exists. Let's check for upgrade
DB update failed (Can not upgrade. DB version '1' is too old. You should upgrade it manually up to '4' at least). See log file for detailed output.
dpkg: error processing sw-sso (--configure):
subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
sw-sso
E: Sub-process /usr/bin/dpkg returned an error code (1)

Researching how to upgrade the versioning of the DB - it shows the Schema is version 1, needs 4 according to this error message - but the sso logs show that it's actually looking for version 7. Unfortunately there is nothing that I can find anywhere to help me update the versioning manually. The version of sw-sso is apparently current, just not the DB schema...

Any ideas?

# rm /var/lib/dpkg/info/sw-sso.postinst
# apt-get install --reinstall sw-sso
Paketlisten werden gelesen... Fertig
Abhängigkeitsbaum wird aufgebaut... Fertig
0 aktualisiert, 0 neu installiert, 1 erneut installiert, 0 zu entfernen und 0 nicht aktualisiert.
1 nicht vollständig installiert oder entfernt.
Es müssen 0B Archive geholt werden.
Nach dem Auspacken werden 0B Plattenplatz zusätzlich benutzt.
Möchten Sie fortfahren [J/n]? j
Richte sw-sso ein (2.2-r3488) ...
# apt-get update

lg.
ernsti

 

[Spazholio]

If these don't work, you can always edit /var/lib/sso/sso.db (it's a sqlite DB) and change the one entry in the "schema_version" table to "7".

 

[guldi]

thx, ernsti's solution solved it for me!

 

[metalalisa]

My solution was to replace original sso.db by sso.db from another server with Plesk updated to version 10.0.1

I hope, Parallels with add this solution into KB

 

[iHuman]

I'm having this same problem metalalisa. My sso db is corrupt. But I don't have a second server. Any chance I can get a copy of the sso.db from you - or does anyone have any suggestions on how to rebuild the database?

 

[metalalisa]

try this file