Hi..

I just updated from 4.5.6 to 4.5.7 but something seems to have gone wrong.
The upgrade from 4.5.5 to 4.5.6 went smoothly back when I did that (first one not to required changing get_plat I think).

I have it installed on a SLES10 server.

There doesn't seem to be any errors in the database as is. I tried looking at the tables it complained about before going further but it wouldn't repair them as such and they looked to be okay.

I hope someone here can help me get back on track. It looks like the users at least are in the database, but are not seen?

Do you need more information?

zimbra:/tmp/zcs # ./install.sh

Operations logged to /tmp/install.log.32237
Checking for existing installation...
zimbra-ldap...FOUND zimbra-ldap-4.5.6_GA_1044
zimbra-logger...FOUND zimbra-logger-4.5.6_GA_1044
zimbra-mta...FOUND zimbra-mta-4.5.6_GA_1044
zimbra-snmp...FOUND zimbra-snmp-4.5.6_GA_1044
zimbra-store...FOUND zimbra-store-4.5.6_GA_1044
zimbra-apache...FOUND zimbra-apache-4.5.6_GA_1044
zimbra-spell...FOUND zimbra-spell-4.5.6_GA_1044
zimbra-core...FOUND zimbra-core-4.5.6_GA_1044

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.8p12-18.2
libidn...FOUND libidn-0.6.0-14.2
curl...FOUND curl-7.15.1-19.2
fetchmail...FOUND fetchmail-6.3.2-15.2
gmp...FOUND gmp-4.1.4-20.2
/usr/lib/libstdc++.so.5...FOUND
Checking current number of databases...

Do you want to verify message store database integrity? [Y] 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=NQ0Y0UmsuW8tl3hfwDR3UMgY --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.mailbox_metadata
error : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" 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] 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
You appear to be installing packages on a platform different
than the platform for which they were built

This platform is SuSEES10
Packages found: zimbra-core-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm
This may or may not work


Install anyway? [N] y

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

Shutting down zimbra mail
STOPPING server from pid file /opt/zimbra/db/mysql.pid
071004 22:01:21 mysqld ended


Backing up ldap


Removing existing packages

zimbra-ldap...done
zimbra-logger...done
zimbra-mta...done
zimbra-snmp...done
zimbra-store...done
zimbra-spell...done
zimbra-apache...done
zimbra-core...done

Removing deployed webapp directories
mv: target '/opt/zimbra/openldap-data/' is not a directory: Ingen sådan fil eller filkatalog
Installing packages

zimbra-core......zimbra-core-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm...done
zimbra-ldap......zimbra-ldap-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm...done
zimbra-logger......zimbra-logger-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm...done
zimbra-mta......zimbra-mta-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm...done
zimbra-snmp......zimbra-snmp-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm...done
zimbra-store......zimbra-store-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm...done
zimbra-apache......zimbra-apache-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm...done
zimbra-spell......zimbra-spell-4.5.7_GA_1319.SuSE10-20070914180700.i386.rpm...done

