:~ # 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. Ive set max_allowed_packet = 32M on /etc/my.cnf Its 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/
