Yes, this is my own fault. I got myself into it.

Any help getting out would be really appreciated.

I'd prefer not to lose a bunch of mail as I don't have a recent backup.

I was doing a 4.5.4 to 4.5.7 upgrade and started it when I saw a database error. I tried to quit it using Ctrl-C, and then go back and resolve the database error, but in reinstalling the original 4.5.4 packages, I think I messed up some configuration files.

In any case, if there's a way to restore the configuration for the purposes of the upgrade, I would really appreciate the help.

-------------------------------------
Log Transcript Follows (taken out some directory listing lines, but otherwise, its as it was)


zimbra:~ # su - zimbra
zimbra@zimbra:~> zmcontrol stop
Host zimbra.internet-host.com
Stopping mta...Done
Stopping spell...Done
Stopping snmp...Done
Stopping antivirus...Done
Stopping antispam...Done
Stopping imapproxy...Done
Stopping mailbox...Done
Stopping logger...Done
Stopping ldap...Done
zimbra@zimbra:~> version
SUSE LINUX Enterprise Server 9 (i586)
VERSION = 9
PATCHLEVEL = 3
Linux 2.6.5-7.267-default
gcc (GCC) 3.3.3 (SuSE Linux)


zimbra:~/zimbra/4.5.7_GA_1319/zcs # ./install.sh

Operations logged to /tmp/install.log.12570
Checking for existing installation...
zimbra-ldap...FOUND zimbra-ldap-4.5.4_GA_763
zimbra-logger...FOUND zimbra-logger-4.5.4_GA_763
zimbra-mta...FOUND zimbra-mta-4.5.4_GA_763
zimbra-snmp...FOUND zimbra-snmp-4.5.4_GA_763
zimbra-store...FOUND zimbra-store-4.5.4_GA_763
zimbra-apache...FOUND zimbra-apache-4.5.4_GA_763
zimbra-spell...FOUND zimbra-spell-4.5.4_GA_763
zimbra-core...FOUND zimbra-core-4.5.4_GA_763

Saving existing configuration file to /opt/zimbra/.saveconfig


PLEASE READ THIS AGREEMENT CAREFULLY BEFORE USING THE SOFTWARE.
ZIMBRA, INC. ("ZIMBRA") WILL ONLY LICENSE THIS SOFTWARE TO YOU IF YOU
FIRST ACCEPT THE TERMS OF THIS AGREEMENT. BY DOWNLOADING OR INSTALLING
THE SOFTWARE, OR USING THE PRODUCT, YOU ARE CONSENTING TO BE BOUND BY
THIS AGREEMENT. IF YOU DO NOT AGREE TO ALL OF THE TERMS OF THIS
AGREEMENT, THEN DO NOT DOWNLOAD, INSTALL OR USE THE PRODUCT.

License Terms for the Zimbra Collaboration Suite:
http://www.zimbra.com/license/collab...cense_1.0.html


Press Return to continue

Checking for prerequisites...
NPTL...FOUND
sudo...FOUND sudo-1.6.7p5-117.4
libidn...FOUND libidn-0.3.7-64.1
curl...FOUND curl-7.11.0-39.9
fetchmail...FOUND fetchmail-6.3.4-1
gmp...FOUND gmp-4.1.2-185.1
/usr/lib/libstdc++.so.5...FOUND
Checking current number of databases...

Do you want to verify message store database integrity? [Y]
Verifying integrity of message store databases. This may take a while.
Starting mysqld daemon with databases from /opt/zimbra/db/data
mysqld is alive
Generating report
Database errors found.
/opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=rVfbcvhEVX4x086hwaZn_keCi71od --auto-repair
mysql.help_category
error : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!
mysql.help_keyword
error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!
mysql.help_topic
error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!
mysql.user
error : Table upgrade required. Please do "REPAIR TABLE `user`" to fix it!
zimbra.config
error : Table upgrade required. Please do "REPAIR TABLE `config`" to fix it!
zimbra.out_of_office
error : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" to fix it!
zimbra.service_status
error : Table upgrade required. Please do "REPAIR TABLE `service_status`" to fix it!
zimbra.table_maintenance
error : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" to fix it!
zimbra.volume
error : Table upgrade required. Please do "REPAIR TABLE `volume`" to fix it!

Checking for installable packages

Found zimbra-core
Found zimbra-ldap
Found zimbra-logger
Found zimbra-mta
Found zimbra-snmp
Found zimbra-store
Found zimbra-apache
Found zimbra-spell


The Zimbra Collaboration Suite appears already to be installed.
It can be upgraded with no effect on existing accounts,
or the current installation can be completely removed prior
to installation for a clean install.

Do you wish to upgrade? [Y]

Select the packages to install
Upgrading zimbra-core
Upgrading zimbra-ldap
Upgrading zimbra-logger
Upgrading zimbra-mta
Upgrading zimbra-snmp
Upgrading zimbra-store
Upgrading zimbra-apache
Upgrading zimbra-spell
Checking required space for zimbra-core
checking space for zimbra-store

Installing:
zimbra-core
zimbra-ldap
zimbra-logger
zimbra-mta
zimbra-snmp
zimbra-store
zimbra-apache
zimbra-spell

The system will be modified. Continue? [N] y

Shutting down zimbra mail
STOPPING server from pid file /opt/zimbra/db/mysql.pid
071004 09:14:44 mysqld ended


Backing up ldap


Removing existing packages

zimbra-ldap...done
zimbra-logger...done
zimbra-mta...done
zimbra-snmp...done
zimbra-store...done

******** It was at this point that I tried to cancel with Ctrl-C because I saw the database errors above. *******

zimbra-spell...done
zimbra-apache...done
zimbra-core...done

