Topic: Error in DDL upgrade
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5.1 / 0.9.6
- Linux/BSD distribution name and version: Ubuntu 16.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hi,
I'm in the process of upgrading from 0.9.5.1 to 0.9.6.
Perhaps I shouldn't be upgrading Roundcube from 1.2 to 1.3.1, but this is what I did.
Upgrade went fine except for this error:
Do you want me to fix your local configuration? (y/N)
y
. backing up the current config file(s)...
. writing /opt/www/roundcubemail-1.2.0/config/config.inc.php...
Done.
Your configuration files are now up-to-date!
Executing database schema update.
Updating database schema (2016081200)... [OK]
Updating database schema (2016100900)... [OK]
Updating database schema (2016112200)... [FAILED]
Error 500: Error in DDL upgrade 2016112200: [1142] DROP command denied to user 'roundcube'@'localhost' for table 'cache_shared'
All done. I also checked the following:
root@mail:~/roundcubemail-1.3.1# dpkg-query -l php-xml
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-==============-============-============-=================================
ii php-xml 1:7.0+35ubun all DOM, SimpleXML, WDDX, XML, and XS Please advise what I should do.
---
Edit: I downloaded from roundcube. Is it the same file as in http://www.iredmail.org/yum/misc/?
Edit2: Roundcube seems to be working fine.
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.