<SOLVED> How to correct chat database or remove chat application/upgrade?

Ask questions about your setup or get help installing ZCS server (ZD section below).
Post Reply
sr57
Posts: 32
Joined: Tue Feb 18, 2020 8:16 am
ZCS/ZD Version: zmcontrol -v Release 8.8.15.GA.4179

<SOLVED> How to correct chat database or remove chat application/upgrade?

Post by sr57 »

I discovered that my db had some errors during my last update to version 8.8.11.

I corrected my database following this link https://wiki.zimbra.com/wiki/Mysql_Crash_Recovery

But, I "forgot" the chat db in the repair process, nevertheless, my zimbra works well in version 8.8.11without the chat db since I don't use/need it.

Now I want to upgrade it in version 8.8.15 but I get an fatal error during the install process because of "chat elements" missing.

I'm looking for a solution to correct the chat db or to remove the chat app in order to be able to upgrade.
sr57
Posts: 32
Joined: Tue Feb 18, 2020 8:16 am
ZCS/ZD Version: zmcontrol -v Release 8.8.15.GA.4179

Re: <SOLVED> How to correct chat database or remove chat application/upgrade?

Post by sr57 »

Don't know if there is a simpler method but what I did :
- Reactivate a backup
- Dump the chat db
- Reactivate my zimbra
- Recreate my chat db from the dump
ghen
Outstanding Member
Outstanding Member
Posts: 258
Joined: Thu May 12, 2016 1:56 pm
Location: Belgium
ZCS/ZD Version: 9.0.0

Re: <SOLVED> How to correct chat database or remove chat application/upgrade?

Post by ghen »

Take a look at the upgrade scripts for chat:

/opt/zimbra/libexec/scripts/migrate20170301-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20180301-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20190401-ZimbraChat.pl
/opt/zimbra/libexec/scripts/migrate20190611-ZimbraChat.pl

They contain the SQL statements to (re)create and upgrade the chat db.
Post Reply