Setting defaults from saved config in /opt/zimbra/.saveconfig/config.save
HOSTNAME=zimbra.liga.dk
LDAPHOST=zimbra.liga.dk
LDAPPORT=389
SNMPTRAPHOST=zimbra.liga.dk
SMTPSOURCE=admin@zimbra.liga.dk
SMTPDEST=admin@zimbra.liga.dk
SNMPNOTIFY=yes
SMTPNOTIFY=yes
LDAPROOTPW=W3RGLeqX
LDAPZIMBRAPW=W3RGLeqX
Restoring existing configuration file from /opt/zimbra/.saveconfig/config.save...done
Operations logged to /tmp/zmsetup.log.18932
Checking ldap status
Starting ldap
ERROR: account.NO_SUCH_SERVER (no such server: zimbra.liga.dk)
Checking ldap status
ERROR: account.NO_SUCH_SERVER (no such server: zimbra.liga.dk)
Setting defaults...Done
Setting defaults from existing config...Upgrading from 4.5.6_GA_1044 to 4.5.7_GA_1319
Stopping zimbra services
Verifying /opt/zimbra/conf/my.cnf
Starting mysql
Starting logger mysql
Thu Oct 4 22:13:49 2007: SELECT value FROM config WHERE name = 'db.version'
This appears to be 4.5.6_GA
Redolog Version: 1.12 New Redolog Version: 1.12
Stopping mysql
Stopping logger mysql
Checking ldap status
Starting ldap
Checking 3.0.M1
Checking 3.0.0_M2
Checking 3.0.0_M3
Checking 3.0.0_M4
Checking 3.0.0_GA
Checking 3.0.1_GA
Checking 3.1.0_GA
Checking 3.1.1_GA
Checking 3.1.2_GA
Checking 3.1.3_GA
Checking 3.1.4_GA
Checking 3.2.0_M1
Checking 3.2.0_M2
Checking 4.0.0_RC1
Checking 4.0.0_GA
Checking 4.0.1_GA
Checking 4.0.2_GA
Checking 4.0.3_GA
Checking 4.0.4_GA
Checking 4.0.5_GA
Checking 4.1.0_BETA1
Checking 4.5.0_BETA1
Checking 4.5.0_BETA2
Checking 4.5.0_RC1
Checking 4.5.0_RC2
Checking 4.5.0_GA
Checking 4.5.1_GA
Checking 4.5.2_GA
Checking 4.5.3_GA
Checking 4.5.4_GA
Checking 4.5.5_GA
Checking 4.5.6_GA
Updating from 4.5.6_GA
Checking 4.5.7_GA
Updating from 4.5.7_GA
Migrating amavisd-new to version 2.5.2
Checking /opt/zimbra/amavisd-new-2.4.1/db
Checking /opt/zimbra/amavisd-new-2.4.1/.spamassassin
Checking /opt/zimbra/amavisd-new-2.3.3/db
Checking /opt/zimbra/amavisd-new-2.3.3/.spamassassin
Checking /opt/zimbra/amavisd-new-2.3.1/db
Checking /opt/zimbra/amavisd-new-2.3.1/.spamassassin
Starting mysql
Stopping mysql
Stopping ldap
Upgrade complete
Checking for port conflicts
Saving config in /opt/zimbra/config.18932...Done
Operations logged to /tmp/zmsetup.log.18932
Setting local config values...Done
Creating SSL certificate...Done
Stopping ldap...done
Checking ldap status
Starting ldap
Saving CA in ldap...Done
Installing SSL certificate...Done
Creating server entry for zimbra.liga.dk...Done
Setting spell check URL...Done
Setting service ports on zimbra.liga.dk...Done
Adding zimbra.liga.dk to zimbraMailHostPool in default COS...Done
Installing skins...
sky
bare
sand
rose
steel
froggy
harvest
vanilla
lavender
Done
Setting Keyboard Shortcut Preferences...done.
Setting MTA auth host...Done
Setting TimeZone Preference...done.
Creating domain zimbra.liga.dk...Done
Creating user spam.etchzzov@zimbra.liga.dk...Done
Creating user ham.ldqnm2kiqv@zimbra.liga.dk...Done
Setting spam training accounts...Done
Initializing mta config...Done
Configuring SNMP...Done
Setting services on zimbra.liga.dk...Done
Setting up zimbra crontab...Done
Setting up syslog.conf...syslogd: no process killed
Failed

You have the option of notifying Zimbra of your installation.
This helps us to track the uptake of the Zimbra Collaboration Suite.
The only information that will be transmitted is:
The VERSION of zcs installed (4.5.7_GA_1319_SuSEES10)
The ADMIN EMAIL ADDRESS created (admin@zimbra.liga.dk)

Notify Zimbra of your installation? [Yes] y
Notifying Zimbra of installation via http://www.zimbra.com/cgi-bin/notify...zimbra.liga.dk

Notification complete

Starting servers...Done.
Installing zimlets...
com_zimbra_search
com_zimbra_date
com_zimbra_wikipedia
com_zimbra_email
com_zimbra_url
com_zimbra_arcade
com_zimbra_phone
com_zimbra_gtranslator
com_zimbra_photo
com_zimbra_ymaps
Done
Initializing Documents...Done
Restarting tomcat...Done


Operations logged to /tmp/zmsetup.log.18932


Configuration complete - press return to exit


prov> gad
zimbra.liga.dk

(Should have had mail.martinm-76.dk as well)

prov> gaa
spam.etchzzov@zimbra.liga.dk
ham.ldqnm2kiqv@zimbra.liga.dk
wiki@zimbra.liga.dk

(should have had at least martin@mail.martinm-76.dk also + admin@zimbra.liga.dk + testadmin@zimbra.liga.dk)


mysql> use zimbra
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------+
| Tables_in_zimbra |
+-------------------+
| config |
| current_volumes |
| mailbox |
| mailbox_metadata |
| out_of_office |
| service_status |
| table_maintenance |
| volume |
+-------------------+
8 rows in set (0.01 sec)

mysql> select * from config;
+-----------------+-------+-------------------+---------------------+
| name | value | description | modified |
+-----------------+-------+-------------------+---------------------+
| db.version | 36 | db schema version | 2007-01-22 15:50:46 |
| index.version | 2 | index version | 2006-09-02 19:28:15 |
| redolog.version | 1.12 | redolog version | 2007-07-07 02:14:22 |
+-----------------+-------+-------------------+---------------------+
3 rows in set (0.00 sec)

mysql> select * from current_volumes;
+-------------------+-----------------------------+-----------------+-----------------+
| message_volume_id | secondary_message_volume_id | index_volume_id | next_mailbox_id |
+-------------------+-----------------------------+-----------------+-----------------+
| 1 | NULL | 2 | 11 |
+-------------------+-----------------------------+-----------------+-----------------+
1 row in set (0.00 sec)

