Page 1 of 1

16MB limit with mysql

PostPosted:Sat Sep 24, 2011 6:13 am
by preminik
Hi,
I have successfully installed and configured OpenKM to use mysql as database (datastore), but I found out that this configuration limits the max file size to 16MB.

The files are uploading without any errors and confirmation is also displayed as file upload successful. But when I try to download the file it is only 0 bytes.

mysql is configured to allow upto 132MB files.

Please help..!

Thanks with regards,
Preminik.

Re: 16MB limit with mysql

PostPosted:Mon Sep 26, 2011 9:18 pm
by pavila
So you have increased the maximum upload file size (max.file.size) and can upload them but they are empty when downloaded? OpenKM (and MySQL) give you any error when upload any file bigger than 16MB? Take a look at $JBOSS_HOME/server/default/log/server.log file.

Re: 16MB limit with mysql

PostPosted:Tue Sep 27, 2011 11:40 am
by preminik
Thanks for the reply Pavila,

My mistake, the original Datastore was on MyISAM engine.
I re-created the database and used InnoDB engine for the Datastore, all good now.

Thanks again.
Preminik