Access Looker UI of Insights for On Prem
Issue Description: Insights 21.10+ uses looker as its backend. There are times where it is necessary to access this backend to help diagnose issues. Depending on the version and the deployment type being used, the instructions vary.
Resolution: The two different deployment types are MSI and AutomationSuite .
Accessing the backend 21.10 MSI
- Login to the Insights server. (It is best to login as the account that installed Insights)
- Open powershell as an admin
- Run the following command: Unprotect-CmsMessage -Path "$HOME\_insights\LookerSecret"
- This will fetch the login password for the backend
- If the path is not found, then it could be that the user who is running the command did not install Insights.
- If the path is not found, use the following command to find where the location of the LookerSecret is located (ran from powershell): docker inspect -f '{{ (index .Mounts 0).Source }}' looker-container
- Replace the '$HOME\_insights' with the path returned by the command
- i.e. If the returned value were: c:\users\admin_1\_insights
- Then the password fetch command would become: Unprotect-CmsMessage -Path "c:\users\admin_1\_insights\LookerSecret"
- The above command will return two values, we want the UiPathInsightsLookerAdmin value. Copy the password that is returned (it will always start with 1qW@)
- Copy the password in your password manager or password storing solution.
- Go to the following URL: https://:9999/login replacing with the Insights URL
- This will take us to the login page. The user name is: admin@uipath.com and the password is the password returned from the powershell command.
- It is recommended that the backend password gets saved somewhere for quick access in the future.
Accessing the backend 22.4+
- Before going through these steps, make sure that we know what the pass phrase is for the GPG key (this was generated during installation and should have been recorded)
- Login to the Looker backend Linux machine
- Either make sure to login as the person who did the install, or switch to the user who did the install
- Switching users can be done with the command: su
- Or if the password is not known, use sudo su
- If unsure of which user installed insights, use the following command to find the user: sudo docker inspect -f '{{ (index .Mounts 0).Source }}' looker-container
- For example if the command returned: /home/admin_1/insights, the user who installed insights would be admin_1. So we would switch to that user with sudo su admin_1
- Run the following command to get the password: pass ls "Insights/looker-password" | sed 's/^/1qW@/'
- When running the command, we will be prompted for the GPG pass phrase defined at installation time.
- The sed command adds the string 1qW@, which we add during install time to satisfy password requirements.
- Copy the password in your password manager or password storing solution.
- Go to the following URL in a browser: https://:9999/login, replacing with the FQDN of the Linux instance (or whatever DNS name that was used for the Linux engine). If the Llinux DNS name is not known, do the following:
- On the Linux machine run: hostname -f. Try the returned value. This may not work if a load balancer is used or if using a custom domain.
- If it does not work, then login to the Insights Windows Server and open the file: "C:\Program Files (x86)\UiPath Insights\Insights\appsettings.json". In the file search for the string: "embed_url". The defined value is the looker URL.
- For example, in our test environment search for embed_url goes to a line saying: "embed_url": "https://looker.local:9999". The url would be looker.local.
- Once on the login screen for looker, use the recorded password and the username admin@uipath.com.
Accessing the Backend AutomationSuite
- Login to one of the Server nodes of Automation Suite
- Read more Enabling Kubectl
- Run the following command: kubectl -n uipath get secrets insights-generated-secrets -o "jsonpath={.data['LookerPassword']}" | echo $(base64 -d) | sed 's/^/1qW@/'
- The returned value is the password
- Go to the URL: https://insights./login , where is the base URL for automation suite. (i.e. https://insights.automationsuite.uipath.com/login).