Problem Upgrading from MySQL 5.7 to MySQL 8.0 – Agents Missing
Now that I am running Pandora 773.x, I’ve been getting a warning about upgrading MySQL from 5.7 to 8.0. I followed the instructions found here: Upgrading from MySQL 5.7 to MySQL 8 [current] (pandorafms.com)
I am running CentOS 7, so I followed that part of the instructions. All seems to go well. When I restart and browse the console, I see that users, plugins, alert actions, and alert commands are all restored. What is not restored are all of my custom remote agents and associated modules.
The only errors shown during the database restore are these:
ERROR 1054 (42S22): Unknown column ‘transactional_agent’ in ‘field list’
ERROR 1146 (42S02): Table ‘pandora.tfiles_repo’ doesn’t exist
ERROR 1146 (42S02): Table ‘pandora.tfiles_repo_group’ doesn’t exist
ERROR 1146 (42S02): Table ‘pandora.tnetwork_matrix’ doesn’t exist
ERROR 1146 (42S02): Table ‘pandora.tmetaconsole_event’ doesn’t exist
ERROR 1146 (42S02): Table ‘pandora.tmetaconsole_event_history’ doesn’t exist
Is there an extra step I’m missing?
Version v7.0NG.773.3 – Community
MR version MR65
mysql Ver 14.14 Distrib 5.7.42-46, for Linux (x86_64) using 6.2
- This discussion was modified 2 weeks, 3 days ago by aeleus.