1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Xampp Shell command

Discussion in 'Server Configuration and Hosting' started by ToDie4, May 26, 2011.

  1. ToDie4

    ToDie4 Well-Known Member

    (hopefully it's cool to discuss localhost issues here!)

    I need some help with a problem please, I have asked this before but I am still having problems in Xampp (localhost) with the styles template cache rebuild causing a time-out error (says maximum packet size exceeded) every time I create a new style or delete a new style on my xendev site on local-host (I have 23 styles installed there).

    Every time I work with styles on my dev site I have to run a Xampp shell command:
    Code:
    SET GLOBAL max_allowed_packet=512*1024*1024;
    The command line I am executing is not changing anything permanently on my Xampp environment, I am reasoning my command line is faulty. Does anyone know the correct command line or lines I should be using to avoid this time out problem on a more permanent basis please.
     
  2. ToDie4

    ToDie4 Well-Known Member

    No problem, I figured it out myself finally.
     
  3. Shamil

    Shamil Well-Known Member

    Would you mind sharing what you did to resolve this?
     
  4. ToDie4

    ToDie4 Well-Known Member

    No, of course I wouldn't mind sharing.

    Turns out I was using version 1.7.3 which had some problems, so I upgraded to Xampp 1.7.4 which actually turned out to be version 2.5 (lost me there too), any way, there are several files that need editing to overcome the packet size problem:

    windows/my.ini
    increment max_allowed_packet (suggest min 32M)

    xampp/bin/my.ini

    increment max_allowed_packet (suggest min 32M)

    xampp/php/php.ini-production

    increment post_max_size (suggest min 32M)
    increment upload_max_filesize (suggest min 32M)


    xampp/php/php.ini

    increment post_max_size (suggest min 32M)
    increment memory_limit (suggest min 32M)
    increment upload_max_filesize (suggest min 32M)


    xampp/mysql/my-huge.ini

    increment (2 instances of!) max_allowed_packet (suggest min 32M)


    xampp/mysql/my-innodb-heavy-4G.ini

    increment (2 instances of!) max_allowed_packet (suggest min 32M)


    xampp/mysql/my-large.ini

    increment (2 instances of!) max_allowed_packet (suggest min 32M)


    xampp/mysql/my-medium.ini

    increment (2 instances of!) max_allowed_packet (suggest min 32M)


    xampp/mysql/my-small.ini

    increment (2 instances of!) max_allowed_packet (suggest min 32M)


    xampp/phpmyadmin/libraries/config.default.php

    increment value of $cfg['ExecTimeLimit'] (suggest 36000)

    I hope this is of help to some of you, wasn't easy tracking this lot down I can tell you. :)
     
    Shamil likes this.

Share This Page