1 Topic by ichtus (edited by ichtus 05/06/2019 05:03:03 pm)

  • From: Indonesia, Surabaya
  • Registered: 01/08/2012
  • Posts: 36

Topic: error when upload big backup file sql about 7mb

environment
- FA 2.4.6
(check with latest from git also same)
- php 7.2
- centos 7.x

backup database for one of company, that produce for 7mb file sql or .zip or .gz
increase for php value:
max_execution_time = 120
max_input_time = 90
memory_limit = 80M
upload_max_filesize = 80M
post_max_size = 80M

edited:
and upload file, it show error with icon triangle, with no error shown even in debug in config.php

edit php.ini but still no luck, disabled for mod_security but no difference, apache error_log show below:

x.x.x.x TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384 - lewi [07/May/2019:01:04:20 +0900] "GET /fa/admin/backups.php? HTTP/1.1" 200 4756 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36"
x.x.x.x TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384 - lewi [07/May/2019:01:04:20 +0900] "GET /fa/company/15/js_cache/7/JsHttpRequest.js HTTP/1.1" 304 - "https://domain.com/fa/admin/backups.php?" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36"
x.x.x.x TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384 - lewi [07/May/2019:01:04:20 +0900] "GET /fa/company/15/js_cache/7/behaviour.js HTTP/1.1" 304 - "https://domain.com/fa/admin/backups.php?" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36"
x.x.x.x TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384 - lewi [07/May/2019:01:04:20 +0900] "GET /fa/company/15/js_cache/7/utils.js HTTP/1.1" 304 - "https://domain.com/fa/admin/backups.php?" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36"
x.x.x.x TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384 - lewi [07/May/2019:01:04:20 +0900] "GET /fa/company/15/js_cache/7/inserts.js HTTP/1.1" 304 - "https://domain.com/fa/admin/backups.php?" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36"
x.x.x.x TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384 - lewi [07/May/2019:01:04:27 +0900] "POST /fa/admin/backups.php?JsHttpRequest=15571586703380-form HTTP/1.1" 400 226 "https://domain.com/fa/admin/backups.php?" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36"

checking for httpd.conf
#Timeout 90
Timeout 150

but no difference, last time remember that this don't have problem with php 5.6?

ichtus's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: error when upload big backup file sql about 7mb

SitePoint Discussion:

No, there is no download size limit setup. In general, download file size is not restricted. You can HTTP-download the file of any size.

Only Timeout settings need to be looked into.

Maybe as advised in the above discussion, it may be pertinent to place the following header in the download code:

header ('Content-length: '.filesize($fileToSendPath));

apmuthu's Website

  • From: Indonesia, Surabaya
  • Registered: 01/08/2012
  • Posts: 36

Re: error when upload big backup file sql about 7mb

Hi @apmuthu,

have edit php.ini time should have 90s for max_input_time, page is show POST with only 7 second after, this number dont show in anywhere.
07/May/2019:01:04:20 to 07/May/2019:01:04:27 +0900

ichtus's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: error when upload big backup file sql about 7mb

Hope you restarted your webserver after editing php.ini file.

apmuthu's Website

  • From: Indonesia, Surabaya
  • Registered: 01/08/2012
  • Posts: 36

Re: error when upload big backup file sql about 7mb

Hi @apmuthu,
Yes of course,

but for workaround using compression .sql.gz result lower 1mb something from 7mb plain sql.

ichtus's Website