mysql allowed packets in ispconfig3

Discussion in 'Installation/Configuration' started by ariban99, May 16, 2016.

  1. ariban99

    ariban99 Member

    Hi,
    I am running drupal and I am getting an error that says PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: etc...

    i was told to increase the maximum allowed packets. however how do i do this in ispconfig? if i try to edit /etc/my.cnf and restart the mysql service it says
    160515 20:59:31 mysqld_safe unknown option '--max-allowed-packet=500'

    how do i change thsi in ispconfig?

    thank you
    Ben
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    Did you add something like max_allowed_packet=500M to you my.cnf?
     
  3. ariban99

    ariban99 Member

    yes, i think i fixed this now. i ad to add it to the top part of the my.cnf file right below the [mysqld]. by mistake i added it to the end of the file which was nothing working for the mysql part of the file, somehow adding it at the top, fixed this problem and now i have no issues of PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: etc...
     

Share This Page