Stream: troubleshooting

Topic: upgrading 5.14 to 6.0


view this post on Zulip jamie jamison (May 08 2024 at 19:09):

I'm upgrading 5.14 to 6.0 on RHEL 7.9. First issue I've run into is the Java 17 upgrade. Following the directions (https://github.com/IQSS/dataverse/releases/tag/v6.0) to install java-17-openjdk I got the error: No package java-17-openjdk available.
Is this because I'm still on RHEL 7.9? I'm going to go looking for another source for java 17.

Is openjdk-17-jdk the same package?

view this post on Zulip Philip Durbin πŸš€ (May 08 2024 at 20:21):

Let's see, as of Dataverse 6.0 it looks like we were recommending RHEL 8: https://guides.dataverse.org/en/6.0/installation/prerequisites.html#linux

view this post on Zulip Philip Durbin πŸš€ (May 08 2024 at 20:21):

Any chance you can upgrade from RHEL 7 to 8?

view this post on Zulip Philip Durbin πŸš€ (May 08 2024 at 20:22):

(6.2 says the same, by the way, RHEL 8: https://guides.dataverse.org/en/6.2/installation/prerequisites.html#linux )

view this post on Zulip jamie jamison (May 08 2024 at 20:22):

We're planning on it. It was recommended that we go from 6.0 to 6.2 first. Then upgrade but I guess that's not going to work.

view this post on Zulip Philip Durbin πŸš€ (May 08 2024 at 20:24):

5.14 should run fine on both RHEL 7 and 8.

view this post on Zulip jamie jamison (May 08 2024 at 20:27):

Ok, so upgrade RHEL first. I found the RHEL has an upgrade in place option. Any recommendations on upgrading?

view this post on Zulip Philip Durbin πŸš€ (May 08 2024 at 20:34):

Jeez, it's been a while. Upgrading in place for RHEL 4 to 5, for example, I don't believe was ever recommended. Hopefully it's gotten better.

view this post on Zulip jamie jamison (May 08 2024 at 21:06):

This is the test system

view this post on Zulip Philip Durbin πŸš€ (May 08 2024 at 22:08):

Phew.

view this post on Zulip jamie jamison (May 09 2024 at 00:42):

So far upgrading RHEL7 to 8 inplace with leapp has some pretty major dependancy problems. I'm considering making a new clean install and mounting the s3 buckets to the new machine - if all else fails.

view this post on Zulip Philip Durbin πŸš€ (May 09 2024 at 00:56):

Nothing like a new clean install. :broom:

view this post on Zulip Philip Durbin πŸš€ (May 10 2024 at 18:14):

@jamie jamison Huh. I saw your messages to https://groups.google.com/g/dataverse-dev/c/1-Rj80A02No/m/jCBPyE85AgAJ briefly but now the are gone. Let me know if you'd like to discuss here.

view this post on Zulip jamie jamison (May 14 2024 at 01:41):

At this point updating in place doesn't seem like an option since some of the dependancies for leapp are now unavailable. I'm working on a test instance for a clean install. Documentation for 6.2 (the latest) recommends RHEL8. Has anyone successfully used RHEL9? I'm looking at what's available on aws.

view this post on Zulip jamie jamison (May 14 2024 at 01:43):

By the way, creating an instance from scratch and moving over relivent info is a good way to test my disaster rebuild plan.

view this post on Zulip Philip Durbin πŸš€ (May 14 2024 at 15:42):

@Don Sizemore would know better than I would but I believe Rocky 9 is working fine but somehow we have a test failing:

AdminIT.testBannerMessages failing on Rocky 9 #10312

At the moment we are testing with Rocky 8.9: https://github.com/GlobalDataverseCommunityConsortium/dataverse-ansible/blob/2f605efb9ac22614bce7cc4b9acf718ba2d66b3b/ec2/ec2-create-instance.sh#L14

view this post on Zulip jamie jamison (May 14 2024 at 16:41):

I'll see what version of RHEL8 is available on aws

view this post on Zulip Don Sizemore (May 14 2024 at 16:57):

@Philip Durbin JP is on the case as we type!
@jamie jamison you can find RockyLinux AMIs here https://rockylinux.org/download

view this post on Zulip jamie jamison (May 14 2024 at 21:21):

Crazy as this sounds I'm having trouble with AWS getting the available RHEL8.6 to work with the t2.large machine.

view this post on Zulip Philip Durbin πŸš€ (May 15 2024 at 01:55):

Huh. What kind of trouble?

view this post on Zulip jamie jamison (May 15 2024 at 03:10):

Up to now I've used the AWS AMIs. Right now the only AWS AMI 8.6 launch fials beause the included Microsoft SQL Server is not supported for the instance type 't2.large' - which is the size of the dataverse test instance.
So if I'm using the AWS supplied AMI the only option is a RHEL 9. Or look through the 3rd party AMIs for one that uses RHEL 8.

view this post on Zulip Philip Durbin πŸš€ (May 15 2024 at 10:04):

Huh. We don't even need Microsoft SQL Server

view this post on Zulip Don Sizemore (May 15 2024 at 11:57):

@jamie jamison You don't want the RHEL 8.9 AMI? the standard image shouldn't include MS SQL anything; I'm not sure that's the correct image.

view this post on Zulip jamie jamison (May 15 2024 at 16:46):

I'll have to dig some more. Didn't see the RHEL 8.9 AMI.

view this post on Zulip Don Sizemore (May 15 2024 at 17:14):

@jamie jamison if you specifically want RHEL, try this one? https://aws.amazon.com/marketplace/pp/prodview-kv5mi3ksb2mma

view this post on Zulip jamie jamison (May 15 2024 at 17:17):

I have to find out what the status is of our subscription. I'm specifically running RHEL since that's whats listed in the documentation and I try to stay close to that to make troubleshooting easier.

view this post on Zulip jamie jamison (May 16 2024 at 20:49):

As followup info. Just spent time with an extremely helpful AWS RedHat support person. After about an hour and a helf we both came to conclusion that a fresh install would be the best solution. I have a test.dataverse 8.6 spun up and am going to do a fresh 6.2 install.
Might as well mark this as resolved.

view this post on Zulip Philip Durbin πŸš€ (May 16 2024 at 20:52):

Oh, well, there's no rush. Good luck with the upgrade! Please keep us posted! We can keep this open.

view this post on Zulip jamie jamison (May 17 2024 at 22:10):

I'm using the ansible script for a fresh install of 6.2. Ansible script is how I installed the original dataverse. Is there are prefered method - meaning ansible or 'standard'?

view this post on Zulip Philip Durbin πŸš€ (May 18 2024 at 13:08):

I'm a big fan of the Ansible scripts

view this post on Zulip jamie jamison (May 20 2024 at 16:43):

That was how I installed Dataverse the first time. I believe it was 4.something and that worked out well. Ansible is a good tool.

view this post on Zulip Philip Durbin πŸš€ (May 20 2024 at 17:41):

All credit to @Don Sizemore for it!

view this post on Zulip jamie jamison (May 20 2024 at 21:19):

I'm going throught the ansible script. What I'm not sure about is the letsencrypt part. Should I be installing certbot to setup letsencrypt? I don't see any reference in the 6.2 documentation, first place I seee it is in the ansible script, line 37

view this post on Zulip Philip Durbin πŸš€ (May 20 2024 at 21:21):

Hmm. I suppose it's fine to try it. If it doesn't work you could always add a cert manually.

view this post on Zulip jamie jamison (May 22 2024 at 01:15):

I'm still woking on getting the ssl keys. BUt going through the ansible script and noticed line 371 has the option to install munin, default is false. I have never been able to install munin on the old RHEL7 or the new RHEL 8.9. Seems to be missing pearl although I have pearl5 version 26.

view this post on Zulip jamie jamison (May 22 2024 at 01:27):

And as usual I found an answer after whining in zulip. Besides perl you have to install perl-IPC-Run. And then it installs. Wish that info was on the munin site but found in stackexchange

view this post on Zulip Philip Durbin πŸš€ (May 22 2024 at 02:28):

Oh! Glad you got Munin installed!

view this post on Zulip Don Sizemore (May 22 2024 at 11:38):

@jamie jamison that Munin task hasn't been updated in four years. it needs perl-IPC-Run, anything else? I'll be happy to update it.

view this post on Zulip jamie jamison (May 22 2024 at 17:18):

It needs perl and the package I needed was perl-IPC-Run. Found that solution in stackexchange.

view this post on Zulip jamie jamison (May 22 2024 at 17:18):

By the way thak you

view this post on Zulip jamie jamison (May 22 2024 at 17:18):

This is the first fresh install I've done since 4.something

view this post on Zulip jamie jamison (May 22 2024 at 17:22):

I have another question about the script. Line 468 has orcid enabled true or default false. I always thought that orcid ids were for an individual. Is this for an organizational orcid id?

view this post on Zulip Don Sizemore (May 22 2024 at 17:40):

@jamie jamison it looks like we just support enabling it as an authenticationProvider? https://github.com/GlobalDataverseCommunityConsortium/dataverse-ansible/blob/develop/tasks/orcid.yml

view this post on Zulip jamie jamison (May 22 2024 at 17:41):

Thank you. Would it halp if I volunteer to do some commenting in the ansible script? For newbys such as myself.

view this post on Zulip Don Sizemore (May 22 2024 at 17:43):

@jamie jamison absolutely!

view this post on Zulip jamie jamison (May 22 2024 at 18:07):

Running script. Failed at:
TASK [dataverse : RHEL8/9 need codeready-builder] **************
fatal: [localhost]: FAILED! => {"changed": false, "msg": "codeready-builder-for-rhel-8-x86_64-rpms is not a valid repository ID", "results": ["codeready-builder-for-rhel-8-x86_64-rpms is not a valid repository ID"]}

view this post on Zulip Don Sizemore (May 22 2024 at 18:09):

@jamie jamison I'm not sure if you need a subscription for that on RHEL? we test on RockyLinux

view this post on Zulip jamie jamison (May 22 2024 at 18:10):

I'm on aws which is different then a subscription. I may have to hit up aws tech support

view this post on Zulip Don Sizemore (May 22 2024 at 18:11):

looks like RHEL in AWS wants sudo dnf config-manager --set-enabled rhui-codeready-builder-for-rhel-8-rhui-rpms

view this post on Zulip Don Sizemore (May 22 2024 at 18:12):

I opened https://github.com/GlobalDataverseCommunityConsortium/dataverse-ansible/issues/354

view this post on Zulip jamie jamison (May 22 2024 at 18:18):

I'm going to contact aws tech support and will post answer here

view this post on Zulip Don Sizemore (May 22 2024 at 18:27):

ugh =( I'll update Ansible to do what needs doing, once we pin that down.

view this post on Zulip jamie jamison (May 22 2024 at 18:32):

The fault isn't your ansible script but aws. Something I'll add to the comments when I get an answer.

view this post on Zulip jamie jamison (May 22 2024 at 23:02):

I don't have a solution yet but the ansible install fails on rserve.yml, line 13-22

view this post on Zulip jamie jamison (May 23 2024 at 17:52):

This is probably an inappropriate way to fix a problem. I just opened redhat-rhui.repo with vim, looked for the codeready-builder repo and manually set enabeled from 0 to 1.
I'd hardly call that problem solved but now I can work through any other ansible script errors that pop up.

view this post on Zulip Don Sizemore (May 23 2024 at 18:04):

@jamie jamison that is absolutely a way to fix it! just to confirm, on RHEL the repo name is still codeready-builder-for-rhel-8-x86_64-rpms ?

view this post on Zulip jamie jamison (May 23 2024 at 18:10):

yes. There is codeready-builder-for-rhel-8-rhui-rpms and codeready-builder-for-rhel-8-rhui-debug-rpms

Fixable errors I'm running into now are python needed to be installed from pip3 rather than the 'official' rhel repo and some aws-and-ansible related issues. (yes, I'm keeping a list). Ansible has good trouble shoothing notes. Example: "* On some systems (such as AWS RDS),Β pg_authidΒ is not accessible, thus, the module cannot compare the current and desiredΒ password. In this case, the module assumes that the passwords are different and changes it reporting that the state has been changed. To skip all password related checks for existing users, useΒ no_password_changes=yes."

view this post on Zulip jamie jamison (May 23 2024 at 20:46):

And having trouble with codeready-builder-for-rhel-8-x86_64-rpms again, or really in a different place.

view this post on Zulip jamie jamison (May 23 2024 at 21:45):

Definately stuck in a different place, trying to find package "codeready-builder-for-rhel-8-x86_64-rpmsdf". I think this is a different codebuilder package.

view this post on Zulip jamie jamison (May 24 2024 at 16:10):

I finally decided RHEL on AWS wasn't going to be working anytime soon and spun up a test server for Rocky 8.9. Ran perfectly up to the rsever part. (https://github.com/IQSS/dataverse/issues/10452).
New question. I'm running Rocky 8.9. Any opinions on whether it would be better to go straight to Rocky 9?

view this post on Zulip Don Sizemore (May 24 2024 at 16:32):

as of yesterday, the test suite succeeds on Rocky 9, so yes! you can install it with the Rocky 9 branch of Dataverse-Ansible: https://github.com/GlobalDataverseCommunityConsortium/dataverse-ansible/blob/243_rocky_9/ec2/ec2-create-instance.sh
launched with something like: $ ec2/ec2-create-instance.sh -v -g your_group_vars_file -a 243_rocky_9

view this post on Zulip Don Sizemore (May 24 2024 at 16:33):

the test failure, fixed in develop but post-6.2, involves an unnecessary check for $LANG. most other places the default is en_us.UTF-8 but on Rocky 9 AMIs for some strange reason it's simply C.

view this post on Zulip jamie jamison (May 24 2024 at 16:34):

I'll try Rocky 9. Might mean putting off the enevitable OS upgrade. Maybe I can kick the proverbial can down past my retirement.

view this post on Zulip Don Sizemore (May 24 2024 at 16:35):

this is one reason I'm a big fan of RHEL9 / Rocky 9 - it EOLs on May 31st, 2032, by which point I should have full retirement eligibility.

view this post on Zulip jamie jamison (May 24 2024 at 19:24):

6.2 ansible script ran to finsh successfully on Rocky 9!! I'll send comment notes on what did or didn't work with RedHat and Rocky 8.9.
Guess next I reload the postgres database.

view this post on Zulip jamie jamison (May 24 2024 at 21:27):

This is just for clarification - to drop (and then restore) do I have to dataverse? directions say to run the installer again but what I'd like to do, if it's possible is restore from the RHEL7 test.dataverse database dump. (referring to directions: https://guides.dataverse.org/en/latest/installation/installation-main.html#drop-database)

view this post on Zulip Don Sizemore (May 25 2024 at 11:13):

@jamie jamison feel free to open issues at https://github.com/GlobalDataverseCommunityConsortium/dataverse-ansible/issues but once AWS publishes the Rocky 9.4 AMI, with IQSS' blessing I plan to switch our CI testing to Rocky 9.4, and finally submit my 2 year-old pull request to make the Dataverse installation documentation say RHEL9.

view this post on Zulip jamie jamison (May 29 2024 at 19:16):

I'm not sure if this is the best way to rebuild dataverse. I've gotten 6.2 installed. What I'm trying to do now is restore the mysql database from my 5.14 installation. Is that the correct procedure - drop the dvndb that was installed in 6.2 and restore the 5.14 dvndb?

view this post on Zulip Don Sizemore (May 29 2024 at 19:30):

jamie jamison said:

I'm not sure if this is the best way to rebuild dataverse. I've gotten 6.2 installed. What I'm trying to do now is restore the mysql database from my 5.14 installation. Is that the correct procedure - drop the dvndb that was installed in 6.2 and restore the 5.14 dvndb?

you probably want to undeploy 6.2, restore your postgres db from 5.14, then redeploy 6.2 to be sure that FlyWay updates the DB schema. I think FlyWay does this on each auto-deployment when you launch Payara, but undeploying and redeploying would make certain.

view this post on Zulip jamie jamison (May 29 2024 at 19:31):

Ok, I'll add that to my notes.

view this post on Zulip jamie jamison (May 29 2024 at 19:42):

I think I see a poster for next community meeting...

view this post on Zulip jamie jamison (May 29 2024 at 19:48):

in the event I mess things up completely, can I just rerun the ansible script

view this post on Zulip jamie jamison (May 29 2024 at 20:14):

I may have broken postgres by dropping the table too early. Can I just rerun the ansible script?

view this post on Zulip jamie jamison (May 29 2024 at 21:12):

and I answered my own question. Re-ran the ansible script after potentially breaking the postgres database and it looks like it worked

view this post on Zulip jamie jamison (Jun 07 2024 at 22:25):

This could be my mistake but the latest directions for installing Shibboleth (https://guides.dataverse.org/en/latest/installation/shibboleth.html#install-shibboleth) say to install from the yum repo.
Result:
sudo yum install shibboleth
Last metadata expiration check: 1:12:53 ago on Fri Jun 7 21:11:19 2024.
No match for argument: shibboleth
Error: Unable to find a match: shibboleth

It this isn't a mistake on my part I'll make an issue.

view this post on Zulip Don Sizemore (Jun 08 2024 at 11:42):

@jamie jamison what did the Shibboleth webform generate for your shibboleth.repo file? (I haven't used it in a while)

view this post on Zulip jamie jamison (Jun 11 2024 at 03:40):

I'll have to get back to that one. Still having problems connecting to the s3 buckets.

view this post on Zulip Don Sizemore (Jun 11 2024 at 12:25):

@jamie jamison are you still getting those 403 forbiddens? (which S3 privileges are you assigning that IAM role?)

view this post on Zulip jamie jamison (Jun 11 2024 at 18:07):

I've tested using the aws cli: aws s3 ls s3://dataverse-test-oregon
An error occurred (AccessDenied) when calling the ListObjectsV2 operation: Access Denied
{
"Sid": "VisualEditor0",
"Effect": "Allow",
"Action": "s3:*",
"Resource": [
"arn:aws:s3:::dataverse-test-oregon/*"
]
},

s3-serviece: Limited: List, Permissions management, Read, Write, Tagging

The "s3:*" action works for the production server but not the new test instance.

view this post on Zulip Don Sizemore (Jun 11 2024 at 18:33):

@jamie jamison are you sure the bucket policy is assigned to the correct role/group?

view this post on Zulip jamie jamison (Jun 11 2024 at 19:22):

It's attached to the user. This is the same setup as production, which works.

view this post on Zulip Sherry Lake (Jun 12 2024 at 14:46):

Anyone online for a question about upgrading to Payrara6 and editing the domain.xml

view this post on Zulip Don Sizemore (Jun 12 2024 at 15:03):

@Sherry Lake I'm online, for what I'm worth?

view this post on Zulip Sherry Lake (Jun 12 2024 at 15:48):

OK.... we just didn't wait long enough to see our dataverse page.

view this post on Zulip Don Sizemore (Jun 12 2024 at 15:57):

@Sherry Lake if it was after a server or Payara restart, the first load can take up to 10 seconds as it populates its cache


Last updated: Oct 30 2025 at 06:21 UTC