Identifying NSX Controllers IP to ID map from NSX Manager logs

Products

• VMware NSX

Issue/Introduction

Symptoms:

While analysing the NSX Manager logs, it might be useful to identify which NSX Controller ID corresponds to which IP. This KB describes NSX Controllers' IP to ID mapping. 

 

Environment

VMware NSX for vSphere 6.4.x
VMware NSX for vSphere 6.2.x
VMware NSX for vSphere 6.3.x

Resolution

Looking at the NSX database, the table vnvp_controller_connectivity_info contains a mapping of the controller IDs and the IPs of the other Controllers.

SQL query: SELECT * FROM vnvp_controller_connectivity_info ORDER BY src_controller_id;

The NSX Manager logs contain the file ./status/database/vxlan.txt which include a dump of this table.

For each Controller, there is a line with the IP address of the other two Controllers.

The IP address of the Controller is the one there is no line with its ID.

 

Example:

secureall=# SELECT * FROM vnvp_controller_connectivity_info ORDER BY src_controller_id;
src_controller_id | dest_ip_address | is_dest_active |  ping_status | disconnected_at
-------------------+-----------------+----------------+-------------+-----------------
controller-2      | #.#.#.31  | t              | SUCCESS     | 
controller-2      | #.#.#.33  | t              | SUCCESS     | 
controller-3      | #.#.#.31  | t              | SUCCESS     | 
controller-3      | #.#.#.32  | t              | SUCCESS     | 
controller-4      | #.#.#.33  | t              | SUCCESS     | 
controller-4      | #.#.#.32  | t              | SUCCESS     |
(6 rows) 

• controller-2 = #.#.#.32
• controller-3 = #.#.#.33
• controller-4 = #.#.#.31