[Archivesspace_Users_Group] Still troubleshooting ArchivesSpace Preservica issue

[Neal, Rick]

Blake,

I have passed this back to Preservica.

I am also trying to make sure my database is right.

I have an aspace user and an archivesspace database.  I can log in to mysql as that user and change to the archivesspace database and I can list the users.

I get a list of users that ArchivesSpace created in the admin console.

I then check to make sure that the as user has ALL PRIVILEGES (see below) and the as user does have ALL PRIVILEGES.

mysql> show grants;
+--------------------------------------------------------------------------------------------------------------------+
| Grants for as at localhost                                                                                            |
+--------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'as'@'localhost' IDENTIFIED BY PASSWORD '*389A648EDB48DB63AKE39CC2C21AE774DAD685F9' |
| GRANT ALL PRIVILEGES ON `archivesspace`.* TO 'as'@'localhost'                                                      |
+--------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)

I am thinking the database and as user is configured correctly at this point and have to ask what else could it be causing the communication issue between Preservica and ArchivesSpace.

I want to troubleshoot  to see if this might be a mysql connector issue  to verify that I have that configured properly.  How could I test it?

Thanks,

Rick




From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Blake Carver
Sent: Friday, October 16, 2020 10:26 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace / Preservica issue

Are you behind Apache/nginx/whatever? That error happens on everything they try to grab?
I think I'd start looking there, though I'm not sure what the problem is.
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of Neal, Rick <rneal at richmond.edu<mailto:rneal at richmond.edu>>
Sent: Friday, October 16, 2020 8:57 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Cc: LaPrade, Crista <claprade at richmond.edu<mailto:claprade at richmond.edu>>
Subject: [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace / Preservica issue


Good morning,



I am still troubleshooting an issue with Preservica not being able to connect to our ArchivesSpace upgrade, which is on a new server.



Preservica tech support saw this in the log:



Caused by: org.springframework.web.client.RestClientException: Could not extract response: no suitable HttpMessageConverter found for response type [interface java.util.Map] and content type [text/html;charset=iso-8859-1]



I checked my config.rb file and have this in it:



AppConfig[:db_url] = "jdbc:mysql://localhost:3306/archivesspace?user=asuser&password=somepassword&useUnicode=true&characterEncoding=UTF-8"



Is there some other place I have to change the Encoding perhaps?



Thanks,



Rick





Rick Neal

Library Systems and Applications Administrator

University of Richmond




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20201016/5bd6c175/attachment.html>