View Single Post
  #1  
Old 26th October 2012, 21:18
M1ENT M1ENT is offline
Junior Member
 
Join Date: Oct 2012
Posts: 12
Thanks: 3
Thanked 0 Times in 0 Posts
Default 413 Request Entity Too Large -PHPMyAdmin - HELP PLEASE

NOT SURE IF THIS HAS BEEN COVERED OR IF POST IS IN THE CORRECT LOCATION FOR POSTING.

I APPOLOGIZE, IF I POSTED IN THE WRONG LOCATION..

OK MOVING ON.

Installed The Perfect Server Cent OS 6.3 x86_x64 NGINX DOVECOT Setup..

ISPCONFIG3 Works Fine..

Problem Is PHPMYADMIN AND IMPORTING...

When I Try To Import a Databases In PHPmyAdmin,
Any .sql Database Over 1mb NGINX Will Receive An Error

ERROR:
413 Request Entity Too Large



Smaller Databases Were Able To Import Fine.

What Ive Tried Changing With No Luck:

READ ONLINE, Found Other's Had The Similar Problems With Nginx And Same Error. Was Instructed To Change

Client Max Body Size 1m

Ive Changed it to,

client_max_body_size 80m

tried also changing to any higher value than 1m, or to even match size of the database file im going to import...

No Luck There.

Changed The PHP.ini Max Upload And Max Post,
To Higher Values 80mb also the time out limits..

Edits to php.ini Work Since PHPMYADMIN NOW SHOWS 80mb Max To Upload.



But Still No Luck With Importing a 17mb .sql On PHPMYADMIN.

Servers NGINX CONFIG:
Code:
# More information about the configuration options is available on
#   * the English wiki - http://wiki.nginx.org/Main
#   * the Russian documentation - http://sysoev.ru/nginx/
#
#######################################################################

#----------------------------------------------------------------------
# Main Module - directives that cover basic functionality
#
#   http://wiki.nginx.org/NginxHttpMainModule
#
#----------------------------------------------------------------------

user              nginx;
worker_processes  1;

error_log  /var/log/nginx/error.log;
#error_log  /var/log/nginx/error.log  notice;
#error_log  /var/log/nginx/error.log  info;

pid        /var/run/nginx.pid;


#----------------------------------------------------------------------
# Events Module
#
#   http://wiki.nginx.org/NginxHttpEventsModule
#
#----------------------------------------------------------------------

events {
    worker_connections  1024;
}


#----------------------------------------------------------------------
# HTTP Core Module
#
#   http://wiki.nginx.org/NginxHttpCoreModule
#
#----------------------------------------------------------------------
http {
map $scheme $fastcgi_https {
          default on;
          https on;
}
    include       /etc/nginx/mime.types;
    default_type  application/octet-stream;
    log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';

    access_log  /var/log/nginx/access.log  main;

    
    client_max_body_size 80m;
    sendfile        on;
    tcp_nopush      on;
    tcp_nodelay     on;
    server_tokens   off;
    gzip            on;
    gzip_static     on;
    gzip_comp_level 5;
    gzip_min_length 10024;
    keepalive_timeout  3000;
    limit_zone   myzone  $binary_remote_addr  50m;

    # Load config files from the /etc/nginx/conf.d directory
    # The default server is in conf.d/default.conf
    include /etc/nginx/conf.d/*.conf;

}
No Errors When Reloading NGINX.

But I Do Receive The Same Error For Any Large Database .sql I try Importing...

413 Request Entity Too Large


Ive Been Breaking My Sculll Trying To Import A Database That's Only 2mb and cant import clients larger databases,
which is about 17mb and largest i need uploaded is 30mb..

Any Help On Where Else I Can Edit, Up The Limit,

Or Help Resolving This Issue Would Be Greatly Appreciated.

Thanks In Advance.

Last edited by M1ENT; 26th October 2012 at 23:05.
Reply With Quote
Sponsored Links