Nagios Support Forum

All of this is happening on a test server.
Built a new Ubuntu 22.04 LTS Server, the previous server was CentOS 7
Installed Nagios 5.9.1
Restored backup of Nagios (no major issues)
Tried to switch DB from PostgreSQL to MySQL

Got the following error

root@byfnagxi01:/opt/install/nagios/pg2mysql-master# mysql -u root -pnagiosxi -e "CREATE USER 'nagiosxi'@'localhost' IDENTIFIED BY 'n@gweb';"
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'nagiosxi'@'localhost'

Attached putty.log showing all steps taken since the restore.

I'd recommend at least going to a 5.10 release of Nagios xi, and preferably something newer than that. We have a guide for it here:

https://nagiosenterprises.my.site.com/s ... Conversion

Now upgraded to 5.11.3 and reran the commands but have the following errors

root@byfnagxi01:/opt/install/nagios/pg2mysql-master# pg_dump --no-acl --no-owner --format p --data-only -U nagiosxi nagiosxi > nagiosxi.psql
root@byfnagxi01:/opt/install/nagios/pg2mysql-master# php pg2mysql_cli.php nagiosxi.psql nagiosxi.mysql myisam
MIB search path: /root/.snmp/mibs:/usr/share/snmp/mibs:/usr/share/snmp/mibs/iana:/usr/share/snmp/mibs/ietf
Cannot find module (CISCOSB-MIB): At line 4 in /usr/share/snmp/mibs/CISCOSBenv_mib.mib
Did not find 'switch001' in module #-1 (/usr/share/snmp/mibs/CISCOSBenv_mib.mib)
Unlinked OID in CISCOSB-HWENVIROMENT: rlEnv ::= { switch001 83 }
Undefined identifier: switch001 near line 8 of /usr/share/snmp/mibs/CISCOSBenv_mib.mib
Did not find 'rlEnv' in module CISCOSB-HWENVIROMENT (/usr/share/snmp/mibs/CISCOSB_sensor.mib)
Unlinked OID in CISCOSB-SENSORENTMIB: rlEntPhySensorTable ::= { rlEnv 3 }
Undefined identifier: rlEnv near line 42 of /usr/share/snmp/mibs/CISCOSB_sensor.mib
Unlinked OID in CISCOSB-SENSORENTMIB: rlSensor ::= { rlEnv 4 }
Undefined identifier: rlEnv near line 22 of /usr/share/snmp/mibs/CISCOSB_sensor.mib
Cannot find module (CISCOSB-MIB): At line 9 in /usr/share/snmp/mibs/CISCOSB-cli-mib.mib
Did not find 'switch001' in module #-1 (/usr/share/snmp/mibs/CISCOSB-cli-mib.mib)
Unlinked OID in CISCOSB-CLI-MIB: rlCli ::= { switch001 52 }
Undefined identifier: switch001 near line 14 of /usr/share/snmp/mibs/CISCOSB-cli-mib.mib
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputsEntry ::= { rlCLIremoteCLIoutputsTable 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIsupport ::= { rlCli 6 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliFileEnableAfterReset ::= { rlCli 5 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliFileEnable ::= { rlCli 4 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliTimer ::= { rlCli 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliPassword ::= { rlCli 2 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliMibVersion ::= { rlCli 1 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEntPhySensorEntry ::= { rlEntPhySensorTable 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCli ::= { switch001 52 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnv ::= { switch001 83 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlSensor ::= { rlEnv 4 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEntPhySensorTable ::= { rlEnv 3 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanSupported ::= { rlEnv 7 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanTable ::= { rlEnv 6 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanData ::= { rlEnv 5 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvPhysicalDescription ::= { rlEnv 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataDirection ::= { rlEnvFanDataEntry 6 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataAdminLevel ::= { rlEnvFanDataEntry 5 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataOperLevel ::= { rlEnvFanDataEntry 4 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataSpeed ::= { rlEnvFanDataEntry 3 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataTemp ::= { rlEnvFanDataEntry 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataStackUnit ::= { rlEnvFanDataEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyStatusTable ::= { rlEnvPhysicalDescription 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanStatusTable ::= { rlEnvPhysicalDescription 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanEntry ::= { rlEnvRedundantFanTable 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputCommandNumber ::= { rlCLIremoteCLIoutputsEntry 5 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputRowStatus ::= { rlCLIremoteCLIoutputsEntry 4 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputRowPart ::= { rlCLIremoteCLIoutputsEntry 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputRowPartNumber ::= { rlCLIremoteCLIoutputsEntry 2 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputRowIndex ::= { rlCLIremoteCLIoutputsEntry 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandsEntry ::= { rlCLIremoteCLIcommandsTable 1 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEnvPhySensorLocation ::= { rlEntPhySensorEntry 4 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEnvPhySensorTestValue ::= { rlEntPhySensorEntry 3 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEnvPhySensorMaxValue ::= { rlEntPhySensorEntry 2 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEnvPhySensorMinValue ::= { rlEntPhySensorEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyStatusEntry ::= { rlEnvMonSupplyStatusTable 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanStatusEntry ::= { rlEnvMonFanStatusTable 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanStatus ::= { rlEnvRedundantFanEntry 3 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanIndex ::= { rlEnvRedundantFanEntry 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanUnitId ::= { rlEnvRedundantFanEntry 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIactivationStatus ::= { rlCLIremoteCLIcommandsEntry 5 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandStatus ::= { rlCLIremoteCLIcommandsEntry 4 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandPart ::= { rlCLIremoteCLIcommandsEntry 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandPartNumber ::= { rlCLIremoteCLIcommandsEntry 2 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandIndex ::= { rlCLIremoteCLIcommandsEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyFanDirection ::= { rlEnvMonSupplyStatusEntry 5 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplySource ::= { rlEnvMonSupplyStatusEntry 4 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyState ::= { rlEnvMonSupplyStatusEntry 3 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyStatusDescr ::= { rlEnvMonSupplyStatusEntry 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyStatusIndex ::= { rlEnvMonSupplyStatusEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataTable ::= { rlEnvFanData 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIinstance ::= { rlCLIremoteCLIsupport 7 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputsTable ::= { rlCLIremoteCLIsupport 6 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandsTable ::= { rlCLIremoteCLIsupport 5 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLImode ::= { rlCLIremoteCLIsupport 4 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIexecutionCommandIndex ::= { rlCLIremoteCLIsupport 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIexecutionState ::= { rlCLIremoteCLIsupport 2 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommand ::= { rlCLIremoteCLIsupport 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanState ::= { rlEnvMonFanStatusEntry 3 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanStatusDescr ::= { rlEnvMonFanStatusEntry 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanStatusIndex ::= { rlEnvMonFanStatusEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataEntry ::= { rlEnvFanDataTable 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputsEntry ::= { rlCLIremoteCLIoutputsTable 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliMibVersion ::= { rlCli 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliPassword ::= { rlCli 2 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliTimer ::= { rlCli 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliFileEnable ::= { rlCli 4 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCliFileEnableAfterReset ::= { rlCli 5 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIsupport ::= { rlCli 6 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEntPhySensorEntry ::= { rlEntPhySensorTable 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnv ::= { switch001 83 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCli ::= { switch001 52 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvPhysicalDescription ::= { rlEnv 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanData ::= { rlEnv 5 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanTable ::= { rlEnv 6 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanSupported ::= { rlEnv 7 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEntPhySensorTable ::= { rlEnv 3 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlSensor ::= { rlEnv 4 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanStatusTable ::= { rlEnvPhysicalDescription 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyStatusTable ::= { rlEnvPhysicalDescription 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataStackUnit ::= { rlEnvFanDataEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataTemp ::= { rlEnvFanDataEntry 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataSpeed ::= { rlEnvFanDataEntry 3 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataOperLevel ::= { rlEnvFanDataEntry 4 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataAdminLevel ::= { rlEnvFanDataEntry 5 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataDirection ::= { rlEnvFanDataEntry 6 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanEntry ::= { rlEnvRedundantFanTable 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputRowIndex ::= { rlCLIremoteCLIoutputsEntry 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputRowPartNumber ::= { rlCLIremoteCLIoutputsEntry 2 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputRowPart ::= { rlCLIremoteCLIoutputsEntry 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputRowStatus ::= { rlCLIremoteCLIoutputsEntry 4 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputCommandNumber ::= { rlCLIremoteCLIoutputsEntry 5 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandsEntry ::= { rlCLIremoteCLIcommandsTable 1 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEnvPhySensorMinValue ::= { rlEntPhySensorEntry 1 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEnvPhySensorMaxValue ::= { rlEntPhySensorEntry 2 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEnvPhySensorTestValue ::= { rlEntPhySensorEntry 3 }
Cannot adopt OID in CISCOSB-SENSORENTMIB: rlEnvPhySensorLocation ::= { rlEntPhySensorEntry 4 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyStatusEntry ::= { rlEnvMonSupplyStatusTable 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanStatusEntry ::= { rlEnvMonFanStatusTable 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanUnitId ::= { rlEnvRedundantFanEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanIndex ::= { rlEnvRedundantFanEntry 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvRedundantFanStatus ::= { rlEnvRedundantFanEntry 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandIndex ::= { rlCLIremoteCLIcommandsEntry 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandPartNumber ::= { rlCLIremoteCLIcommandsEntry 2 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandPart ::= { rlCLIremoteCLIcommandsEntry 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandStatus ::= { rlCLIremoteCLIcommandsEntry 4 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIactivationStatus ::= { rlCLIremoteCLIcommandsEntry 5 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyStatusIndex ::= { rlEnvMonSupplyStatusEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyStatusDescr ::= { rlEnvMonSupplyStatusEntry 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyState ::= { rlEnvMonSupplyStatusEntry 3 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplySource ::= { rlEnvMonSupplyStatusEntry 4 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonSupplyFanDirection ::= { rlEnvMonSupplyStatusEntry 5 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataTable ::= { rlEnvFanData 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommand ::= { rlCLIremoteCLIsupport 1 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIexecutionState ::= { rlCLIremoteCLIsupport 2 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIexecutionCommandIndex ::= { rlCLIremoteCLIsupport 3 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLImode ::= { rlCLIremoteCLIsupport 4 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIcommandsTable ::= { rlCLIremoteCLIsupport 5 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIoutputsTable ::= { rlCLIremoteCLIsupport 6 }
Cannot adopt OID in CISCOSB-CLI-MIB: rlCLIremoteCLIinstance ::= { rlCLIremoteCLIsupport 7 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanStatusIndex ::= { rlEnvMonFanStatusEntry 1 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanStatusDescr ::= { rlEnvMonFanStatusEntry 2 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvMonFanState ::= { rlEnvMonFanStatusEntry 3 }
Cannot adopt OID in CISCOSB-HWENVIROMENT: rlEnvFanDataEntry ::= { rlEnvFanDataTable 1 }
Filesize: 42.9M
Reading progress: 99% position: 42.6M line: 80000 sql chunk: 2 mem usage: 56M

Completed! 81949 lines 30 sql chunks

Notes:
- No its not perfect
- Yes it discards ALL stored procedures
- Yes it discards ALL queries except for CREATE TABLE and INSERT INTO
- Yes you can email us suggestsions: info[AT]lightbox.org
- In emails, please include the Postgres code, and the expected MySQL code
- If you're having problems creating your postgres dump, make sure you use "--format p --inserts"
- Default output engine if not specified is InnoDB

==============================================================================

root@byfnagxi01:/opt/install/nagios/pg2mysql-master# service mysql restart
root@byfnagxi01:/opt/install/nagios/pg2mysql-master# mysql -uroot -pnagiosxi nagiosxi --max_allowed_packet=512M --force < nagiosxi.mysql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1146 (42S02) at line 8: Table 'nagiosxi.public.xi_auditlog' doesn't exist
ERROR 1146 (42S02) at line 1009: Table 'nagiosxi.public.xi_auditlog' doesn't exist
ERROR 1146 (42S02) at line 2010: Table 'nagiosxi.public.xi_auditlog' doesn't exist
ERROR 1146 (42S02) at line 3011: Table 'nagiosxi.public.xi_auditlog' doesn't exist
ERROR 1146 (42S02) at line 4012: Table 'nagiosxi.public.xi_auditlog' doesn't exist
ERROR 1146 (42S02) at line 5013: Table 'nagiosxi.public.xi_auditlog' doesn't exist
ERROR 1146 (42S02) at line 6014: Table 'nagiosxi.public.xi_auditlog' doesn't exist
ERROR 1146 (42S02) at line 7015: Table 'nagiosxi.public.xi_auditlog' doesn't exist
ERROR 1146 (42S02) at line 7891: Table 'nagiosxi.public.xi_auth_tokens' doesn't exist
ERROR 1146 (42S02) at line 8289: Table 'nagiosxi.public.xi_cmp_scheduledreports_log' doesn't exist
ERROR 1146 (42S02) at line 9078: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 10079: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 11080: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 12081: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 13082: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 14083: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 15084: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 16085: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 17086: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 18087: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 19088: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 20089: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 21090: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 22091: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 23092: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 24093: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 25094: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 26095: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 27096: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 28097: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 29098: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 30099: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 31100: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 32101: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 33102: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 34103: Table 'nagiosxi.public.xi_cmp_trapdata_log' doesn't exist
ERROR 1146 (42S02) at line 34363: Table 'nagiosxi.public.xi_commands' doesn't exist
ERROR 1146 (42S02) at line 34420: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 35421: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 36422: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 37423: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 38424: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 39425: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 40426: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 41427: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 42428: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 43429: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 44430: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 45431: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 46432: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 47433: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 48434: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 49435: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 50436: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 51437: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 52438: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 53439: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 54440: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 55441: Table 'nagiosxi.public.xi_events' doesn't exist
ERROR 1146 (42S02) at line 55444: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 56445: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 57446: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 58447: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 59448: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 60449: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 61450: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 62451: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 63452: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 64453: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 65454: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 66455: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 67456: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 68457: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 69458: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 70459: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 71460: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 72461: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 73462: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 74463: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 75464: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 76465: Table 'nagiosxi.public.xi_meta' doesn't exist
ERROR 1146 (42S02) at line 77405: Table 'nagiosxi.public.xi_mibs' doesn't exist
ERROR 1146 (42S02) at line 77494: Table 'nagiosxi.public.xi_options' doesn't exist
ERROR 1146 (42S02) at line 77724: Table 'nagiosxi.public.xi_sessions' doesn't exist
ERROR 1146 (42S02) at line 77850: Table 'nagiosxi.public.xi_sysstat' doesn't exist
ERROR 1146 (42S02) at line 77881: Table 'nagiosxi.public.xi_usermeta' doesn't exist
ERROR 1146 (42S02) at line 78882: Table 'nagiosxi.public.xi_usermeta' doesn't exist
ERROR 1146 (42S02) at line 79883: Table 'nagiosxi.public.xi_usermeta' doesn't exist
ERROR 1146 (42S02) at line 80884: Table 'nagiosxi.public.xi_usermeta' doesn't exist
ERROR 1146 (42S02) at line 81599: Table 'nagiosxi.public.xi_users' doesn't exist
root@byfnagxi01:/opt/install/nagios/pg2mysql-master#

Hi @elliott.fougman.olm,

This issue is going to take some digging into your specific environment. I recommend opening a case on Answer Hub so that our Support team can work with you directly.
-Sebastian