Test staging server with new OL8 OS Version

[viviant100]

💡 Description

Verify new gamma works the same as exiting gamma

• [x] (1) Github
  • [x] Website Updates
• [x] (2) PDS services
  • [x] DOI service
  • [x] Registry
  • [x] Harvest
  • [x] Registry, Legacy
  • [x] Harvest, Legacy
  • [x] Search-index
  • [x] Validate
• [ ] (3) Browser (Tool/applications through the interfaces)
  • [ ] Data Search
  • [x] Keyword Search
  • [ ] Data Set Status
  • [ ] Tool Registry
  • [ ] Data Dictionary Search
  • [x] DOI Search
  • [ ] Subscription Service
  • [ ] Release Manager
  • [ ] Resource Manager
  • [ ] Catalog Manager
  • [ ] DOI Editor
• [x] (4) Cron jobs
• [ ] (5) Authentication

Procedures:

• [x] NSSDCA
• [ ] Build release

Sub-tasks

• https://github.com/NASA-PDS/registry-legacy-solr/issues/93
• https://github.com/NASA-PDS/ds-view/issues/22
• https://github.com/NASA-PDS/operations/issues/431
• https://github.com/NASA-PDS/operations/issues/435
• https://github.com/NASA-PDS/operations/issues/430
• https://github.com/NASA-PDS/operations/issues/429
• https://github.com/NASA-PDS/operations/issues/428
• https://github.com/NASA-PDS/operations/issues/432
• https://github.com/NASA-PDS/operations/issues/434
• https://github.com/NASA-PDS/operations/issues/496
• https://github.com/NASA-PDS/operations/issues/497
• https://github.com/NASA-PDS/operations/issues/433

[tloubrieu-jpl]

Some issues, @c-suh is interacting with the SAs.

[tloubrieu-jpl]

Blocked until the SA's figure what is wrong with the environment.

[c-suh]

SAs and I are working parallel items for this ticket.

[c-suh]

Multiple updates from the SAs. Must discuss an application with Thomas at next breakout.

[c-suh]

Application in question was discussed with Jordan and addressed. SAs are working with Allan regarding the database, and I must look into Richard's script used in one of the cron jobs.

[c-suh]

SA ticket here.

[tloubrieu-jpl]

SAs are still working on it.

[nutjob4life]

SAs still working on it

[c-suh]

• databases are TBD
• I will take a look at ucd-tools this week
• md5/FIPs error is no longer erroring

[c-suh]

• databases are still not connected
• left a couple questions regarding ucd-tools for the SAs. In the meantime, am trying to set up mvn so as to be able to build this application if needed
• md5/FIPs error is back and I need to look into this

[tloubrieu-jpl]

Catherine need to redeploy some java applications.

[c-suh]

Got a jar from the SA. It's unclear if this is required for multiple applications, but I will look into that after getting mvn set up correctly to be able to build these applications.

[c-suh]

I have maven and java and other aspects set up such that the application is finally building. However, deployment has errors. I've reached out to the SA with questions.

[c-suh]

Am in communication with the SA and Richard about a variety of issues:

• harvest and java
• applications and java
• ucd
• coldfusion

[acyu]

I had tested the following 3 applications on the url listed in this doc ("sub-tickets" section, B18 cell ) and they are working as expected

subscription service release manager catalog manager

[tloubrieu-jpl]

See for details https://docs.google.com/spreadsheets/d/152V38MQh6iuP0s7u7ozweAColbQGZ3-TkwrPgJOneiI/edit?usp=drive_web&ouid=114680991820234785180

[c-suh]

Catching up with various tickets and notes. In the meantime, re-initial testing:

• Data Search: php 500
• Keyword Search: 503
• Data Set Status: no results. Likely something to do with the database
• Tool Registry: 503 and Uncaught SyntaxError: Unexpected token '<'
• Data Dictionary Search: 503 and Uncaught SyntaxError: Unexpected token '<'
• DOI Search: returns results
• Subscription Service: Error Executing Database Query: null, message from server: "Host '10.100.3.204' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
• Release Manager: Error Executing Database Query: null, message from server: "Host '10.100.3.204' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
• Resource Manager: database connection failed
• Catalog Manager: Error Executing Database Query: null, message from server: "Host '10.100.3.204' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
• DOI Editor: 403 Forbidden

[tloubrieu-jpl]

@c-suh is exchanging with the SA on the database issue and will do more testing.

[tloubrieu-jpl]

The SA in charge is out sick.

[c-suh]

• Data Search: (same as before) php 500
• Keyword Search: works!
• Data Set Status: (same as before) no results
• Tool Registry: Uncaught SyntaxError: Unexpected token ':'
• Data Dictionary Search: Uncaught SyntaxError: Unexpected token ':'
• DOI Search: (same as before) returns results
• Subscription Service: login works!
• Release Manager: login works!
• Resource Manager: (same as before) database connection failed
• Catalog Manager: login works!
• DOI Editor: (same as before) 403 Forbidden

[c-suh]

Database issue again and have asked the SA about it.

[tloubrieu-jpl]

Database issue is fixed by the SAs (too many connexion error).

[jordanpadams]

@c-suh

Tool Registry: Uncaught SyntaxError: Unexpected token ':' Data Dictionary Search: Uncaught SyntaxError: Unexpected token ':'

FYI, these all are supposed to query the new Solr, so we will need to modify them to query the new API. TBD on this until we actually get it working.

[jordanpadams]

We should probably just create separate tickets for addressing those. For the things that are not working, let's create individual tickets for those.

[jordanpadams]

Per testing, I think keyword search and accompanying registry components are successful. Deployment history in wiki has been updated.

[c-suh]

Using TestRail to keep track of tests/results.

[c-suh]

Resuming testing of the checklisted items and starting review of the linked subtasks. A note that there is no exiting gamma to compare this one to.