3.3.x RELEASE NOTES

[phirstgemini]

Merge branches

• merge enh/for3.3 into main
• merge enh/aws_s3_copy into main
• merge sqlalchemy_update into main
• merge enh/userdb_sync into main, then remove sync script and endpoint. There are other changes in here we want.
• merge enh/userdb_oauth into main
• merge enh/selection_class into main
• Test and Fix.
• branch release/3.3.x from main

Archive stuff

• stop exports from summits
• stop queues
• database backup:
• • pg_dump --format=d --file=rel3.2final.pg_dump.d --exclude-table='*queue*' --jobs=12 --compress=1 fitsdata
• • takes about 16 minutes, 38GB. Can re-compress later.
• disable public access
• assign IAM role to EC2 host in AWS console
• delete aws access key and secret key from /etc/fits_storage.conf
• add oath config info to config files. Consider what should be in FitsStorageConfig and what in the /etc/fitsstorage.conf
• general updates
• re-enable queues
• re-enable public access
• re-enable summit exports
• delete access key for operations in AWS console

General stuff

• stop all services
• pip install pyjwt
• pip install cryptography
• update sqlalchemy version to 2.x
• deploy release/3.3.x to host
• Add columns to users table:
• • alter table users add column last_login timestamp without time zone;
• • alter table users add column noirlab_id text;
• • alter table users add column last_login_by text;
• • alter table users add column instrument_team text;
• • create index ix_users_noirlab_id on users (noirlab_id);
• • alter table filedownloadlog add column inst_team_access boolean;
• restart all services
• check S3 access
• check OAuth functionality