Hello,
I'm currently experiencing some issues while updating my mail server from 8.8.15 to 9.0.0. I encountered the following error:
Schema upgrade required from version 111 to 118.
Running /opt/zimbra/libexec/scripts/migrate20210506-BriefcaseApi.pl
Mon Nov 6 15:37:33 2023: Verified schema version 111.
Mon Nov 6 15:39:56 2023: Verified schema version 111.
Mon Nov 6 15:39:56 2023: Updating DB schema version from 111 to 112.
ERROR 1036 (HY000) at line 1: Table 'config' is read only
Mon Nov 6 15:39:57 2023: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=PASSWORD --database=zimbra --batch --skip-column-names'.
Script failed with code 256: - exiting
UPGRADE FAILED - exiting.
I noticed that some others have posted the same error before, but I couldn't find a solution. If anyone has resolved this problem and can offer assistance, I would greatly appreciate it.
I am trying to update it on Ubuntu 18.04.6 LTS
Hi Ahmed,
We can understand your situation. But in your case, there are quite a few complexities.
1. Your host OS is 18.04LTS, a little bit old
2. Updating Zimbra from one version to another, especially on an old OS, is always tricky and full of surprises.
3. The roadmap of Zimbra 9 is yet not so firm.
Considering these facts, we would recommend the following:
1. Install a newer version of the host OS, possibly 20.04LTS, as almost all support it.
2. Configure a fresh email system (we would recommend Carbonio CE), but it's up to your preference; keep the facts of Zimbra 9 in mind.
3. Migrate the system and data from the old server to the new server.
We think this would be the best course of action for you.
We hope it helps. All the best 😊
Have a good day.
Thanks and regards,
Sharif
Hello,
I'm currently experiencing some issues while updating my mail server from 8.8.15 to 9.0.0. I encountered the following error:
Schema upgrade required from version 111 to 118.
Running /opt/zimbra/libexec/scripts/migrate20210506-BriefcaseApi.pl
Mon Nov 6 15:37:33 2023: Verified schema version 111.
Mon Nov 6 15:39:56 2023: Verified schema version 111.
Mon Nov 6 15:39:56 2023: Updating DB schema version from 111 to 112.
ERROR 1036 (HY000) at line 1: Table 'config' is read only
Mon Nov 6 15:39:57 2023: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=PASSWORD --database=zimbra --batch --skip-column-names'.
Script failed with code 256: - exiting
UPGRADE FAILED - exiting.I noticed that some others have posted the same error before, but I couldn't find a solution. If anyone has resolved this problem and can offer assistance, I would greatly appreciate it.
I am trying to update it on Ubuntu 18.04.6 LTS
Check your database permissions. None of your perms should be set to SELECT only.