Skip to content

Archiver Appliance 2.5.0 on Tomcat 11, DB setup fix, Data Browser test - #102

Closed
ralphlange wants to merge 0 commit into
epics-training:mainfrom
ralphlange:archiver-appliance-2.5.0
Closed

ralphlange wants to merge 0 commit into
epics-training:mainfrom
ralphlange:archiver-appliance-2.5.0

Conversation

@ralphlange

@ralphlange ralphlange commented Nov 13, 2026 •

Copy link
Copy Markdown
Contributor

Updates the Archiver Appliance, fixes its database setup, points the Phoebus Data Browser at it, and adds functional molecule tests.

  • Archiver Appliance 2.0.7 → 2.5.0 on Tomcat 9.0.79 → 11.0.27 (2.2.0+ needs Tomcat ≥ 10, 2.5.0+ Java ≥ 25). A version flag file in tomcat_home makes existing VMs upgrade: the old Tomcat/appliance files are replaced, storage/, archappl_conf/ and logs are kept. Fixes Update tomcat to version 10.x or later #73.
  • DB tables were never created: mysql_query returns rowcount as a list, so the schema script was always skipped. The role now creates whichever tables the installed version's archappl_mysql.sql defines but the database lacks (also covering upgraded VMs), fails if any are still missing, and waits until the appliance answers.
  • Data Browser: the default archive is now the local appliance (localhost:17665) when archiver_appliance is enabled, instead of a non-existent epics-services-tst:13168.
  • Molecule tests for archiver_appliance (x86_64 and aarch64), in a systemd container with real MariaDB and Tomcat: versions, services, archiving PVs from a temporary IOC over PVA and CA, fetching them via the Data Browser's archive URL, and archiving after a restart. See molecule/README.md.

Parts are taken from osprey-dcs/training-vm@e205cfb and @0cab711 (Wayne Lewis).

Not tested: upgrading an existing 2.0.7/Tomcat 9 VM (CI always starts fresh).

Developed with the assistance of generative AI.

@ralphlange ralphlange self-assigned this Nov 13, 2026
@ralphlange ralphlange added ansible Related to the Ansible roles enhancement New feature or request ci Related to the CI (based on GitHub actions / containers) labels Nov 13, 2026
Comment thread ansible/tests/ci-phoebus-aa.yml Resolved
@ralphlange
ralphlange force-pushed the archiver-appliance-2.5.0 branch 2 times, most recently from 904cc16 to 2936e19 Compare November 14, 2026 16:42
@ralphlange

Copy link
Copy Markdown
Contributor Author

Will merge a rebased version.

Thanks a lot for your help!!

@ralphlange
ralphlange force-pushed the archiver-appliance-2.5.0 branch from 2936e19 to e9c645a Compare November 16, 2026 12:34
@ralphlange ralphlange closed this Nov 16, 2026
@ralphlange
ralphlange force-pushed the archiver-appliance-2.5.0 branch from e9c645a to 61f37da Compare November 16, 2026 13:45
@ralphlange

Copy link
Copy Markdown
Contributor Author

Merged as 61f37da

@ralphlange
ralphlange deleted the archiver-appliance-2.5.0 branch November 16, 2026 13:47
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

ansible Related to the Ansible roles ci Related to the CI (based on GitHub actions / containers) enhancement New feature or request

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Update tomcat to version 10.x or later

3 participants