Removing deployed webapp directories

zimbra:~/zimbra/4.5.7_GA_1319/zcs #
zimbra:~/zimbra/4.5.7_GA_1319/zcs #
zimbra:~/zimbra/4.5.7_GA_1319/zcs #
zimbra:~/zimbra/4.5.7_GA_1319/zcs #
zimbra:~/zimbra/4.5.7_GA_1319/zcs # ./install.sh

Operations logged to /tmp/install.log.13434
Checking for existing installation...
zimbra-ldap...NOT FOUND
zimbra-logger...NOT FOUND
zimbra-mta...FOUND zimbra-mta-4.5.4_GA_763
zimbra-snmp...NOT FOUND
zimbra-store...NOT FOUND
zimbra-apache...FOUND zimbra-apache-4.5.4_GA_763
zimbra-spell...FOUND zimbra-spell-4.5.4_GA_763
zimbra-core...FOUND zimbra-core-4.5.4_GA_763

Saving existing configuration file to /opt/zimbra/.saveconfig
cp: cannot stat `/opt/zimbra/java/jre/lib/security/cacerts': No such file or directory


PLEASE READ THIS AGREEMENT CAREFULLY BEFORE USING THE SOFTWARE.
ZIMBRA, INC. ("ZIMBRA") WILL ONLY LICENSE THIS SOFTWARE TO YOU IF YOU
FIRST ACCEPT THE TERMS OF THIS AGREEMENT. BY DOWNLOADING OR INSTALLING
THE SOFTWARE, OR USING THE PRODUCT, YOU ARE CONSENTING TO BE BOUND BY
THIS AGREEMENT. IF YOU DO NOT AGREE TO ALL OF THE TERMS OF THIS
AGREEMENT, THEN DO NOT DOWNLOAD, INSTALL OR USE THE PRODUCT.

License Terms for the Zimbra Collaboration Suite:
http://www.zimbra.com/license/collab...cense_1.0.html


Press Return to continue

Checking for prerequisites...
NPTL...FOUND
sudo...FOUND sudo-1.6.7p5-117.4
libidn...FOUND libidn-0.3.7-64.1
curl...FOUND curl-7.11.0-39.9
fetchmail...FOUND fetchmail-6.3.4-1
gmp...FOUND gmp-4.1.2-185.1
/usr/lib/libstdc++.so.5...FOUND
Checking current number of databases...

Checking for installable packages

Found zimbra-core
Found zimbra-ldap
Found zimbra-logger
Found zimbra-mta
Found zimbra-snmp
Found zimbra-store
Found zimbra-apache
Found zimbra-spell


The Zimbra Collaboration Suite appears already to be installed.
It can be upgraded with no effect on existing accounts,
or the current installation can be completely removed prior
to installation for a clean install.

Do you wish to upgrade? [Y]

Select the packages to install
Upgrading zimbra-core

Install zimbra-ldap [N] Y

Install zimbra-logger [N] Y
Upgrading zimbra-mta

Install zimbra-snmp [N] Y

Install zimbra-store [N] Y
Upgrading zimbra-apache
Upgrading zimbra-spell
Checking required space for zimbra-core
checking space for zimbra-store

Installing:
zimbra-core
zimbra-ldap
zimbra-logger
zimbra-mta
zimbra-snmp
zimbra-store
zimbra-apache
zimbra-spell

The system will be modified. Continue? [N]

Exit? [N] Y
Exiting - the system is unchanged
zimbra:~/zimbra/4.5.7_GA_1319/zcs # cd ..
zimbra:~/zimbra/4.5.7_GA_1319 # cd ..
zimbra:~/zimbra # cd 4.5.4_GA_763/
zimbra:~/zimbra/4.5.4_GA_763 # cd zcs/packages/
zimbra:~/zimbra/4.5.4_GA_763/zcs/packages # rpm -Uvh zimbra-ldap-4.5.4_GA_763.SuSEES9-20070323135217.i386.rpm zimbra-logger-4.5.4_GA_763.SuSEES9-20070323135217.i386.rpm zimbra-snmp-4.5.4_GA_763.SuSEES9-20070323135217.i386.rpm zimbra-store-4.5.4_GA_763.SuSEES9-20070323135217.i386.rpm
Preparing... ########################################### [100%]
1:zimbra-store ########################################### [ 25%]
mv: cannot stat `/opt/zimbra/db/db.sql': No such file or directory
2:zimbra-ldap ########################################### [ 50%]
3:zimbra-logger ########################################### [ 75%]
mv: cannot stat `/opt/zimbra/db/loggerdb.sql': No such file or directory
4:zimbra-snmp ########################################### [100%]
zimbra:~/zimbra/4.5.4_GA_763/zcs/packages # /opt/zimbra/libexec/zmdbintegrityreport
-bash: /opt/zimbra/libexec/zmdbintegrityreport: No such file or directory
zimbra:~/zimbra/4.5.4_GA_763/zcs/packages # su - zimbra
zimbra@zimbra:~> /opt/zimbra/libexec/zmdbintegrityreport
-bash: /opt/zimbra/libexec/zmdbintegrityreport: No such file or directory
zimbra@zimbra:~> locate zmdbintegrityreport
zimbra@zimbra:~> exit
logout
zimbra:~/zimbra/4.5.4_GA_763/zcs/packages # cd ..
zimbra:~/zimbra/4.5.4_GA_763/zcs # cd ..
zimbra:~/zimbra/4.5.4_GA_763 # cd ..
zimbra:~/zimbra # cd 4.5.7_GA_1319/
zimbra:~/zimbra/4.5.7_GA_1319 # cd zcs/


... continues below ...