[Archivesspace_Users_Group] Getting a time error trying to run database set-up script....

[Blake Carver]

Hit send too fast... you can also define that in the config file, 'AppConfig[:db_url]' , that might do the trick.


________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Blake Carver <blake.carver at lyrasis.org>
Sent: Wednesday, May 6, 2020 4:08 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Getting a time error trying to run database set-up script....


What version of the connector do you have there? If it's 8 something, try an older one.
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Gadsby, Eric T. <egadsby at towson.edu>
Sent: Wednesday, May 6, 2020 3:58 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Getting a time error trying to run database set-up script....

Dear Friends,

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:

"Loading ArchivesSpace configuration file from path: /etc/aspace/current/archivesspace/config/config.rb
Loading ArchivesSpace configuration file from path: /etc/aspace/current/archivesspace/config/config.rb
Loading ArchivesSpace configuration file from path: /etc/aspace/current/archivesspace/config/config.rb
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.
Running migrations against jdbc:mysql://localhost:3306/archivesspace?user=[REDACTED]&password=[REDACTED]&useUnicode=true&characterEncoding=UTF-8

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !!                                                                                                !!
    !!                                      Database migration error.                                 !!
    !!                                  Your upgrade has encountered a problem.                       !!
    !!                  You must resolve these issues before the database migration can complete.     !!
    !!                                                                                                !!
    !!                                                                                                !!
    !!                                                Error:                                          !!
    !!  #<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.>                                                                                  !!
    !!  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."

The timezone on the server is set correctly. I am not sure what's going on.  Any help would be appreciated. Thanks in advance!

Eric T Gadsby · IT Operations Specialist

University Libraries<http://libraries.towson.edu/>
Towson University<http://www.towson.edu/> · 8000 York Road · Towson, Maryland,  21252-0001
p. 410-704-3340
[image001.gif]<http://www.towson.edu/>



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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200506/e4872163/attachment.html>