Cannot connect to MySQL 5.7 Windows platform

Mark Anderson_bobu0z

I am installing on Windows Server, My SQL 5.7. Everything fine but database connection fails with "Server Time Zone C.. U.. T.." error message. I have tried setting time zone in JIRA/bin/setenv.bat, and also in Windows Registry (Europe/London).

Rapidly losing patience with Jira installation support - pretty poor that simple installation required editing bat files and running regedit - surely the installer should set the environment? Any suggestions?

Andy Heinzer

Hi Mark,

I am not familiar with the specific error message you are getting here.  Where exactly do you see that message?  Is this in the atlassian-jira.log file when Jira is starting up?  Or have you tried to use the Config Tool in Jira in order to configure/test this connection?

Is MySQL installed to the same server as Jira?  

When Jira is installed, it tends to default itself to using the timezone of the JVM instance it is loading up in, which in turn tends to use the default timezone of the base operating system.  There are ways to tell the Jira application to use a different timezone, via some JVM startup arguments, but I'm not clear on why you should have to do this.

I am not aware of any requirement to have both jira and its database utilize the exact same timezone in order to work correctly.  So I'm interested to learn more about this problem and the specific errors you are encountering and where so that we can try to troubleshoot this better.

It might help to run the following SQL statement against mysql to learn more about your database settings:

SELECT @GLOBAL.time_zone, @SESSION.time_zone;

Also what version of Windows Server is this?