[SPAM?] Re: [SPAM?] Re: [opencms-dev] maximum file size that OpenCms lets to Upload

[Claus Priisholm]

The contents tables are defined to use a mediumblob (which is mysql 
lingo for 2^24 bytes aka 16 MB). I recall someone that changed this 
setting, and as I recall it with no bad side effects (scan the mailing 
archive).

maria.freixes_graells at alcatel.es wrote:
> Thanks very much Christian, I'll try to investigate more about.....
> I've the same parameters as yours plus the following that you don't have:
> 
> net_buffer_length                 16384
> select_limit                      1000
> max_join_size                     1000000
> secure-auth                       FALSE
> show-warnings                     FALSE
> 
> I don't know if it's a problem of mysql....
> And in the machine I can't find any log of error.
> Someone knows   WHERE I COULD FOUND SOME INFORMATION OF THE ERROR? IN 
> WHICH FILE?
> Thanks again!!
> 
> Christian Steinert wrote:
>> maria.freixes_graells at alcatel.es schrieb:
>>  
>>> Our value, in the mysql is set properly:
>>>
>>>
>>> Variables (--variable-name=value)
>>> and boolean options {FALSE|TRUE}  Value (after reading options)
>>> --------------------------------- -----------------------------
>>> auto-rehash                       TRUE
>>> character-sets-dir                (No default value)
>>> default-character-set             latin1
>>> compress                          FALSE
>>> database                          (No default value)
>>> delimiter                         ;
>>> vertical                          FALSE
>>> force                             FALSE
>>> named-commands                    FALSE
>>> local-infile                      FALSE
>>> no-beep                           FALSE
>>> host                              (No default value)
>>> html                              FALSE
>>> xml                               FALSE
>>> line-numbers                      TRUE
>>> unbuffered                        FALSE
>>> column-names                      TRUE
>>> sigint-ignore                     FALSE
>>> port                              0
>>> prompt                            mysql>
>>> quick                             FALSE
>>> raw                               FALSE
>>> reconnect                         TRUE
>>> socket                            /var/lib/mysql/mysql.sock
>>> ssl                               FALSE
>>> ssl-key                           (No default value)
>>> ssl-cert                          (No default value)
>>> ssl-ca                            (No default value)
>>> ssl-capath                        (No default value)
>>> ssl-cipher                        (No default value)
>>> table                             FALSE
>>> debug-info                        FALSE
>>> user                              (No default value)
>>> safe-updates                      FALSE
>>> i-am-a-dummy                      FALSE
>>> connect_timeout                   0
>>> max_allowed_packet                67107840
>>>
>>>     
>>
>>
>> Dear Maria,
>>
>>
>> Sadly max_allowed_packet is the only of these parameters that I know 
>> about.
>>
>> For a 20MB file your setting should be enough now.
>> Apart from this I really don't know. I have not yet come across this
>> problem - I don't have such big files on opencms.
>>
>> Anybody here who had a similar problem?
>>
>> Sorry...
>> Ch.
>>
>>   
>> ------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please 
>> visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 

-- 
Claus Priisholm, CodeDroids ApS
Phone: +45 48 22 46 46
cpr (you know what) codedroids.com - http://www.codedroids.com
cpr (you know what) interlet.dk - http://www.interlet.dk
--
Javadocs and other OpenCms stuff: 
http://www.codedroids.com/community/opencms