> 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-boun...@lyralists.lyrasis.org
<archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Neal,
Rick <rn...@richmond.edu>
Sent: Friday, October 16, 2020 11:33 AM
To: Archivesspace Users Group <archivesspace_users_group@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@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-boun...@lyralists.lyrasis.org
<archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of Blake
Carver
Sent: Friday, October 16, 2020 10:26 AM
To: Archivesspace Users Group <archivesspace_users_group@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-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 Neal, Rick <rn...@richmond.edu<mailto:rn...@richmond.edu>>
Sent: Friday, October 16, 2020 8:57 AM
To: Archivesspace Users Group
<archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Cc: LaPrade, Crista <clapr...@richmond.edu<mailto:clapr...@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
_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
