Removed help text in database_cleanup.sh which suggested that the intermediate dump...
[citadel] / citadel / database_cleanup.sh
1 #!/bin/bash
2
3 die () {
4         echo Exiting.
5         exit 1
6 }
7
8 DATA_DIR="/usr/local/citadel"
9
10 usage() {
11         echo "Usage: database_cleanup.sh [ -h citadel_dir ]"
12         exit 2
13 }
14
15 PARSED_ARGUMENTS=$(getopt -a -n database_cleanup.sh -o h: -- "$@")
16 VALID_ARGUMENTS=$?
17 if [ "$VALID_ARGUMENTS" != "0" ]; then
18         usage
19 fi
20
21 eval set -- "$PARSED_ARGUMENTS"
22 while :
23 do
24         case "$1" in
25                 -h | --alpha)
26                         DATA_DIR=${2}
27                         shift 2
28                         ;;
29                 # -- means the end of the arguments; drop this, and break out of the while loop
30                 --) shift; break ;;
31                 # If invalid options were passed, then getopt should have reported an error,
32                 # which we checked as VALID_ARGUMENTS when getopt was called...
33                 *) echo "Unexpected option: $1 - this should not happen."
34                         usage
35                         ;;
36         esac
37 done
38
39 DATA_DIR=$DATA_DIR/data
40
41 # If we're on an AppDir system, use the embedded db_tools.
42 if [ "${APPDIR}" != "" ] ; then
43         export PATH=${APPDIR}/usr/bin:$PATH
44         RECOVER=${APPDIR}/usr/bin/db_recover
45         DUMP=${APPDIR}/usr/bin/db_dump
46         LOAD=${APPDIR}/usr/bin/db_load
47
48 # If we're on an Easy Install system, use our own db_ tools.
49 elif [ -x /usr/local/ctdlsupport/bin/db_dump ] ; then
50         export PATH=/usr/local/ctdlsupport/bin:$PATH
51         RECOVER=/usr/local/ctdlsupport/bin/db_recover
52         DUMP=/usr/local/ctdlsupport/bin/db_dump
53         LOAD=/usr/local/ctdlsupport/bin/db_load
54
55 # usual install
56 else
57         if test -f /usr/bin/db_dump; then 
58                 RECOVER=/usr/bin/db_recover
59                 DUMP=/usr/bin/db_dump
60                 LOAD=/usr/bin/db_load
61         else
62                 if test -n "`ls /usr/bin/db?*recover`"; then
63                         # seems we have something debian alike thats adding version in the filename
64                         if test "`ls /usr/bin/db*recover |wc -l`" -gt "1"; then 
65                                 echo "Warning: you have more than one version of the Berkeley DB utilities installed." 1>&2
66                                 echo "Using the latest one." 1>&2
67                                 RECOVER=`ls /usr/bin/db*recover |sort |tail -n 1`
68                                 DUMP=`ls /usr/bin/db*dump |sort |tail -n 1`
69                                 LOAD=`ls /usr/bin/db*load |sort |tail -n 1`
70                         else
71                                 RECOVER=`ls /usr/bin/db*recover`
72                                 DUMP=`ls /usr/bin/db*dump`
73                                 LOAD=`ls /usr/bin/db*load`
74                         fi
75                 else
76                         echo "database_cleanup.sh cannot find the Berkeley DB utilities.  Exiting." 1>&2
77                         die
78                 fi
79
80         fi
81 fi
82
83 # Ok, let's begin.
84
85 clear
86 cat <<!
87
88 Citadel Database Cleanup
89 ---------------------------
90
91 This script exports, deletes, and re-imports your database.  If you have
92 any data corruption issues, this program may be able to clean them up for you.
93  
94 Please note that this program does a Berkeley DB dump/load, not a Citadel
95 export.  The export files are not generated by the Citadel export module.
96
97 WARNING #1:
98   MAKE A BACKUP OF YOUR DATA BEFORE ATTEMPTING THIS.  There is no guarantee
99   that this will work (in case of disk full, power failure, program crash)!
100
101 WARNING #2:
102   citserver must NOT be running while you do this.
103
104 WARNING #3:
105   Please try "cd $DATA_DIR; $RECOVER -c" first. Run citserver afterwards to 
106   revalidate whether its fixed or not, No news might be good news. Use this
107   tool only if that one fails to fix your problem.
108
109 WARNING #4:
110   You must have an amount of free space in /tmp that is at least twice
111   the size of your database. see the following output:
112
113 `df -h`
114
115 you will need `du -sh $DATA_DIR|sed "s;/.*;;"` of free space.
116
117 !
118
119 echo We will attempt to look for a Citadel database in $DATA_DIR
120 echo -n "Do you want to continue? "
121
122 read yesno
123 case "$yesno" in
124         "y" | "Y" | "yes" | "YES" | "Yes" )
125                 echo 
126                 echo DO NOT INTERRUPT THIS PROCESS.
127                 echo
128         ;;
129         * )
130                 exit
131 esac
132
133 for x in 00 01 02 03 04 05 06 07 08 09 0a 0b 0c 0d
134 do
135         filename=cdb.$x
136         echo Dumping $filename
137         $DUMP -h $DATA_DIR $filename >/tmp/CitaDump.$x || {
138                 echo error $?
139                 die
140         }
141         rm -vf $DATA_DIR/$filename
142 done
143
144 echo Removing old databases
145 rm -vf $DATA_DIR/*
146
147 for x in 00 01 02 03 04 05 06 07 08 09 0a 0b 0c 0d
148 do
149         filename=cdb.$x
150         echo Loading $filename
151         $LOAD -h $DATA_DIR $filename </tmp/CitaDump.$x && {
152                 rm -f /tmp/CitaDump.$x
153         }
154 done
155
156 echo 
157 echo Dump/load operation complete.  Start your Citadel server now.
158 echo