Thanks for the help... This makes sense for the Daniel's case - where his error was: Thread-10706: Error communicating with authentication source DBAuth: Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3 So the date glitch is probably in the auth_db table. I checked my auth_db table and didn't see any problematic dates.
My error in more context is: Mar 10, 2020 1:01:52 PM org.eclipse.jetty.server.handler.ContextHandler$Context log INFO: An exception happened during JRuby-Rack startup Java::JavaSql::SQLException: HOUR_OF_DAY: 2 -> 3 Any thoughts on how I figure out where my glitchy dates might be stored? Thanks for any ideas... Mike From: archivesspace_users_group-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of Blake Carver Sent: Monday, March 9, 2020 2:49 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Subject: Re: [Archivesspace_Users_Group] update of previous post archivesspace 'manage user access' pages give error It's probably a problem brought on by the change of time this week. Try this: MySQL [archivesspace]> select * from auth_db; +------+------------------+---------------------+---------------------+--------------------------------------------------------------+ | id | username | create_time | system_mtime | pwhash | +------+------------------+---------------------+---------------------+--------------------------------------------------------------+ | 1 | admin | 2016-03-09 07:10:13 | 2016-03-09 07:10:13 | $2a$10$Gp0oqAuyVXmG/M1s7XDcTuz8.6aTRooPxbf.AWNUuhxNvzsjTa7om | | 2 | search_indexer | 2016-03-09 07:10:14 | 2019-10-05 08:33:40 | $2a$10$WEoh7JjTOFZ.m.ih9sbxPOHomfcReIBlnAoRQceAbwWFK0DuyC8Tm | Take a look atsearch_indexer and the 2 times. The system_time is probably the one with the bad hour. You can just update that the current time and that should do it. So something like update auth_db set system_mtime = NOW()where username = search_indexer. ________________________________ From: archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org> <archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>> on behalf of Daniel Sprouse <dspro...@tsl.texas.gov<mailto:dspro...@tsl.texas.gov>> Sent: Monday, March 9, 2020 2:35 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>> Subject: [Archivesspace_Users_Group] update of previous post archivesspace 'manage user access' pages give error new information added, and new log files attached. I am homing in on the issue here, thinking it is a java version issue, or a java version recognition issue. If anyone has seen anything like this, any guidance would be appreciated. after migrating from 2.7.0 to 2.7.1, and from mysqld Ver 5.7.16 to mysqld Ver 8.0.16, from java 1.7 to 1.8 [root@tslac4avwebtest archivesspace]# java -version openjdk version "1.8.0_232" OpenJDK Runtime Environment (build 1.8.0_232-b09) OpenJDK 64-Bit Server VM (build 25.232-b09, mixed mode) BUT... when it was working, the output on the backend webpage showed java 1.7! (I think that not seeing java 1.8 is probably the issue) backend_url http://aristest.tsl.texas.gov:8089 { "databaseProductName": "MySQL", "databaseProductVersion": "8.0.16", "ruby_version": "2.3.0", "host_os": "linux", "host_cpu": "x86_64", "build": "java1.7", "archivesSpaceVersion": "v2.7.1" } ------------------------------------- Archivesspace started normally several times on Friday, but I got errors when I went to user management pages. archivesspace admin account 'System'->'manage users' and 'Repository Settings'->'manage user access' pages give error http://arisint.tsl.texas.gov:8080/users http://arisint.tsl.texas.gov:8080/users/manage_access "We're sorry, but something went wrong." I have not found any other pages that give this error. attached is a tail -f of archivesspace.out while attempting to get to 'System'->'manage users' and a diagnostic spawned by archivesspace, aspace_diagnostic_1583775751.txt [cid:image001.jpg@01D5F6DA.C9958360]
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group