Nginx error 413 – Request Entity Too Large

countfak

Hi,

I'm trying to import a large database through adminer and I get this error.
Setting the upload_max_filesize and post_max_size in the php configuration overrides doesn't help.
How and where can I tweak the nginx configuration to allow the upload of larger files?
Sorry if this was already asked but I couldn't find specific answers in the forum or in the docs.

Thanks!

Indigo

Interesting! Do you have an nginx service in your stack? If so, can you confirm which nginx is throwing the error, your stack's, or the System-provided nginx (ie the reverse proxy)? You will hopefully be able to tell by looking at their respective log files. Let me know if you need help finding them.

Are you overriding the nginx configurations at all?

In beta 15, we modified the nginx reverse proxy configuration to include the following:

client_max_body_size 0;

which tells Nginx to allow an unlimited body size. In rc3 we added the same to the nginx site config (used for each nginx site you define).

So if you've not overridden any nginx config, I'd suggest you try rebuilding your stack(s) and see if you get the new default config cloned in.

countfak

Great, rebuilding the stack did the trick. Thank you.

Now I'm having another error while executing the import: 504 Gateway Time-out, still from nginx. By looking at the logs looks like it's coming from the System-provided nginx (ie the reverse proxy).

Indigo

Hmm, proxy_send_timeout controls the amount of time Nginx will wait for a response from the upstream (ie proxied) server. We don't set that config, so nginx is on its default value which should be 60 seconds.

I'd rather not increase that out-of-the-box, so you'll need to override the nginx reverse proxy configuration to increase it. There are a few threads here that explain how, and an entry in the documentation; if you get stuck let me know!

ps how big is this database?! Also, have you considered using Sequel Ace for database management? It will have no timeouts.

countfak

Thanks for the explanation.
The database is very big indeed, but I managed to import it using Sequel Ace as you suggested. Thank you very much!