Help! My domain no longer shows up.. Users of main domain also missing.
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...
Found a workaround.. Would still like to now the 'correct' thing to do...
Okay... So I had verified that my data was in fact there and I had a backup from about two weeks ago if things went totally wrong.
Set about to figure out how I could one again receive mails and look at the more than 50000 mails I already had.
Inspired by the 'Per User Backup' scripts on this page:
Per User Mailbox Backup (OE Version) - ZimbraWiki
I decided to go ahead and recreate my domain and user.
That seemed to go quite well. I unfortunately couldn't force the ID my user already had, so now I have two of them...
su - zimbra
zmprov
prov> cd mail.martinm-76.dk
d03e8d13-5a73-4ee8-bc66-dbf79c5b71c3
prov> gad
mail.martinm-76.dk
zimbra.liga.dk
prov> createAccount martin@mail.martinm-76.dk [passwd]
1416cf57-cc60-4ef7-ba22-e37fc6cf1992
prov> modifyAccount martin@mail.martinm-76.dk zimbraMailCatchAllAddress @mail.martinm-76.dk
prov> md mail.martinm-76.dk zimbraMailCatchAllAddress @martinm-76.dk
prov> md mail.martinm-76.dk zimbraMailCatchAllAddress @mail.martinm-76.dk zimbraMailCatchAllCanonicalAddress @martinm-76.dk
Tried to switch them around in the 'mailbox' table so the user with all the mail would be used in stead. Looks like that didn't work (or should I have stopped and started zimbra after doing that?). Changed them back again.
This was my attempt:
mysql> update mailbox SET account_id='effe' WHERE id=11;
Query OK, 1 row affected (0.68 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update mailbox SET account_id='1416cf57-cc60-4ef7-ba22-e37fc6cf1992' WHERE id=5;
Query OK, 1 row affected (0.15 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update mailbox SET account_id='e5e5fd91-a4a2-41c1-96a2-a6a617da7132' WHERE id=11;
Query OK, 1 row affected (0.08 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Moving the tables in mboxgroup11 to different names and then copy-creating them from mboxgroup5 seems to have done the trick (but I *did* have to stop zimbra and start it again before it took hold, so maybe my first try would have worked too?)
mysql> create table mail_item1 AS SELECT * FROM mboxgroup5.mail_item WHERE mailbox_id=5;
Query OK, 51130 rows affected (7.12 sec)
Records: 51130 Duplicates: 0 Warnings: 0
mysql> alter table mail_item RENAME TO mail_item2;
Query OK, 0 rows affected (0.46 sec)
mysql> alter table mail_item1 RENAME TO mail_item;
Query OK, 0 rows affected (0.00 sec)
mysql> update mail_item SET mailbox_id=11 WHERE mailbox_id=5;
Query OK, 51130 rows affected (2.28 sec)
Rows matched: 51130 Changed: 51130 Warnings: 0
mysql> alter table open_conversation RENAME TO open_conversation2
-> ;
Query OK, 0 rows affected (0.06 sec)
mysql> create table open_conversation AS SELECT * from mboxgroup5.open_conversation;
Query OK, 18803 rows affected (0.29 sec)
Records: 18803 Duplicates: 0 Warnings: 0
mysql> update open_conversation SET mailbox_id=11 WHERE mailbox_id=5;
Query OK, 18803 rows affected (0.15 sec)
Rows matched: 18803 Changed: 18803 Warnings: 0
mysql> alter table appointment RENAME TO appointment1
-> ;
Query OK, 0 rows affected (0.09 sec)
mysql> create table appointment AS SELECT * from mboxgroup5.appointment;
Query OK, 356 rows affected (0.03 sec)
Records: 356 Duplicates: 0 Warnings: 0
mysql> update appointment SET mailbox_id=11 WHERE mailbox_id=5;
Query OK, 356 rows affected (0.01 sec)
Rows matched: 356 Changed: 356 Warnings: 0
mysql> select * from mboxgroup5.pop3_message;
Empty set (0.00 sec)
mysql> select * from mboxgroup5.tombstone;
Empty set (0.00 sec)
Now I need to figure out how I create an admin user, amongst other things...
Thanks for the reply and information
Ah, thank you mmorse...
Yeah, I decided to do something crazy and experiment a whole heck of a lot.
Quite a learning experience in the end.
I still wonder why all the accounts I had was not detected, though, but at least I'm up and running again (and with my latest tweaks (which I thought I had done - but missed the alias part) I now get the mail people send to me ;)).
Zimbra is pretty complex, but also a very nice piece of groupware... ;)
