View source

[[Category:Configuring OpenCms]]
=Store large files in OpenCms VFS=

==Check MySQL setup==

First of all, you have to tell MySQL to accept larger files by setting the "max_allowed_packet" parameter in section "mysqld" of your my.ini according to your needs. If you use mysqldump to backup the OpenCms database set the same parameter in section "mysqldump". Restart MySQL.

==Modify database==

If you choose a setup with MySQL OpenCms comes up with two tables for online and offline content which have medium blobs to store binary files such as PDF. A medium blob can store up to 16 MB of data, so here is your limit. If you have larger files you have to modify these two tables and change mediumblob to longblob as described in the following paragraph. Please don't forget to [[Backing up OpenCms|backup]] OpenCms before doing so.

*Log into MySQL
*use opencms;
*ALTER TABLE CMS_OFFLINE_CONTENTS MODIFY COLUMN FILE_CONTENT LONGBLOB NOT NULL;
*ALTER TABLE CMS_CONTENTS MODIFY COLUMN FILE_CONTENT LONGBLOB NOT NULL;

==RAM might be next bottleneck==

In order to be able to publish larger files you also might have to configure your application server such as tomcat to use more memory by setting the parameter "-Xmx" to a higher value (384M ie.). Restart tomcat afterwards.