Description of problem: The /var/log/zarafa/server.log file contains many lines like this: Do 11 Feb 2010 23:09:45 CET: Starting zarafa-server version 6,30,10,18495 (18495), pid 16538 Do 11 Feb 2010 23:09:45 CET: 00FA9E50: SQL Failed: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value, Query: "SET SESSION max_allowed_packet = 16777216" Do 11 Feb 2010 23:09:45 CET: Connection to database 'zarafa' succeeded Do 11 Feb 2010 23:09:45 CET: WARNING: zarafa-licensed not running, commercial features will not be available until it's started. Do 11 Feb 2010 23:09:45 CET: 00FCF700: SQL Failed: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value, Query: "SET SESSION max_allowed_packet = 16777216" Do 11 Feb 2010 23:09:45 CET: 00FD37A0: SQL Failed: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value, Query: "SET SESSION max_allowed_packet = 16777216" Do 11 Feb 2010 23:09:45 CET: Listening for pipe connections on /var/run/zarafa Do 11 Feb 2010 23:09:45 CET: Listening for TCP connections on port 236 Do 11 Feb 2010 23:09:45 CET: Startup succeeded on pid 16542 Do 11 Feb 2010 23:09:45 CET: 54000F30: SQL Failed: SESSION variable 'max_allowed_packet' is read-only. Use SET GLOBAL to assign the value, Query: "SET SESSION max_allowed_packet = 16777216" Version-Release number of selected component (if applicable): libmapi-6.30.10-1.fc11.x86_64 zarafa-monitor-6.30.10-1.fc11.x86_64 zarafa-server-6.30.10-1.fc11.x86_64 zarafa-ical-6.30.10-1.fc11.x86_64 php-mapi-6.30.10-1.fc11.x86_64 zarafa-6.30.10-1.fc11.x86_64 zarafa-dagent-6.30.10-1.fc11.x86_64 zarafa-debuginfo-6.30.10-1.fc11.x86_64 zarafa-spooler-6.30.10-1.fc11.x86_64 zarafa-gateway-6.30.10-1.fc11.x86_64 zarafa-utils-6.30.10-1.fc11.x86_64 zarafa-common-6.30.10-1.fc11.x86_64 zarafa-client-6.30.10-1.fc11.x86_64 zarafa-webaccess-6.30.10-1.fc11.noarch mysql-server-5.1.42-7.fc11.x86_64 mysql-libs-5.1.42-7.fc11.x86_64 mysql-5.1.42-7.fc11.x86_64 mysql-debuginfo-5.1.42-7.fc11.x86_64 How reproducible: Everytime, see above and below. Steps to Reproduce: 1. yum install zarafa zarafa-webaccess --enablerepo=testing 2. Configure MySQL 3. service zarafa-server start Actual results: SQL Failed: SESSION variable 'max_allowed_packet' is read-only. Expected results: No failed SQL.
The installation manual (which I don't think we ship as part of the packages) describes the max_allowed_packet MySQL server configuration variable needs to change to 32M, I believe. I think this is more of a documentation issue then it is a Zarafa issue, what say you?
I'm wondering why they use SET SESSION max_allowed_packet = 16777216; rather SET GLOBAL max_allowed_packet = 16777216; as the error message suggests. Or did I misunderstand the error message.
This is upstream ticket #5033.
This message is a reminder that Fedora 11 is nearing its end of life. Approximately 30 (thirty) days from now Fedora will stop maintaining and issuing updates for Fedora 11. It is Fedora's policy to close all bug reports from releases that are no longer maintained. At that time this bug will be closed as WONTFIX if it remains open with a Fedora 'version' of '11'. Package Maintainer: If you wish for this bug to remain open because you plan to fix it in a currently maintained version, simply change the 'version' to a later Fedora version prior to Fedora 11's end of life. Bug Reporter: Thank you for reporting this issue and we are sorry that we may not be able to fix it before Fedora 11 is end of life. If you would still like to see this bug fixed and are able to reproduce it against a later version of Fedora please change the 'version' of this bug to the applicable version. If you are unable to change the version, please add a comment here and someone will do it for you. Although we aim to fix as many bugs as possible during every release's lifetime, sometimes those efforts are overtaken by events. Often a more recent Fedora release includes newer upstream software that fixes bugs or makes them obsolete. The process we are following is described here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping
Still affects Rawhide.
Seems to be fixed in Zarafa 6.40.0.
zarafa-6.40.0-2.fc13 has been submitted as an update for Fedora 13. http://admin.fedoraproject.org/updates/zarafa-6.40.0-2.fc13
zarafa-6.40.0-2.fc12 has been submitted as an update for Fedora 12. http://admin.fedoraproject.org/updates/zarafa-6.40.0-2.fc12
zarafa-6.40.0-2.el5 has been submitted as an update for Fedora EPEL 5. http://admin.fedoraproject.org/updates/zarafa-6.40.0-2.el5
zarafa-6.40.0-2.el5 has been pushed to the Fedora EPEL 5 stable repository. If problems still persist, please make note of it in this bug report.
zarafa-6.40.0-2.fc12 has been pushed to the Fedora 12 stable repository. If problems still persist, please make note of it in this bug report.
zarafa-6.40.0-2.fc13 has been pushed to the Fedora 13 stable repository. If problems still persist, please make note of it in this bug report.