mysql> select * from mailbox_
mailbox_bits mailbox_id mailbox_metadata.mailbox_id mailbox_metadata.section
mailbox_group_bits mailbox_metadata mailbox_metadata.metadata
mysql> select * from mailbox_metadata;
+------------+---------+-----------------------------+
| mailbox_id | section | metadata |
+------------+---------+-----------------------------+
| 1 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 2 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 3 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 4 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 5 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 6 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 7 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 8 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 9 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
| 10 | ver | d1:vi10e4:vmaji1e4:vmini2ee |
+------------+---------+-----------------------------+
10 rows in set (0.00 sec)

mysql> select * from out_of_office;
Empty set (0.07 sec)

mysql> select * from service_status;
Empty set (0.00 sec)

mysql> select * from table_maintenance;
+---------------+-------------------+---------------------+--------------------+----------+
| database_name | table_name | maintenance_date | last_optimize_date | num_rows |
+---------------+-------------------+---------------------+--------------------+----------+
| mailbox5 | mail_item | 2006-09-04 01:30:05 | NULL | 11890 |
| mboxgroup5 | mail_item | 2007-01-23 01:30:18 | NULL | 40192 |
| mailbox5 | open_conversation | 2006-10-17 01:30:06 | NULL | 10838 |
| mboxgroup5 | open_conversation | 2007-01-23 01:30:18 | NULL | 13229 |
+---------------+-------------------+---------------------+--------------------+----------+
4 rows in set (0.03 sec)

mysql> select * from volume;
+----+------+----------+-------------------+-----------+-----------------+--------------+--------------------+----------------+-----------------------+
| id | type | name | path | file_bits | file_group_bits | mailbox_bits | mailbox_group_bits | compress_blobs | compression_threshold |
+----+------+----------+-------------------+-----------+-----------------+--------------+--------------------+----------------+-----------------------+
| 1 | 1 | message1 | /opt/zimbra/store | 12 | 8 | 12 | 8 | 0 | 4096 |
| 2 | 10 | index1 | /opt/zimbra/index | 12 | 8 | 12 | 8 | 0 | 4096 |
+----+------+----------+-------------------+-----------+-----------------+--------------+--------------------+----------------+-----------------------+
2 rows in set (0.00 sec)

mysql> select * from mailbox;
+----+----------+--------------------------------------+-----------------+--------------------+---------------+-----------------+-------------------+---------------+---------------+-------------------------------+
| id | group_id | account_id | index_volume_id | item_id_checkpoint | contact_count | size_checkpoint | change_checkpoint | tracking_sync | tracking_imap | comment |
+----+----------+--------------------------------------+-----------------+--------------------+---------------+-----------------+-------------------+---------------+---------------+-------------------------------+
| 1 | 1 | e0808669-d26e-427c-b2f7-b1cca2f9beef | 2 | 319 | 0 | 4996 | 31300 | 0 | 0 | g9r70pi4g@zimbra.liga.dk |
| 2 | 2 | 0baebca9-a6e9-46de-9be8-4acb04a3c9cb | 2 | 259 | 0 | 0 | 31100 | 0 | 0 | testadmin@zimbra.liga.dk |
| 3 | 3 | d02f1b74-efd4-4679-9629-b1f606fc229d | 2 | 6383 | 0 | 648580 | 33506 | 0 | 0 | admin@zimbra.liga.dk |
| 4 | 4 | d8f08a65-82d9-4744-8e83-7afbdb36f333 | 2 | 279 | 0 | 5001 | 31000 | 0 | 0 | wiki@mail.martinm-76.dk |
| 5 | 5 | e5e5fd91-a4a2-41c1-96a2-a6a617da7132 | 2 | 118259 | 150 | 449277142 | 158451 | 0 | 1 | martin@mail.martinm-76.dk |
| 6 | 6 | b0a3cd60-97bf-41ef-860c-8a4e031e9809 | 2 | 9665 | 0 | 183151 | 36094 | 0 | 0 | e0bafk4q.r@zimbra.liga.dk |
| 7 | 7 | b99a994a-4397-42c8-abb8-4d6233afbfbe | 2 | 359 | 0 | 0 | 31000 | 0 | 0 | tvyrkg0i@zimbra.liga.dk |
| 8 | 8 | 19f2e6ac-84cf-4c91-98a1-e5a81b3581e0 | 2 | 256 | 0 | 0 | 1 | 0 | 0 | wiki@zimbra.liga.dk |
| 9 | 9 | 2d31d5f3-51d2-4db5-808a-2a55fa2b0f21 | 2 | 256 | 0 | 0 | 1 | 0 | 0 | spam.etchzzov@zimbra.liga.dk |
| 10 | 10 | c5427d1d-1a3d-45de-b108-09744ffc0c0c | 2 | 256 | 0 | 0 | 1 | 0 | 0 | ham.ldqnm2kiqv@zimbra.liga.dk |
+----+----------+--------------------------------------+-----------------+--------------------+---------------+-----------------+-------------------+---------------+---------------+-------------------------------+
10 rows in set (0.00 sec)

Reran the install.sh script afterwards (In both cases I had this running in another shell:
while true; do chmod 640 /etc/sudoers; done)

The second time around it didn't complain about anything, however nothing had changed...