Custom Variables Missing From Extraction In Insights 22.4

Resolution when custom variable go missing while trying to add custom variables.

After reviewing portal logs, it is observed that queries to port 2999 fail.

  • Validate on OS that port 29999 is open by viewing netstat or iptables -L
  • If port 29999 is open, validate if IPv6 is disabled. If it is disabled, do the following,
  1. Login to the looker machine
  2. Run: sudo docker exec -it looker-container bash (this allows us to execute bash commands in the looker-container)
  3. Run: vi nginx.conf (vi editor so we can edit nginx.conf)
  4. Type the following: :36 Hit enter. (This will take you to line 36.)
  5. Type: i # - this comments out the ipv6 line in the nginx config
  6. Hit the escape key and then type: :wq! - this writes and quits the vi editor
  7. Type: exit
  8. Run: sudo docker restart looker-container (this restarts the looker container)
  9. Run: sudo docker exec -it looker-container curl -vk https://127.0.0.1:2999 (this is to validate that communications over port 29999 are working).