[Archivesspace_Users_Group] Still troubleshooting ArchivesSpace Preservica issue

Tue Oct 20 10:43:39 EDT 2020

localhost:3306 is probably MySQL, at least that's the standard port for MySQL. If your db_url is set to 3306, then that's for sure MYSQL.

Preservica talks directly to MySQL? I thought it uses the API, but I may be wrong on that. What does the config look like for Preservica?

________________________________
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: Tuesday, October 20, 2020 8:50 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Cc: LaPrade, Crista <claprade at richmond.edu>
Subject: [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace Preservica issue

Good morning Blake,

I am working my way through what might be a proxy related and so I went to a console on the affected server and used firefox to locally query the port that Preservica uses.  I am seeing the image below with something about packets out of order.

I begin thinking about the config.rb file that came with the AS version we are using which is 2.5.2.  I upgraded from version 2.5.  One thing to note is that I did not use the new config.rb file.  I tried the old file and it seemingly works fine with everything except the Preservica connection to ArchiveSpace.  The line for connecting to Preservica was already in the old file (no problems connecting before the upgrade) so I didn’t have to change anything there either:

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

So I logged into the server on a console that lets me use the local firefox browser to get to port 3306 locally and this is what I see in the browser.  Does this offer a clue as to what the issue is?

Thanks!

Rick

[cid:32f202fe-89b1-4fa0-b18e-7ccb361a5507]

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 11:46 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Still troubleshooting ArchivesSpace Preservica issue

> 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<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 11:33 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto: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<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 Blake Carver
Sent: Friday, October 16, 2020 10:26 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto: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/20201020/2d350d91/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-waesfaow.png
Type: image/png
Size: 41481 bytes
Desc: Outlook-waesfaow.png
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20201020/2d350d91/attachment.png>