Use this task to collect data when Calendar Server is experiencing a database problem in a standard database deployment.
A Calendar Server database problem can occur when there are errors in the Calendar Server backup database (obtained with the csbackup command) or when error messages in the logs identify problems in the integrity of the database.
Collect the general system information as explained in To Collect Required Debug Data for Any Calendar Server Problem.
(Solaris only) Run the cscapture script to gather a copy of the Calendar Server's database and additional information:
./cscapture -db
(Other platforms) Run the capture_environment.pl script.
First go to the directory where the script is located. For example:
cd /export/home/myscripts perl capture_environment.pl
This command creates a file named archive.tar.gz, which contains Calendar Server database logs, system statistics, and configuration information, and database information.
Get the output from the csdb check command.
The csdb check command reports errors on the Calendar Server backup database and on database corruption issues that turn up in the error logs.
This command can return false errors when it is run on a production server database.
cd cal-svr-base/cal/bin./csdb check
cd cal-svr-base\cal\bincsdb.exe check
Try to recover your database from a backup.
Read the section, “Checking and Rebuilding a Calendar Database” or “To Rebuild the Calendar Databases (caldb)” in the Calendar Server 6 Administration Guide:
Calendar Server 6.3: Sun Java System Calendar Server 6.3 Administration Guide
http://docs.sun.com/app/docs/doc/819–4654/6n6prj59n?a=view
Calendar Server 6.2 2005Q4: Chapter 16, Administering Calendar Server Databases with csdb, in Sun Java System Calendar Server 6 2005Q4 Administration Guide
http://docs.sun.com/app/docs/doc/819–2433/6n4nlfjs1?a=view
Calendar Server 6.2 2005Q1: Sun Java System Calendar Server 6 2005Q1 Administration Guide
http://docs.sun.com/source/819–0024/csagDatabases.html
Calendar Server 6.1 2004Q2: Sun Java Sytem Calendar Server 6 2004Q2 Administration Guide
http://docs.sun.com/source/817–5697/csagDatabases.html
Calendar Server 6.0 2003Q4:
http://docs.sun.com/source/816-6708–10/csag5.html
If the database is corrupted, and you have tried to recover it without success, provide a tar file of the entire database directory.
The path of the database is specified in the caldb.berkeleydb.homedir.path parameter in the ics.conf file.
For a Windows system, the following example shows the physical path of the database event, task, and alarm files:
caldb.berkeleydb.homedir.path = "C:/www/Cal6-1-1/CalendarServer6/var/csdb"
Obtain user information for at least 2 users impacted by the problem and 2 users unaffected by the problem.
If no users can connect to the database, please include this information.
Use the csattribute command to get the LDIF entry of each user. The csattribute command displays the user's DN and the attributes of the specified user. following is a sample DN:
uid=user1,ou=people,o=siroe.com,o=isp
Run the command as follows:
cal-svr-base/cal/sbin/csattribute -v list uid
csattribute -v list uid
where:
The directory on the Calendar Server machine dedicated to holding the Calendar Server program, and configuration, maintenance, and information files. The default location for UNIX and Linux versions of Calendar Server is /var/opt/mps/serverroot/.
User ID of the user you are searching for.
Get the LDIF entry of the domain where the impacted user resides.
Use the domain portion of the DN shown by the csattribute command in the preceding step.
dir-root/shared/bin/ldapsearch -h hostname -p port -D "cn=Directory Manager" -w password -s base -b "baseDN" "(objectclass=*)" > /tmp/domain.ldif
dir-root\shared\bin\ldapsearch.exe -h hostname -p port -D "cn=Directory Manager" -w password -s base -b "baseDN" "(objectclass=*)" > C:\domain.ldif
where:
The directory on the Directory Server machine dedicated to holding the server program, and configuration, maintenance, and information files. The default location for UNIX and Linux versions of Calendar Server is /var/opt/mps/serverroot/.
Name of the host running Directory Server. You can omit -h hostname if the Directory Server is running locally.
Port number on which Directory Server is listening. The default is 389. You can omit port if the Directory Server is running on port 389.
If you have not already done so, set the Calendar Server debug log level to Debug and provide all errors printed to the Calendar Server logs.
Provide all log files with pointers to timestamps or error messages.
If you have not already done so, provide specific steps showing how to reproduce the problem.
Include any observed error messages from the Web UI, WCAP commands, and the Calendar Server log files and timestamps showing when the error occurred.