I am trying to migrate my NNA 2024R2.1 environment to 2026R1.0.1 following https://assets.nagios.com/downloads/nag ... o-2026.pdf. My source environment is Debian 12 and my target environment is Debian 13. I have installed a fresh NNA 2026 on the Debian 13 environment and configured email as instructed.
I generated a backup and sql dump on the source environment as instructed and transferred it to the target environment. When I run the migration it fails to import the SQL db stating there is a credential issue. I have tested the credentials of the root user and the nagiosna user and am able to connect. I also checked the reference file /var/www/html/nagiosna/.env and the credentials and username are properly detailed here.
Is there another place I need to look or modify for the script to specify the credentials? Find below console output of a restore attempt:
root@NAGIOSNETWORKANALYZER:/usr/local/nagiosna/scripts# ./migrate_na.sh /store/backups/nagiosna/1771962587.tar.gz \/store/backups/nagiosna/nagiosna.sql
TS=1772042243
Extracting backup to /store/backups/nagiosna/1772042243-restore...
In /store/backups/nagiosna/1772042243-restore/1771962587...
Backup files look okay. Preparing to restore...
Shutting down services...
Restoring flow files to /usr/local/nagiosna/var/...
Restoring MySQL databases...
Using SQL dump file: /store/backups/nagiosna/nagiosna.sql
Processing SQL dump file for migration...
Renaming table: nagiosna_Checks -> checks
Removing table: nagiosna_ChecksCmdLinker
Removing table: nagiosna_ChecksHSALinker
Removing table: nagiosna_ChecksTrapsLinker
Removing table: nagiosna_ChecksUsersLinker
Renaming table: nagiosna_Commands -> commands
Renaming table: nagiosna_HostServiceAssociations -> service_hostnames
Renaming table: nagiosna_NagiosServers -> nagios_servers
Removing table: nagiosna_Queries
Removing table: nagiosna_Reports
Renaming table: nagiosna_SGLinker -> source_group_linker
Renaming table: nagiosna_SourceGroups -> source_groups
Renaming table: nagiosna_Sources -> sources
Removing table: nagiosna_SourcesViewsLinker
Renaming table: nagiosna_TrapReceivers -> snmp_receivers
Renaming table: nagiosna_Views -> views
Renaming table: nagiosna_auth_servers -> auth_servers
Renaming table: nagiosna_cf_options -> config_options
Removing table: nagiosna_cmdsubsys
Removing table: nagiosna_groups
Removing table: nagiosna_hostname_cache
Removing table: nagiosna_login_attempts
Removing table: nagiosna_migrations
Removing table: nagiosna_path_nodes
Removing table: nagiosna_path_status
Removing table: nagiosna_sessions
Removing table: nagiosna_usermeta
Renaming table: nagiosna_users -> users
Removing table: nagiosna_users_groups
Filtering complete. Output written to: /store/backups/nagiosna/1772042243-restore/nagiosna_filtered.sql
Truncating selected tables in nagiosna before import...
Importing filtered database...
ERROR 1054 (42S22) at line 121: Unknown column 'disable_abnormal' in 'field list'
Error restoring MySQL database 'nagiosna' - check database credentials!
Filtered SQL dump is available at: /store/backups/nagiosna/1772042243-restore/nagiosna_filtered.sql