1

Topic: Table 'roundcubemail.responses' doesn't exist or command denied

Error 1:
Updating database schema (2013052500)... [FAILED]
ERROR: Error in DDL upgrade 2013052500: [1142] CREATE command denied to user 'roundcube'@'localhost' for table `roundcubemail`.`cache_shared`

Had the error Table 'roundcubemail.responses' while trying to run
/usr/bin/php /opt/www/roundcubemail/bin/cleandb.sh

This started happening after updating.

This cleandb process is cronned.

Here's how to fix it:
1. Enter mysql from command prompt. If you're root, you should be right in. Else, you have to enter superuser and password
2. Fix privileges
MariaDB [(none)]> GRANT CREATE,ALTER on roundcubemail.* to roundcube@localhost;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)

3. Remove the cache_shared table
MariaDB [(none)]> use roundcubemail;
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
MariaDB [roundcubemail]> DROP TABLE `cache_shared`;

4. Fix Roundcube version on the db.
MariaDB [roundcubemail]> UPDATE system SET value = 2020122900 WHERE name = 'roundcube-version';
Query OK, 1 row affected (0.001 sec)
Rows matched: 1  Changed: 1  Warnings: 0

5. Run RoundCube's update.
/opt/www/roundcubemail/bin]#/usr/bin/php /opt/www/roundcubemail/bin/cleandb.sh
0 records deleted from 'contacts'
0 records deleted from 'contactgroups'
0 records deleted from 'identities'
0 records deleted from 'responses'


Problem done!

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Table 'roundcubemail.responses' doesn't exist or command denied

Thanks for sharing.