<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
What version of the connector do you have there? If it's 8 something, try an older one. </div>
<div>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Gadsby, Eric
T. <egadsby@towson.edu><br>
<b>Sent:</b> Wednesday, May 6, 2020 3:58 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Getting a time error trying to run database set-up script....</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Dear Friends,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
I hope everybody is well and safe! I am trying to set up testing server on a CentOS 7 box and when I run the database migration script I get the following error:</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
"<span>Loading ArchivesSpace configuration file from path: /etc/aspace/current/archivesspace/config/config.rb<br>
</span>
<div>Loading ArchivesSpace configuration file from path: /etc/aspace/current/archivesspace/config/config.rb<br>
</div>
<div>Loading ArchivesSpace configuration file from path: /etc/aspace/current/archivesspace/config/config.rb<br>
</div>
<div>Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.<br>
</div>
<div>Running migrations against jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8<br>
</div>
<div><br>
</div>
<div> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br>
</div>
<div> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br>
</div>
<div> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!<br>
</div>
<div> !! !!<br>
</div>
<div> !! Database migration error. !!<br>
</div>
<div> !! Your upgrade has encountered a problem. !!<br>
</div>
<div> !! You must resolve these issues before the database migration can complete. !!<br>
</div>
<div> !! !!<br>
</div>
<div> !! !!<br>
</div>
<div> !! Error: !!<br>
</div>
<div> !! #<Sequel::DatabaseConnectionError: Java::JavaSql::SQLException: The server time zone value 'EDT' 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.> !!<br>
</div>
<span> !! Java::JavaSql::SQLException: The server time zone value 'EDT' 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."</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span>The timezone on the server is set correctly. I am not sure what's going on. Any help would be appreciated. Thanks in advance!
<br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span></span><br>
</div>
<div id="x_Signature">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<table class="x_MsoNormalTable" width="933" cellspacing="0" cellpadding="0" border="0" style="font-family:Consolas; width:699.75pt; border-collapse:collapse">
<tbody class="">
<tr class="">
<td colspan="2" class="" width="808" style="width:606pt; padding:0in 5.4pt">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:Calibri,sans-serif">
<b class=""><span class="" style="font-family:"Times New Roman",serif">Eric T Gadsby</span></b><span class="" style="font-family:"Times New Roman",serif"> · IT Operations Specialist</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:Calibri,sans-serif">
<span class="" style="font-family:"Times New Roman",serif"> </span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:Calibri,sans-serif">
<span class="" style="font-family:"Times New Roman",serif"><a href="http://libraries.towson.edu/" class="" style="color:rgb(149,79,114)">University Libraries</a></span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:Calibri,sans-serif">
<span class="" style="font-family:"Times New Roman",serif"><a href="http://www.towson.edu/" class="" style="color:rgb(149,79,114)">Towson University</a> · 8000 York Road · Towson, Maryland, 21252-0001</span></div>
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:Calibri,sans-serif">
<span class="" style="font-family:"Times New Roman",serif">p. 410-704-3340 </span></div>
</td>
<td class="" width="125" style="width:94pt; padding:0in 5.4pt">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:Calibri,sans-serif">
<a href="http://www.towson.edu/" class="" style="color:rgb(149,79,114)"><span class="" style="font-family:"Times New Roman",serif; color:windowtext; text-decoration:none"><img id="x_<image001.gif@01D34673.D646BDA0>" alt="image001.gif" class="x_Apple-web-attachment x_Singleton" border="0" data-outlook-trace="F:0|T:2" src="cid:image001.gif@01D34673.D646BDA0"></span></a><span class="" style="font-family:"Times New Roman",serif"></span></div>
</td>
</tr>
<tr class="">
<td colspan="3" class="" width="933" style="width:700pt; padding:0in 5.4pt">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:Calibri,sans-serif">
<span class="" style="font-family:"Times New Roman",serif"> </span></div>
</td>
</tr>
<tr class="">
<td colspan="3" class="" width="933" style="width:700pt; padding:0in 5.4pt">
<div class="" style="margin:0in 0in 0.0001pt; font-size:12pt; font-family:Calibri,sans-serif">
<span class="" style="font-family:"MS Mincho",serif">
</span><span class="" style="font-family:"Times New Roman",serif">Confidentiality Notice: This message may contain information that is confidential, privileged, proprietary, or otherwise legally exempt
from disclosure. If you are not the intended recipient, you are notified that you are not authorized to read, print, copy or disseminate this message, any part of it, or any attachments. If this message has been sent to you in error, please notify the sender
by replying to this transmission, or by calling University Libraries at 410-704-3340.</span></div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</body>
</html>