Dependencies update: MySQL

[Tom-Willemsen]

Issue Description

Sub-ticket of https://github.com/ISISComputingGroup/IBEX/issues/8468 as the MySQL update is relatively tricky this time and seems best as it's own ticket.

Update:

• MySQL server to latest 8.4 version (we chose not to go with 9.x as it is not LTS)
• MySQL cpp bindings
• Various places that are broken by the newer MySQL version

Do as part of main dep update ticket:

• GUI sql bindings

How to Review

Check that:

• [ ] MySQL server is on 8.4
• [ ] MySQL c++ connector uses supported version of bindings
• [ ] IBEX works

_{To the reviewer: Make sure to update submodules!}

[Tom-Willemsen]

The changes in this ticket are:

• Move to MySQL 8.4.x LTS
• Move to more modern C++ bindings
  • Various tweaks to accomodate how the new bindings get built
• Remove C bindings which are no longer maintained and which we were not using (except as a dependency of the previous version of the c++ bindings)
• Move to caching_sha2_password as recommended by MySQL as our default auth mechanism (mysql_native_password is deprecated in 8.4.x, and is removed in 9.x)
• Tweaks to many jdbc connection strings to allow use of caching_sha2_password as the auth mechanism (not all places seem to require this, but many did)

---

To review this functionally:

• [ ] Stop IBEX server
• [ ] Check out all branches
• [ ] Run create_icp_binaries.bat from top-level EPICS
• [ ] Run git submodule update --init --recursive . from c:\instrument\apps\epics\support\mysql\master
• [ ] Run git clean -fqdx && make in c:\instrument\apps\epics\support\mysql\master
• [ ] Run git clean -fqdx && make in c:\instrument\apps\epics\support\pvdump\master
• [ ] Run make clean uninstall && make -j64 in c:\instrument\apps\epics\ioc\master
• [ ] Run git clean -fqdx && make in c:\instrument\apps\epics\ISIS\ioclogserver\master
• [ ] Run developer_update.bat from ibex_utils/installation_and_upgrade
• [ ] Verify version 8.4.2 of mysql has been installed in c:\instrument\apps\mysql successfully
• [ ] Verify using mysql command line or MySQL workbench that relevant DB schemas have been created
• [ ] Start IBEX server
• [ ] Verify that IBEX components which use MySQL work correctly:
  • [ ] Block archiver (http://localhost:4813/group?name=BLOCKS should display a list containing your current blocks)
  • [ ] Inst archiver (http://localhost:4812/group?name=INST should display many PVs for various IOCs)
  • [ ] Alarms view in GUI (cause a PV to go into alarm, acknowledge alarm, etc)
  • [ ] Data browser
  • [ ] Add a block on a motor
  • [ ] Move the motor
  • [ ] Wait a bit
  • [ ] Display block history, should see the move in the log plotter that opens
  • [ ] IOC log - should display various messages with "INFO" severity filter selected
  • [ ] MOXA view (this goes via DBSVR, check it contains details of any moxas you have mapped)
  • [ ] Any other relevant functionality you can think of
• [ ] Verify there are no obvious errors relating to mysql in the logs for
  • [ ] A representative IOC (e.g. simple, instetc) - in particular where it uses pvdump
  • [ ] Blockserver (BLOCKSVR)
  • [ ] Block archiver (ARBLOCK)
  • [ ] Inst archiver (ARINST)
  • [ ] Database server (DBSVR)
  • [ ] Ioc log server (IOCLOG)
  • [ ] Any other relevant logs you can think of

---

This is quite likely to break linux and/or static and/or debug builds as I haven't tested all permutations. I think it will be easiest to get those permutations working on the build server after review of the main (windows 64bit dynamic) case.

[Tom-Willemsen]

Note: isisicp will currently fail to write .log files on end with the new mysql version, likely https://github.com/ISISNeutronMuon/ISISICP/pull/47 will help with that.