SOSTX

In Moodle 2.0 testing ran across an error about "max_allowed_packets" in mysqld.



Found web page that describes how to set and check settings:
http://www.liferay.com/web/guest/community/forums/-/message_boards/message/124969

On a CentOS Linux box as root user:
cd /etc/ [enter]
cp my.cnf my.cnf.back
Then edit:
1. nano /etc/my.cnf
2. under [mysqld] and before [mysqld_safe] insert a comment line and the setting:
# for Moodle 2.0 - added manually 06-07-2010 your initials
max_allowed_packet=10MB

Restart mysqld:
/sbin/service mysqld restart

To check, login to mysql using root user:
mysql -u root -p

At the mysql> prompt, type:
show variables like 'max_allowed_packet';

You should see something like this:

+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 10485760 |
+--------------------+----------+
1 row in set (0.02 sec)

Exit mysql: \q

Try the same area of Moodle 2.0 that reported error.