[Archivesspace_Users_Group] Still troubleshooting ArchivesSpace Preservica issue

[Blake Carver]

> 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 don't think it's DB related. I think the ArchivesSpace user for Preservica to connect needs admin powers, but I assume that's not the problem.

Preservice uses the API and the API uses your proxy, and that error looks like a proxy error, though I could be wrong on that.

I did a quick Google search on that error and it looks pretty common.


> 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?


I doubt that's the problem, that connects ArchivesSpace to MySQL so if that had troubles ArchivesSpace would be complaining.

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Neal, Rick <rneal at richmond.edu>
Sent: Friday, October 16, 2020 11:33 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace Preservica issue


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/1acb5195/attachment.html>