IP.Board 500 Error on CSV Import

I'm trying to upload a file via the members import. I keep getting a 500 error during the process.

I removed a bunch of entries from the CSV (total of about 5 remaining) and did an import and it worked fine. The org file had about 20K entires.

Trying to figure out what I have to adjust in the php.conf because it appears to be a fastcgi error.

---

Code:

2016/06/16 18:06:53 [error] 2847#2847: *2 open() "/home/nginx/domains/10.0.0.121/public/500.html" failed (2: No such file or directory), client: 10.0.0.245, server: 10.0.0.121, request: "POST /admin/?adsess=kn34qisbbq7b498btge08rcpg7&app=core&module=members&controller=members&do=import HTTP/2.0", upstream: "fastcgi://127.0.0.1:9000", host: "10.0.0.121", referrer: "https://10.0.0.121/admin/?adsess=kn34qisbbq7b498btge08rcpg7&app=core&module=members&controller=members&do=import"

Sends me to a page which states "10.0.0.121 unexpectedly closed the connection."

Thinking I have to adjust something in the php.conf here:

Code:

fastcgi_connect_timeout 60;
fastcgi_send_timeout 180;
fastcgi_read_timeout 180;
fastcgi_buffer_size 512k;
fastcgi_buffers 512 16k;
fastcgi_busy_buffers_size 1m;
fastcgi_temp_file_write_size 4m;
fastcgi_max_temp_file_size 4m;
fastcgi_intercept_errors on;

Not exactly sure what I have to adjust. Error happens after 30ish seconds (timed it) and the file is 1.8MB in size.

Also, do I have to rebuilt PHP after I make these adjustments?

Thanks!

 

I'm not having an error with phpmyadmin - I'm uploading it in the admin control panel of the script. I tried adjusting the settings in the php.ini with no luck - I maxed out just about every setting. From researching the issue of uploading CSV file on stackexchange there were a lot of posts about fastcgi. I haven't tried to adjust those yet. Figured I'd throw up a thread here and see if anyone had any suggestions.

I know it does work with the smaller file - about 5 rows. It's the larger file with 20K rows that give the 500.

 

I'll try that in a few. Have to finish up a few things before I can re-compile nginx.

 

LOL! I'm trying to re-install Nginx and can't figure out what is giving me an error. Until I realize this:

Code:

Compiling nginx...
Initializing download: http://nginx.org/download/nginx-5.6.22.tar.gz
HTTP/1.1 404 Not Found

Too much coffee...

 

Yea, it does - can't send it out.

Interesting... I just noticed - from the debug log that I was missing the code below from the conf file:

Code:

http2_max_field_size 16k;
http2_max_header_size 32k;

Now instead of sending me to the "10.0.0.121 unexpectedly closed the connection." it just loops the page:

Importing members...
Please wait while we transfer you...

 

I will now.

If anyone is curious here is the debug log.

IPS Import · GitHub

 

@eva2000 not to say this has to do with the new ssl_ciphers but I got a few bad gateway errors on both my site and this forum starting about the time you changed those ciphers, unsure if the ciphers are related to the gateway errors, but wanted to let you know. I had one pop up when I tried to create this thread originally and had a few on my dev forum... they never happened before.

 

@Ahmad nothing in the error logs located at /var/log/php-fpm/*

 

It only happened twice I believe and a page refresh took care of the issue.

 

Yea, I have block.conf enabled in this block. Though, I remember trying the import once with that disabled. Maybe I should try again. You think that might be the issue?

Code:

    location / {

        # block common exploits, sql injections etc
        include /usr/local/nginx/conf/block.conf;

        # Enables directory listings when index file not found
        # autoindex  on;

        # Shows file listing times as local time
        autoindex_localtime on;

        try_files    $uri $uri/ /index.php;

    }

 

Tried removing the block.conf and still had the issue.