PhpMyAdmin error log location

xerox

Verified User
Joined
Jul 16, 2019
Messages
145
Where i can check whats going on in log file where phpMyAdmin errors exist?

I was uploading an directadmin backup of an sql file into PhpMyAdmin from import page and got internal server error in middle of upload 61%. Upload took ~10 seconds before interruption. The file was 19mb and i checked every php.ini file variable which all looked ok.

max_execution_time 600 600
max_input_time 600 600
memory_limit 1000M 1000M
post_max_size 1000M 1000M

Importing worked only with other smaller file where i partly exported only some tables from the same database. The sql filesize was 7mb.

It also worked with command-line.
mysql -u myuser -p mydatabase < myfile.sql


Thanks
 
Last edited:
You can check if there is a error log at this path: /var/www/html/phpMyAdmin-5.0.1-all-languages/log/

Also maybe check: /var/log/httpd/error_log

Also remember to check this value in php.ini: upload_max_filesize (you did not mention it in your post)
 
This folder contains only .htaccess file
/var/www/html/phpMyAdmin-5.0.1-all-languages/log/

Also maybe check: /var/log/httpd/error_log
Found my error here:
ModSecurity: Request body (Content-Length) is larger than the configured limit (13107200).

UPDATE: It weird if i save changes in the comodo plugin and restart apache, after that i do CTRL+F5 on the plugin config page, then the old parameters are all back like the new ones never saved. But it said it saved and restarted the server. I have removed the plugin and reinstalled it many times now, still the same issue but i was able to change SecRequestBodyNoFilesLimit value from conf file located at /etc/httpd/conf/extra/httpd-modsecurity.conf

Also remember to check this value in php.ini: upload_max_filesize (you did not mention it in your post)

Yes, forgot to mention, it was set to:
upload_max_filesize = 1024M

Thank You
 
Last edited:
Back
Top