Here is how to fix INTERNAL SERVER ERROR when using Phpmyadmin to Import a DB w/FCGI

[pucky]

I was trying to import a very small db, 3kb to be exact and getting an internal server error in Phpmyadmin.

In my error_log i was also seeing this;

mod_fcgid: HTTP request length 131952 (so far) exceeds MaxRequestLen (131072)

First, i tried increasing the size of upload_max_filesize = 15M but that alone did not help.

Im using php 5.3 so i set upload_max_filesize = 15m in;

/usr/local/php53/lib/php.ini

then ...

I added the following to httpd-fcgid.conf;

#
# mod_fcgid configuration file
#

<IfModule mod_fcgid.c>
  SharememPath /var/run/fcgid_shm
  FcgidMinProcessesPerClass 0
  FcgidMaxProcessesPerClass 8
  FcgidMaxProcesses 150
  FcgidIdleTimeout 60
  FcgidProcessLifeTime 120
  FcgidIdleScanInterval 30
  FcgidPassHeader Authorization
  AddHandler fcgid-script .fcgi
  [B]MaxRequestLen 15728640[/B]
</IfModule>

15k should be enough if you need more try 20000000

Then restarted apache, /etc/init.d/httpd restart

Now i can import DB's into Phpmyadmin with no further issues.

This may not be the best place to add MaxRequestLen if your using cloudlinux but it seems to work.

Maybe cloudlinux has another option to set that somewhere.

Hope this helps someone.

 

[pucky]

Can someone add MaxRequestLen 15728640 to custombuild? the config is getting overwritten every time there are updates.

 

[smtalk]

Thank you for the report. It was 1GB earlier, but with 2.3.6 version of mod_fcgid they changed it:

Changes with mod_fcgid 2.3.6

*) Change the default for FcgidMaxRequestLen from 1GB to 128K. Administrators should change this to an appropriate value based on site requirements. [Jeff Trawick]

It will be fixed in CustomBuild 2.0 soon.

 

[manhh]

Internal server error

I'm can't Import BD 15K
I'm fixed but I't not Work.
How can I do?