migrating calendar DB form one host to another

i try to migrate the calendar backend database to a different host:

pkginfo -l SUNWics5 gives me

VERSION: 6.0, REV=2003.11.14.18.12.58

for both installation

what i try is

csbackup -f database /tmp/calbackup on host A

and

csrestore database /tmp/calbackup on host B

after the restore i have several problems:

"csdb check" returns:

Failed dbversion check. Version numbers are mismatched.

Please migrate the DB using csmigrate tool.

Calendar database consistency check failed, error = -2

"csmigrate /var/opt/SUNWics5/csdb /tmp/calbackup.postmigrate" returns:

Failure during database migration, Target DB open failed

"cscal list" gives me:

Failed dbversion check. Version numbers are mismatched.

Please migrate the DB using cs5migrate tool.

the cs5migrate tool is part of patch 116577, however this patch is

obsoleted by patch 121657 which comes without cs5migrate

[985 byte] By [mwohlfa] at [2007-11-27 6:19:53]
# 1

Hi,

Although the underlying version of calendar is the same, how about the OS?

Also what patch level do you have on each system (old vs. new)?

showrev -p | grep ics5

>> the cs5migrate tool is part of patch 116577, however this patch is

>> obsoleted by patch 121657 which comes without cs5migrate

Correct. The cs5migrate utility is for going from 5.1.1 -> 6.2. To go to 6.3, you need to upgrade from 6.2 (there is no direct 5.1.1 -> 6.3 migration path).

Regards,

Shane.

shane_hjortha at 2007-7-12 17:34:53 > top of Java-index,E-Mail, Calendar, & Collaboration,Sun Java System Calendar Server...
# 2

Hi shane,

thanks for your help, i have Solaris 10 with a slighly different Kernel patchlevel:

newHost: SunOS 5.10 Generic_118833-36

oldHost: SunOS 5.10 Generic_118833-03

The CalServer Patchlevels are:

newHost: showrev -p | grep ics5

Patch: 121657-15 Obsoletes: 117706-08, 116577-36 Requires: Incompatibles: Packages: SUNWics5, SUNWica5

Patch: 122737-15 Obsoletes: Requires: Incompatibles: Packages: SUNWics5, SUNWica5

Patch: 121657-17 Obsoletes: 117706-08, 116577-43 Requires: Incompatibles: Packages: SUNWics5, SUNWica5

oldHost: showrev -p | grep ics5

Patch: 116577-24 Obsoletes: 117706-08 Requires: Incompatibles: Packages: SUNWics5, SUNWica5

Patch: 117860-16 Obsoletes: Requires: Incompatibles: Packages: SUNWics5, SUNWica5

Patch: 118186-16 Obsoletes: Requires: Incompatibles: Packages: SUNWics5, SUNWica5, SUNWfrics, SUNWdeics, SUNWesics

Patch: 116577-33 Obsoletes: 117706-08 Requires: Incompatibles: Packages: SUNWics5, SUNWica5

CalServer gives me a hard time to find out the actual version, i tried almost every command in sbin with a "-version" option ;-)

is there a way to find out the actual version ?

The only thing i could find out was the Version of the Berkely Database used because this shows up in the admin.log:

[04/Jun/2007:14:16:40 +0200] bert csdb[12497]: Store Critical: Failed DB version check, expected 4.0.0 [BerkeleyDB] found 3.0.0 [BerkeleyDB]

mwohlfa at 2007-7-12 17:34:53 > top of Java-index,E-Mail, Calendar, & Collaboration,Sun Java System Calendar Server...
# 3

Hi

> thanks for your help, i have Solaris 10 with a

> slighly different Kernel patchlevel:

>

> newHost: SunOS 5.10 Generic_118833-36

> oldHost: SunOS 5.10 Generic_118833-03

Ok that should be fine. Problems come about when you transfer across hardware platforms (i.e. Sparc vs x86) due to endian issues etc. etc.

> The CalServer Patchlevels are:

>

> newHost: showrev -p | grep ics5

> Patch: 121657-15 Obsoletes: 117706-08, 116577-36

> Requires: Incompatibles: Packages: SUNWics5,

> SUNWica5

> Patch: 122737-15 Obsoletes: Requires:

> Incompatibles: Packages: SUNWics5, SUNWica5

> atch: 121657-17 Obsoletes: 117706-08, 116577-43

> Requires: Incompatibles: Packages: SUNWics5,

> SUNWica5

121657-17 is Sun Calendar Server 6.3

> oldHost: showrev -p | grep ics5

> Patch: 116577-24 Obsoletes: 117706-08 Requires:

> Incompatibles: Packages: SUNWics5, SUNWica5

> atch: 117860-16 Obsoletes: Requires: Incompatibles:

> Packages: SUNWics5, SUNWica5

> atch: 118186-16 Obsoletes: Requires: Incompatibles:

> Packages: SUNWics5, SUNWica5, SUNWfrics, SUNWdeics,

> SUNWesics

> atch: 116577-33 Obsoletes: 117706-08 Requires:

> Incompatibles: Packages: SUNWics5, SUNWica5

116577-33 is Sun Calendar Server 6.2

> CalServer gives me a hard time to find out the

> actual version, i tried almost every command in sbin

> with a "-version" option ;-)

> is there a way to find out the actual version ?

Go by the patch-level you have installed.

> The only thing i could find out was the Version of

> the Berkely Database used because this shows up in

> the admin.log:

> [04/Jun/2007:14:16:40 +0200] bert csdb[12497]: Store

> Critical: Failed DB version check, expected 4.0.0

> [BerkeleyDB] found 3.0.0 [BerkeleyDB]

What it looks like you are doing is actually 'upgrading' whilst transferring the database since one system is SCS6.2 and the other is SCS6.3. Now I'm not sure if that can be done in the way you have proposed -- suggest you have a look at the comm-suite-5 upgrade guide..

http://www.sun.com/bigadmin/hubs/comms/

My interweb appears to be busted at the moment (hope this post works ;))

Regards,

Shane.

shane_hjortha at 2007-7-12 17:34:53 > top of Java-index,E-Mail, Calendar, & Collaboration,Sun Java System Calendar Server...
# 4
thanks Shane,so the right appoarch would be:* install SCS6.2 on the new host,* transfer the data * then upgrade the new host to SCS6.3 including the databasebest regardsMichael
mwohlfa at 2007-7-12 17:34:53 > top of Java-index,E-Mail, Calendar, & Collaboration,Sun Java System Calendar Server...
# 5
Hi,Sounds like a plan to me - transferring a database between identical system has a much higher chance of success.Regards,Shane.
shane_hjortha at 2007-7-12 17:34:53 > top of Java-index,E-Mail, Calendar, & Collaboration,Sun Java System Calendar Server...