[Building Sakai] Tomcat causes MySQL service to fail and workaround

[Ryan VanDyke]

Not sure if this has been talked about before but it seems there is a problem with MySQL on both windows (v5.6) and Linux (v14.14 distribution 5.5.39) when starting Tomcat 7.0.55 after modifying the my.ini file outlined in the dev guide here:

https://confluence.sakaiproject.org/display/BOOT/Development+Environment+Setup+Walkthrough

Specifically when told (optionally) to enable logging by adding these lines:

log_output=FILE
log=/tmp/mysql-query.log
slow-query-log=1
long_query_time=1
slow_query_log_file=/tmp/mysql-slow-query.log
expire_logs_days=5

If these log files don't already exist, and they don't on a fresh install, MySQL does not create them and they need to be created manually. After running tomcat the first time (and allowing it to make "some" of the tables then crash which is a known issue - out of order table creation) the service appears to work fine, then running Tomcat the second time to create additional tables causes the MySQL service to crash and not be able to start up again. It seems to be because it has nowhere to write the crash report to. Either removing the lines from my.ini or manually creating the files seems to fix this. Thought I would share in case anyone else has been running into this issue.

- Ryan Van Dyke

 --------------------------------------------------------------------------------------------------------------------

***NOTICE*** This e-mail and/or the attached documents may contain technical data within the definition of the International Traffic in Arms Regulations and/or Export Administration Regulations, and are subject to the export control laws of the U.S. Government. Transfer of this data by any means to a foreign person, whether in the United States or abroad, without an export license or other approval from the U.S. Department of State or Commerce, as applicable, is prohibited. No portion of this e-mail or its attachment(s) may be reproduced without written consent of Kratos Defense & Security Solutions, Inc. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient or believe that you may have received this document in error, please notify the sender and delete this e-mail and any attachments immediately.