Results 1 to 4 of 4

Thread: Handle large data

  1. #1
    Member sniperscope's Avatar
    Join Date
    Apr 2011
    Location
    osaka/ japan
    Posts
    117
    cPanel/WHM Access Level

    Website Owner

    Default Handle large data

    I have transfer one og customer's web page to freshly installed WHM. When his web site in the old server there was no problem but after moving to new server he cannot update/insert or delete into database which data comes from html form.

    Output of $_SERVER['CONTENT_LENGTH'] is 24525 and guess this is not way too big data.

    Php max_execution_time is 30 and max_input_time is 180

    Did i make something wrong?

    I can provide more information if requested.

  2. #2
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel/WHM Access Level

    Root Administrator

    Default Re: Handle large data

    Are the settings in the php.ini on the old machine the same as on the new machine? You could copy the old php.ini file on the old server and then run a diff on them on the new server:

    Code:
    diff /usr/local/lib/php.ini /pathtooldphp.ini
    Please replace the [b]pathtooldphp.ini[/code] with the location where you placed the old server's php.ini file on the new server.
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  3. #3
    Member sniperscope's Avatar
    Join Date
    Apr 2011
    Location
    osaka/ japan
    Posts
    117
    cPanel/WHM Access Level

    Website Owner

    Default Re: Handle large data

    Dear Tristan
    Thanks for reply, I was working to solve this problem with Daniel until 4am yesterday. Seems Suhosin cause this problem.

    I've checked /var/log/messages/ as daniel said and i found following line in it

    suhosin[28179]: ALERT - configured POST variable limit exceeded - dropped variable '218_4_0_start' (attacker '111.222.333.444', file '/home/user_account/public_html/folder/folder/index.php')
    I am re-compiling php and apache without suhosin.

    The process is still in progress, i am going to write result as soon as it is done.

  4. #4
    Member sniperscope's Avatar
    Join Date
    Apr 2011
    Location
    osaka/ japan
    Posts
    117
    cPanel/WHM Access Level

    Website Owner

    Default Re: Handle large data

    I solved the problem.
    Gain was suhosin.

    I am sending my solution it may help someone else hours and hair as well.

    1 - Removed Suhosin through EasyApache and re-compile php and Apache
    2 - After that i found error_log file in the directory says
    PHP Warning: Unknown: Input variables exceeded 1000. To increase the limit change max_input_vars in php.ini. in Unknown on line 0
    3 - I edit php.ini file and added following line in somewhere of php.ini file. Addedd line is : max_input_vars = 6000
    4 - Saved and restarted Apache

    5 - Whola !!!! Everything works fine.

    Hope this solution help someone else

    Cheers
    Last edited by sniperscope; 07-01-2012 at 09:29 PM.

Similar Threads

  1. Consolidate back-end data storage for cPanel users into a single data store
    By cPanelDavidG in forum Feature Requests for cPanel & WHM
    Replies: 7
    Last Post: 11-25-2011, 02:50 PM
  2. Value too large for defined data type
    By linux.newbie in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 12-14-2007, 11:41 PM
  3. How do YOU handle whitelisting?
    By penutz in forum E-mail Discussions
    Replies: 2
    Last Post: 12-10-2007, 01:27 PM
  4. Value too large for defined data type
    By SiMka in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 06-10-2005, 06:11 AM
  5. Logs - How large is large?
    By tntmom5 in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 02-25-2004, 10:29 PM