Try setting it runtime with *SET GLOBAL max_allowed_packet=16M;*
* * * * 2009/10/27 Adrián Fernández Leiro <[email protected]> > :~ # ps auxwww | grep mysql > > root 27391 0.0 0.0 3024 724 pts/0 S+ 13:05 0:00 grep mysql > > root 28025 0.0 0.1 8040 1488 ? S Oct08 0:00 /bin/sh > /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid > --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql > > mysql 28069 0.0 2.3 137452 25148 ? Sl Oct08 9:13 > /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql > --pid-file=/var/lib/mysql/mysqld.pid --skip-external-locking --port=3306 > --socket=/var/lib/mysql/mysql.sock > > > > *De:* [email protected] [mailto:[email protected]] *En nombre de > *Marco > Vannini > *Enviado el:* martes, 27 de octubre de 2009 12:14 > > *Para:* User questions and discussions about OTRS. > *Asunto:* Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes, > SQL: 'INSERT INTO web_uploa > > > > It is possibile that is passed as command line argument a different value ? > ps auxwww | grep mysql ? > > 2009/10/27 Adrián Fernández Leiro <[email protected]> > > Yes, “rcmysql restart”. > > > > It says Check "max_allowed_packet" setting. "max_allowed_packet" should be > higher then 7 MB (it's 0 MB). > > > > # The MySQL server > > [mysqld] > > port = 3306 > > socket = /var/lib/mysql/mysql.sock > > skip-locking > > key_buffer = 16M > > max_allowed_packet = 16M > > table_cache = 64 > > sort_buffer_size = 512K > > net_buffer_length = 8K > > read_buffer_size = 256K > > read_rnd_buffer_size = 512K > > myisam_sort_buffer_size = 8M > > long_query_time=1 > > log-slow-queries=/var/log/mysql/mysql-slow.log > > > > *De:* [email protected] [mailto:[email protected]] *En nombre de > *David > Holder > *Enviado el:* martes, 27 de octubre de 2009 11:07 > *Para:* User questions and discussions about OTRS. > *Asunto:* Re: [otrs] Got a packet bigger than 'max_allowed_packet' bytes, > SQL: 'INSERT INTO web_uploa > > > > Hi, > > Did you restart your mysql service after that modification? > > What does OTRS state when you go into the support assessment page? > > Regards, > > David > > 2009/10/27 Adrián Fernández Leiro <[email protected]> > > Hi everybody: > > > > I have OTRS 2.4.5 on a SuSE. > > The error message pops out when trying to install the FAQ module. > > I’ve set max_allowed_packet = 32M on /etc/my.cnf > > It’s still pulling the same error. > > Any ideas? > > > > *Adrián Fernández Leiro* > > *Departamento de Sistemas* > > *INVERAVANTE* > > *Avda. Linares Rivas 1, Bajo* > > *15005 LA CORUÑA-ESPAÑA* > > *Tel. 981 25 74 81 / 981 12 62 29* > > *Fax. 981 25 18 86* > > > > > > __________ Información de ESET NOD32 Antivirus, versión de la base de > firmas de virus 4546 (20091027) __________ > > ESET NOD32 Antivirus ha comprobado este mensaje. > > http://www.eset.com > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ > > > > > > __________ Información de ESET NOD32 Antivirus, versión de la base de > firmas de virus 4546 (20091027) __________ > > > > ESET NOD32 Antivirus ha comprobado este mensaje. > > > > http://www.eset.com > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ > > > > > > __________ Información de ESET NOD32 Antivirus, versión de la base de > firmas de virus 4547 (20091027) __________ > > > > ESET NOD32 Antivirus ha comprobado este mensaje. > > > > http://www.eset.com > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
