juanje / cookbook-redmine

Chef's Cookbook for installing Redmine
25 stars 21 forks source link

mysql wait_timeout too short ootb #24

Open epcim opened 9 years ago

epcim commented 9 years ago

I found my users to be time-outed frequrently. I found that ootb on ubuntu12.04 and mysql cookbook the my.cnf contains wait_timeout = <%= node['mysql']['tunable']['wait_timeout'] %> is se to 180 which seems to be not really familiar and cause HTTP 500 during the time of 180s of inactivity while creating an issue in redmine etc. (quite common).

I advise to set longer timeout by default for redmine cookbook to avoid the not a nice behavior.

Found the same issue at: http://www.redmine.org/boards/2/topics/31695

Found solution: http://community.bitnami.com/t/lost-connection-to-mysql-server-during-query/5110/11