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-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of Neal, Rick <rn...@richmond.edu> Sent: Tuesday, October 20, 2020 8:50 AM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Cc: LaPrade, Crista <clapr...@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-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of Blake Carver Sent: Friday, October 16, 2020 11:46 AM To: Archivesspace Users Group <archivesspace_users_group@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-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 11:33 AM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org<mailto: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<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 Blake Carver Sent: Friday, October 16, 2020 10:26 AM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org<mailto: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