Error on DB import when switching portal to DR server
Article ID: 452109
Updated On:
Products
Issue/Introduction
When trying to import the mysql backups from the primary DR portal to the failover DR portal, getting an error:
failed: [HOSTNAME] (item=netqosportal) => {"ansible_loop_var": "item", "changed": true, "cmd": "/opt/NetOps/MySql/bin/mysql -u root -pxxxx netqosportal < /tmp/netops_dr_backup/netqosportal_2026-07-07.sql",
"delta": "0:00:17.050561", "end": "2026-07-07 16:32:32.103563", "item": "netqosportal", "msg": "non-zero return code", "rc": 1, "start": "2026-07-07 16:32:15.053002", "stderr": "mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1356 (HY000) at line 8587: View 'netqosportal.v_current_telemetry_inventory' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them", "stderr_lines":
Environment
- DX NetOps :: 25.4.2 +
- Disaster recovery setup
- Portal mysql is on a standalone host
Cause
Because the mysql database in installed on a stand-alone system,
By default, access to the mysql database is restricted to localhost only.
Resolution
1. During the install of mysql, you must specify the remote hosts that will access this database.
This includes the host where the portal services are installed AND the host that the DR primary database is installed.
(25.4.2 and higher) The Remote Client Access line appears, for example:
Remote Client Access
By default, access to the mysql database is restricted to localhost only.
For a distributed installation, a user must be created for the servers that
host the DX NetOps Portal services.
Enter the IP addresses or fully-qualified domain names of servers that require
access to the database.
Example: portal.mydomain.com,topology.mydomain.com,###.###.###.###
Remote client hosts :
(25.4.2 and higher) At the Remote client hosts : prompt, enter the IP addresses or the fully-qualified domain names of the servers that require access to the NetOps Portal MySQL database, and then press the Enter/Return key on your keyboard.
2. If you have already installed, you may use the provided script:: /opt/CA/PerformanceCenter/Tools/bin/add_mysql_client_host.sh
After a NetOps Portal installation, you can add additional remote client hosts for the NetOps Portal MySQL database using the add_mysql_client_host.sh script.
For more information about this script, see NetOps Portal Scripts.
Example: portal.mydomain.com,topology.mydomain.com,###.###.###.###
Additional Information
Feedback
