1 Topic by annonman (edited by annonman 2014-05-15 20:59:10)

  • annonman
  • Guest

Topic: Error upgrading to Roundcube 0.9.5 -> 1.0.1

==== Required information ====
- iRedMail version: 0.8.6 -> 0.8.7
- Store mail accounts in which backend (LDAP):
- Linux/BSD distribution name and version: Centos 6.5
- Related log if you're reporting an issue:
====

From RoundCUbe 0.9.5 -> 1.0.1:
at the end of the update:

WARNING: Mimetype to file extension mapping doesn't work properly!
Please check the 'mime_types' config option and run this script again.
Executing database schema update.
Updating database schema (2013042700)... [OK]
ERROR: Error in DDL upgrade 2013052500: [1142] CREATE command denied to user 'roundcube'@'localhost' for table 'cache_shared'Updating database schema (2013052500)... [FAILED]
All done.


Roundcube DOES seem to work, but there is obviously a problem here.

Looks like roundcube@localhost does not have permissions to CREATE tables.

...not sure about Mimetype.

Thoughts?

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Error upgrading to Roundcube 0.9.5 -> 1.0.1

You can execute update script as MySQL root user directly, or grant permission to 'roundcube' user with MySQL root user. For example:

# mysql -u root -p
mysql> GRANT CREATE on roundcubemail.* to roundcube@localhost;
mysql> FLUSH PRIVILEGES;

3 Reply by annonman

  • annonman
  • Guest

Re: Error upgrading to Roundcube 0.9.5 -> 1.0.1

Thanks Zhang, granted roundcube user permissions.

Any idea on the MIME issue?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: Error upgrading to Roundcube 0.9.5 -> 1.0.1

You can see default setting of mime type in Roundcube 1.0.1:

// Absolute path to a local mime.types mapping table file.                         
// This is used to derive mime-types from the filename extension or vice versa.
// Such a file is usually part of the apache webserver. If you don't find a file named mime.types on your system,
// download it from http://svn.apache.org/repos/asf/httpd/h … mime.types
$config['mime_types'] = null;

Please set a correct path to local mime.types mapping table file. On CentOS 6 (and other Linux distributions), it should be /etc/mime.types.