We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
500 Error - Upload via PHPMyAdmin
500 Error - Upload via PHPMyAdmin
Hello,
I try upload via PHPMyAdmin 12MB .gz (80MB .sql) file and after load I get 500 error. I use Ubuntu.
/etc/php5/apache2/php.ini
memory_limit = 256M
post_max_size = 150M
upload_max_filesize = 150M
etc/mysql/my.cnf
max_connections=200
max_user_connections=30
wait_timeout=50
interactive_timeout=70
long_query_time=5
innodb_file_per_table
max_allowed_packet = 16M
Error log:
[Sat Nov 28 13:37:53.814883 2015] [:error] [pid 1609] [client XX.XX.XXX.XXX:40455] phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions., referer: https://www.domain.com/phpmyadmin/
2015/11/28 13:39:23 [error] 1496#0: *2 upstream timed out (110: Connection timed out) while reading response header from upstream, client: XX.XX.XXX.XXX, server: domain.com, request: "POST /phpmyadmin/import.php HTTP/1.1", upstream: "https://XX.XX.XXX.XXX:8443/phpmyadmin/import.php", host: "www.domain.com", referrer: "https://www.domain.com/phpmyadmin/"
I try upload via PHPMyAdmin 12MB .gz (80MB .sql) file and after load I get 500 error. I use Ubuntu.
/etc/php5/apache2/php.ini
memory_limit = 256M
post_max_size = 150M
upload_max_filesize = 150M
etc/mysql/my.cnf
max_connections=200
max_user_connections=30
wait_timeout=50
interactive_timeout=70
long_query_time=5
innodb_file_per_table
max_allowed_packet = 16M
Error log:
[Sat Nov 28 13:37:53.814883 2015] [:error] [pid 1609] [client XX.XX.XXX.XXX:40455] phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions., referer: https://www.domain.com/phpmyadmin/
2015/11/28 13:39:23 [error] 1496#0: *2 upstream timed out (110: Connection timed out) while reading response header from upstream, client: XX.XX.XXX.XXX, server: domain.com, request: "POST /phpmyadmin/import.php HTTP/1.1", upstream: "https://XX.XX.XXX.XXX:8443/phpmyadmin/import.php", host: "www.domain.com", referrer: "https://www.domain.com/phpmyadmin/"
Re: 500 Error - Upload via PHPMyAdmin
Check group www-data has read access and open_basedir restrictions.
Code: Select all
chmod 755 /var/lib/phpmyadmin
chmod 664 /var/lib/blowfish_secret.inc.php
chmod 664 /var/lib/config.inc.php
Code: Select all
php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext:/var/lib/phpmyadmin/tmp:/tmp
Re: 500 Error - Upload via PHPMyAdmin
Error 500 does not show more, change:
/etc/nginx/nginx.conf
proxy_read_timeout 150;
proxy_buffer_size 128k;
proxy_buffers 4 256k;
proxy_busy_buffers_size 256k;
But this error in the log:
[Sun Nov 29 18:43:34.107063 2015] [:error] [pid 3347] [client xxx.xx.xxx.xxx:42095] phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions., referer: https://www.domain.com/phpmyadmin/import.php
Do not have this file: /etc/phpmyadmin/config-db.php
Have this: /etc/phpmyadmin/config-db.php_
In to file:
## database access settings in php format
## automatically generated from /etc/dbconfig-common/phpmyadmin.conf
## by /usr/sbin/dbconfig-generate-include
## Mon, 25 May 2015 20:05:43 -0400
##
## by default this file is managed via ucf, so you shouldn't have to
## worry about manual changes being silently discarded. *however*,
## you'll probably also want to edit the configuration file mentioned
## above too.
##
$dbuser='phpmyadmin';
$dbpass='XXXXXXX';
$basepath='';
$dbname='phpmyadmin';
$dbserver='';
$dbport='';
$dbtype='mysql';
/etc/nginx/nginx.conf
proxy_read_timeout 150;
proxy_buffer_size 128k;
proxy_buffers 4 256k;
proxy_busy_buffers_size 256k;
But this error in the log:
[Sun Nov 29 18:43:34.107063 2015] [:error] [pid 3347] [client xxx.xx.xxx.xxx:42095] phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php Check group www-data has read access and open_basedir restrictions., referer: https://www.domain.com/phpmyadmin/import.php
Do not have this file: /etc/phpmyadmin/config-db.php
Have this: /etc/phpmyadmin/config-db.php_
In to file:
## database access settings in php format
## automatically generated from /etc/dbconfig-common/phpmyadmin.conf
## by /usr/sbin/dbconfig-generate-include
## Mon, 25 May 2015 20:05:43 -0400
##
## by default this file is managed via ucf, so you shouldn't have to
## worry about manual changes being silently discarded. *however*,
## you'll probably also want to edit the configuration file mentioned
## above too.
##
$dbuser='phpmyadmin';
$dbpass='XXXXXXX';
$basepath='';
$dbname='phpmyadmin';
$dbserver='';
$dbport='';
$dbtype='mysql';