4. Dashboard Reconfiguration (Portal Commander)
Print
Modified on: Mon, Apr 4, 2022 at 5:11 PM
Assumption: Dashboard Service is running successfully for Access Commander already
The following steps are to be performed on the App Server
- Launch services.msc.
- Stop ACv4-AccessCommander service and ACv4-Dashboard service
- Navigate to AccessCommander\Configuration\Dashboard directory
- Edit run.bat using NotePad++
- Change MB_HOME directory from AccessCommander\Data\Dashboard\AccessCommander to AccessCommander\Data\Dashboard\Enterprise.
- Save the run.bat file.
- Start ACv4-Dashboard service
The following steps are to be performed from a local browser and not from within a server
- Navigate to the Dashboard URL set during Phase 2
- Login to the Dashboard Portal
If you (the customer) requests for credentials, you will need to sign a Waiver of receiving no further support from MathCraft related to the Dashboard - Go to Admin by clicking on Settings on the top right
- Navigate to General from the left navigation panel
- Ensure the Site URL is set to http://localhost:5020
- Ensure the Anonymous Tracking is set to Disabled
- Ensure the Friendly Table and Field Names is set to Disabled
- Ensure the Enable Nested Queries is set to Enabled
- Navigate to Updates from the left navigation panel
- Ensure the Check for Updates is set to Disabled
- Navigate to Public Sharing from the left navigation panel
- Ensure the Enable Public Sharing is set to Disabled
- Navigate to Embedding in Other Applications from the left navigation panel
- Click the Regenerate Key button
- Copy the Secret Key into a Notepad window as we will need this later
- Navigate to Caching from the left navigation panel
- Ensure the Enable Caching is set to Disabled
- Navigate to Databases from the top navigation panel
- Click on Access Commander under Name to modify the settings
- Ensure the Database Type is set to SQL Server
- Ensure the Name is set to Access Commander
- Enter the Host Name to match your SQL Server Name where Access Commander database is deployed
- Enter the Port Number to match your SQL Server Port Number where Access Commander database is deployed
- Ensure the Database is set to ACCMDRWEB
- Ensure the Database Instance is empty
- Ensure the Username is set to ac_mb_user
- Reenter the Password
- Ensure the "Use a Secure Connection (SSL)" is set to Disabled
- Ensure the "Use an SSH-Tunnel for Database Connections" is set to Disabled
- Ensure the "Automatically Run Queries when doing simple Filtering and Summarizing" is set to Enabled
- Ensure the "This is a large Database, so let me choose when Metabase Syncs and Scans" is set to Enabled
- Click on Save Changes
- Click on Sync Database Schema Now
- Wait for 10 minutes and then click Re-Scan Field Values Now
- Navigate to Databases from the top navigation panel
- Click on Portal Commander under Name to modify the settings
- Ensure the Database Type is set to SQL Server
- Ensure the Name is set to Portal Commander
- Enter the Host Name to match your SQL Server Name where Portal Commander database is deployed
- Enter the Port Number to match your SQL Server Port Number where Portal Commander database is deployed
- Ensure the Database is set to PORTALCMDR
- Ensure the Database Instance is empty
- Ensure the Username is set to pc_mb_user
- Reenter the Password
- Ensure the "Use a Secure Connection (SSL)" is set to Disabled
- Ensure the "Use an SSH-Tunnel for Database Connections" is set to Disabled
- Ensure the "Automatically Run Queries when doing simple Filtering and Summarizing" is set to Enabled
- Ensure the "This is a large Database, so let me choose when Metabase Syncs and Scans" is set to Enabled
- Click on Save Changes
- Click on Sync Database Schema Now
- Wait for 10 minutes and then click Re-Scan Field Values Now
- On the App Environment Operating System, navigate to the AccessCommander\Configuration\AccessCommander directory from the Application Root
- Launch the application.properties in edit mode using Notepad or Notepad++ (Notepad++ recommended)
- Modify the metabase.secretKey copied in step 15 above
- Save the application.properties file
- Launch the application.properties in edit mode using Notepad or Notepad++ (Notepad++ recommended)
- Modify the metabase.secretKey copied in step 15 above
- Save the application.properties file
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.