or if it fails *SET GLOBAL max_allowed_packet=16*1024*1024;* ** On Tue, Oct 27, 2009 at 2:17 PM, Marco Vannini <[email protected]>wrote:
> 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/
