web stats
MySQL 3.8.0 Fail - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2019, 07:49 AM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 955
StickyBandit is on a distinguished road
Thumbs down MySQL 3.8.0 Fail

FYI: The new MySQL driver
mysql-connector-java-8.0.16.jar
that gets installed with Mirth Connect Server 3.8.0
is not compatible with Mountain Daylight Time Timezone.
(
Wrapped java.sql.SQLException: The server time zone value 'MDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
)
I had to rollback (put back) mysql-connector-java-5.1.32-bin.jar to get our channels to deploy without the error. Luckily we only had a few archiving channels that used a MySQL database.
[And NO, trying the new driver class did not work.]
Reply With Quote
  #2  
Old 08-20-2019, 08:33 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 1,159
agermano is on a distinguished road
Default

https://en.wikipedia.org/wiki/List_o...ase_time_zones

MDT is deprecated. It says,
Quote:
Choose a zone that observes MST with United States daylight savings time rules, such as America/Denver
Reply With Quote
  #3  
Old 08-23-2019, 10:33 AM
StickyBandit's Avatar
StickyBandit StickyBandit is offline
Mirth Guru
 
Join Date: Aug 2013
Location: Home Alone
Posts: 955
StickyBandit is on a distinguished road
Default

The timezone from the linux OS perspective is set to America/Boise.
It is the driver error that says 'MDT'.
Reply With Quote
  #4  
Old 08-23-2019, 01:32 PM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 1,159
agermano is on a distinguished road
Default

https://stackoverflow.com/questions/...56150#54256150

I think a lot of the points in that answer are relevant, but there are a lot of other answers with different bits of information as well. It looks like it's your mysql server that's configured for MDT, rather than your mirth server OS.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 01:39 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation