Table of contents Update Passwords in your Aternity on-premise Deployment You may want to change the passwords on the servers in your Aternity installation, for security reasons and to comply with corporate policy. You can change passwords on all or some of the servers at the same time. The process for changing passwords on all of the servers may take several hours, during which time Aternity servers and dashboards will not be available, and Aternity will not collect data from monitored devices. Aternity on-premise topology Before you begin Ensure that you have administrator credentials for the Aternity Aggregation Server, Management Server, Data Warehouse Server, Dashboard Server, and Vertica Database Server. Your DBA should be available to make changes to the Oracle Database Server. Note You will have to reinstall the Dashboard Gateway, ETL Server, Aternity Data Source for Portal, and Aternity REST API Server as part of this procedure. If you are deploying Aternity in an air-gapped network, download the files and packages you need to install these components, before beginning the setup procedures. Learn more. ProcedureStep 1 Sign in to the Aternity Aggregation Server, Management Server, Data Warehouse Server, and Dashboard Server as an administrator. Important If you have more than one of any of these servers, you must sign in and change the password on each host computer. Step 2 Stop the AternityPlatform service on these servers, in this order: Management Server Aggregation Server Data Warehouse Server To stop the services, you must sign in to each computer as an administrator, and access the Windows Services screen. Step 3 On the main Dashboard Server, stop the Tableau service by opening a command prompt as administrator and entering tabadmin stop. Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin stop Stop the server on the main Dashboard Server Step 4 On the Dashboard Server, stop the Aternity Tableau Gateway service. Step 5 On the ETL Server, stop the cron service, which is used by the OS to schedule commands or scripts. Sign in to the ETL Server as a root user or sudo root user and run the command: systemctl stop crond Step 6 On the computer that hosts the Aternity Data Source for Portal and Aternity REST API Server, stop the services for the Aternity Data Source for Portal and Aternity REST API Server. Run these commands: docker stop AOData docker stop AternityDataSource Stop the AOData and AternityDataSource services You can verify the service names by running docker ps. Step 7 (DBA task) Sign in to the Oracle Database Server and change the ATERNITY and GR schema passwords by running alter user <name> identified by <new_password>. Change the schema passwords Important The ATERNITY schema password on the Oracle Database Server and the Vertica Database Server must be identical, so if you change one, you must change the other to match. Step 8 On the Vertica Database Server, change the database admin password. a Sign in to the Vertica Database Server host computer, and switch to the database admin user, such as dbadmin, using su <user name>. b Run the Vertica administration tool by entering admintools. Vertica's database administrator tools c Select Connect to Database. d Change the database administrator's password by running alter user <name> identified by <new_password>. Change the administrator's password Step 9 Configure Aternity to recognize the revised database credentials. a On the Management Server, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. Open the Configuration Tool b In Database Configuration > Database Connection > Configure Database Credentials, change the password to the revised Oracle Database Server and Vertica Database Server password. Provide the new credentials for the Vertica Database Server Step 10 Reinstall the ETL Server using the new Vertica Database Server password (learn more). Step 11 On the Dashboard Server, start the Tableau service by opening a command prompt as administrator and entering tabadmin start. Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin start Start the Dashboard Server Step 12 In Windows services, start the Aternity Tableau Gateway service. Step 13 Update the Tableau administrator password. Open a browser, navigate to the Tableau console login page at http(s)://<server ip address>, and sign in as a Tableau user with administrator privileges. Select the Users tab > <server administrator> > Settings > Change Password. Change the password for all administrators, but not for any other users. Change each administrator's password Step 14 Sign in to the Dashboard Server, start the Tableau service and the Aternity Tableau Gateway service, and password. Step 15 Reinstall the Dashboard Gateway and provide the new Tableau server admin user password. Provide the new Tableau admin password to the Dashboard Gateway You can also change the Dashboard Gateway user password (learn more). Step 16 Access the Aternity Management Server computer. Step 17 Log in to the computer as a local administrator. To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active. Step 18 On that computer, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. When you create any Aternity server it adds the Configuration Tool. Step 19 Select Tableau Dashboard Loader. Select to add dashboard layouts Step 20 Confirm the details to connect to the Dashboard Gateway on the Aternity Dashboard Server. Confirm the connection details to the Dashboard Gateway on the Dashboard Server Field Description Hostname / IP Address Enter the hostname or IP address of the Dashboard Gateway (which is the same as the Aternity Dashboard Server). Port Enter the port of the Dashboard Gateway, which you entered when creating the Dashboard Gateway. This is NOT the port for direct user access to the dashboards. This is the Dashboard Gateway port. Username / Password Enter the username and password of the Dashboard Gateway, which you entered when creating the Dashboard Gateway. Select Next to test the connection details to the Dashboard Gateway, which may take longer than expected. Step 21 Select Use an Existing Site and select the site name you used in your existing setup. Use the Tableau site as the target to save the dashboard layouts Step 22 Specify the dashboard layouts either built-in to the setup, or if you downloaded a file of dashboard updates, browse to the file. Add the layouts built-in to the setup or a separate patch update Field Description Dashboards Shipped with Setup Select to add the dashboard layouts which are built-in to this Configuration Tool, if you did not download a separate dashboard layout package. Custom Dashboard Content Select to browse to a separate downloaded dashboards package. Step 23 Start the AternityPlatform service on these servers, in this order: Management Server Data Warehouse Server Aggregation Server Start the service in the Windows Services screen. Important If you have more than one of any of these servers, you must start the service on each one. Step 24 Reinstall the Aternity Data Source for Portal and Aternity REST API Servers, so that you can provide the new database passwords. Learn more about reinstalling the Aternity Data Source for Portal. Learn more about reinstalling the Aternity REST API Server. Step 25 Open a browser and sign in to Aternity. Sign in as the administrator for the next steps. Step 26 Open a browser and sign in to Aternity. Step 27 (Optional) If your custom attributes use a connection to the Aternity Oracle Database Server, enter the updated password inside Aternity's settings. If you defined custom attributes using a query in the database, select the Gear Icon > Settings > Advanced Settings > Aternity > Dataserver > Handlers > StaticsMessageHandler > DerivedAttrGeneratorManager > generatorsData, and enter the new password in the xml file. Change the database password if your attribute mapping is database dependent Step 28 Select User Icon > Change Password. Parent topic Secure your Aternity Deployment and Ensure Privacy SavePDF Selected topic Selected topic and subtopics All content Related Links
Update Passwords in your Aternity on-premise Deployment You may want to change the passwords on the servers in your Aternity installation, for security reasons and to comply with corporate policy. You can change passwords on all or some of the servers at the same time. The process for changing passwords on all of the servers may take several hours, during which time Aternity servers and dashboards will not be available, and Aternity will not collect data from monitored devices. Aternity on-premise topology Before you begin Ensure that you have administrator credentials for the Aternity Aggregation Server, Management Server, Data Warehouse Server, Dashboard Server, and Vertica Database Server. Your DBA should be available to make changes to the Oracle Database Server. Note You will have to reinstall the Dashboard Gateway, ETL Server, Aternity Data Source for Portal, and Aternity REST API Server as part of this procedure. If you are deploying Aternity in an air-gapped network, download the files and packages you need to install these components, before beginning the setup procedures. Learn more. ProcedureStep 1 Sign in to the Aternity Aggregation Server, Management Server, Data Warehouse Server, and Dashboard Server as an administrator. Important If you have more than one of any of these servers, you must sign in and change the password on each host computer. Step 2 Stop the AternityPlatform service on these servers, in this order: Management Server Aggregation Server Data Warehouse Server To stop the services, you must sign in to each computer as an administrator, and access the Windows Services screen. Step 3 On the main Dashboard Server, stop the Tableau service by opening a command prompt as administrator and entering tabadmin stop. Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin stop Stop the server on the main Dashboard Server Step 4 On the Dashboard Server, stop the Aternity Tableau Gateway service. Step 5 On the ETL Server, stop the cron service, which is used by the OS to schedule commands or scripts. Sign in to the ETL Server as a root user or sudo root user and run the command: systemctl stop crond Step 6 On the computer that hosts the Aternity Data Source for Portal and Aternity REST API Server, stop the services for the Aternity Data Source for Portal and Aternity REST API Server. Run these commands: docker stop AOData docker stop AternityDataSource Stop the AOData and AternityDataSource services You can verify the service names by running docker ps. Step 7 (DBA task) Sign in to the Oracle Database Server and change the ATERNITY and GR schema passwords by running alter user <name> identified by <new_password>. Change the schema passwords Important The ATERNITY schema password on the Oracle Database Server and the Vertica Database Server must be identical, so if you change one, you must change the other to match. Step 8 On the Vertica Database Server, change the database admin password. a Sign in to the Vertica Database Server host computer, and switch to the database admin user, such as dbadmin, using su <user name>. b Run the Vertica administration tool by entering admintools. Vertica's database administrator tools c Select Connect to Database. d Change the database administrator's password by running alter user <name> identified by <new_password>. Change the administrator's password Step 9 Configure Aternity to recognize the revised database credentials. a On the Management Server, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. Open the Configuration Tool b In Database Configuration > Database Connection > Configure Database Credentials, change the password to the revised Oracle Database Server and Vertica Database Server password. Provide the new credentials for the Vertica Database Server Step 10 Reinstall the ETL Server using the new Vertica Database Server password (learn more). Step 11 On the Dashboard Server, start the Tableau service by opening a command prompt as administrator and entering tabadmin start. Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin start Start the Dashboard Server Step 12 In Windows services, start the Aternity Tableau Gateway service. Step 13 Update the Tableau administrator password. Open a browser, navigate to the Tableau console login page at http(s)://<server ip address>, and sign in as a Tableau user with administrator privileges. Select the Users tab > <server administrator> > Settings > Change Password. Change the password for all administrators, but not for any other users. Change each administrator's password Step 14 Sign in to the Dashboard Server, start the Tableau service and the Aternity Tableau Gateway service, and password. Step 15 Reinstall the Dashboard Gateway and provide the new Tableau server admin user password. Provide the new Tableau admin password to the Dashboard Gateway You can also change the Dashboard Gateway user password (learn more). Step 16 Access the Aternity Management Server computer. Step 17 Log in to the computer as a local administrator. To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active. Step 18 On that computer, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. When you create any Aternity server it adds the Configuration Tool. Step 19 Select Tableau Dashboard Loader. Select to add dashboard layouts Step 20 Confirm the details to connect to the Dashboard Gateway on the Aternity Dashboard Server. Confirm the connection details to the Dashboard Gateway on the Dashboard Server Field Description Hostname / IP Address Enter the hostname or IP address of the Dashboard Gateway (which is the same as the Aternity Dashboard Server). Port Enter the port of the Dashboard Gateway, which you entered when creating the Dashboard Gateway. This is NOT the port for direct user access to the dashboards. This is the Dashboard Gateway port. Username / Password Enter the username and password of the Dashboard Gateway, which you entered when creating the Dashboard Gateway. Select Next to test the connection details to the Dashboard Gateway, which may take longer than expected. Step 21 Select Use an Existing Site and select the site name you used in your existing setup. Use the Tableau site as the target to save the dashboard layouts Step 22 Specify the dashboard layouts either built-in to the setup, or if you downloaded a file of dashboard updates, browse to the file. Add the layouts built-in to the setup or a separate patch update Field Description Dashboards Shipped with Setup Select to add the dashboard layouts which are built-in to this Configuration Tool, if you did not download a separate dashboard layout package. Custom Dashboard Content Select to browse to a separate downloaded dashboards package. Step 23 Start the AternityPlatform service on these servers, in this order: Management Server Data Warehouse Server Aggregation Server Start the service in the Windows Services screen. Important If you have more than one of any of these servers, you must start the service on each one. Step 24 Reinstall the Aternity Data Source for Portal and Aternity REST API Servers, so that you can provide the new database passwords. Learn more about reinstalling the Aternity Data Source for Portal. Learn more about reinstalling the Aternity REST API Server. Step 25 Open a browser and sign in to Aternity. Sign in as the administrator for the next steps. Step 26 Open a browser and sign in to Aternity. Step 27 (Optional) If your custom attributes use a connection to the Aternity Oracle Database Server, enter the updated password inside Aternity's settings. If you defined custom attributes using a query in the database, select the Gear Icon > Settings > Advanced Settings > Aternity > Dataserver > Handlers > StaticsMessageHandler > DerivedAttrGeneratorManager > generatorsData, and enter the new password in the xml file. Change the database password if your attribute mapping is database dependent Step 28 Select User Icon > Change Password. Parent topic Secure your Aternity Deployment and Ensure Privacy
Update Passwords in your Aternity on-premise Deployment You may want to change the passwords on the servers in your Aternity installation, for security reasons and to comply with corporate policy. You can change passwords on all or some of the servers at the same time. The process for changing passwords on all of the servers may take several hours, during which time Aternity servers and dashboards will not be available, and Aternity will not collect data from monitored devices. Aternity on-premise topology Before you begin Ensure that you have administrator credentials for the Aternity Aggregation Server, Management Server, Data Warehouse Server, Dashboard Server, and Vertica Database Server. Your DBA should be available to make changes to the Oracle Database Server. Note You will have to reinstall the Dashboard Gateway, ETL Server, Aternity Data Source for Portal, and Aternity REST API Server as part of this procedure. If you are deploying Aternity in an air-gapped network, download the files and packages you need to install these components, before beginning the setup procedures. Learn more. ProcedureStep 1 Sign in to the Aternity Aggregation Server, Management Server, Data Warehouse Server, and Dashboard Server as an administrator. Important If you have more than one of any of these servers, you must sign in and change the password on each host computer. Step 2 Stop the AternityPlatform service on these servers, in this order: Management Server Aggregation Server Data Warehouse Server To stop the services, you must sign in to each computer as an administrator, and access the Windows Services screen. Step 3 On the main Dashboard Server, stop the Tableau service by opening a command prompt as administrator and entering tabadmin stop. Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin stop Stop the server on the main Dashboard Server Step 4 On the Dashboard Server, stop the Aternity Tableau Gateway service. Step 5 On the ETL Server, stop the cron service, which is used by the OS to schedule commands or scripts. Sign in to the ETL Server as a root user or sudo root user and run the command: systemctl stop crond Step 6 On the computer that hosts the Aternity Data Source for Portal and Aternity REST API Server, stop the services for the Aternity Data Source for Portal and Aternity REST API Server. Run these commands: docker stop AOData docker stop AternityDataSource Stop the AOData and AternityDataSource services You can verify the service names by running docker ps. Step 7 (DBA task) Sign in to the Oracle Database Server and change the ATERNITY and GR schema passwords by running alter user <name> identified by <new_password>. Change the schema passwords Important The ATERNITY schema password on the Oracle Database Server and the Vertica Database Server must be identical, so if you change one, you must change the other to match. Step 8 On the Vertica Database Server, change the database admin password. a Sign in to the Vertica Database Server host computer, and switch to the database admin user, such as dbadmin, using su <user name>. b Run the Vertica administration tool by entering admintools. Vertica's database administrator tools c Select Connect to Database. d Change the database administrator's password by running alter user <name> identified by <new_password>. Change the administrator's password Step 9 Configure Aternity to recognize the revised database credentials. a On the Management Server, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. Open the Configuration Tool b In Database Configuration > Database Connection > Configure Database Credentials, change the password to the revised Oracle Database Server and Vertica Database Server password. Provide the new credentials for the Vertica Database Server Step 10 Reinstall the ETL Server using the new Vertica Database Server password (learn more). Step 11 On the Dashboard Server, start the Tableau service by opening a command prompt as administrator and entering tabadmin start. Navigate to <setup_dir>\Tableau\Tableau Server\<version>\bin then enter tabadmin start Start the Dashboard Server Step 12 In Windows services, start the Aternity Tableau Gateway service. Step 13 Update the Tableau administrator password. Open a browser, navigate to the Tableau console login page at http(s)://<server ip address>, and sign in as a Tableau user with administrator privileges. Select the Users tab > <server administrator> > Settings > Change Password. Change the password for all administrators, but not for any other users. Change each administrator's password Step 14 Sign in to the Dashboard Server, start the Tableau service and the Aternity Tableau Gateway service, and password. Step 15 Reinstall the Dashboard Gateway and provide the new Tableau server admin user password. Provide the new Tableau admin password to the Dashboard Gateway You can also change the Dashboard Gateway user password (learn more). Step 16 Access the Aternity Management Server computer. Step 17 Log in to the computer as a local administrator. To verify you are a local administrator on this computer, not a domain administrator, open the System control panel, select Advanced system settings > Computer Name, and confirm the Change button is active. Step 18 On that computer, launch the Configuration Tool from the Start menu, by right-clicking it and selecting Run as administrator to start. When you create any Aternity server it adds the Configuration Tool. Step 19 Select Tableau Dashboard Loader. Select to add dashboard layouts Step 20 Confirm the details to connect to the Dashboard Gateway on the Aternity Dashboard Server. Confirm the connection details to the Dashboard Gateway on the Dashboard Server Field Description Hostname / IP Address Enter the hostname or IP address of the Dashboard Gateway (which is the same as the Aternity Dashboard Server). Port Enter the port of the Dashboard Gateway, which you entered when creating the Dashboard Gateway. This is NOT the port for direct user access to the dashboards. This is the Dashboard Gateway port. Username / Password Enter the username and password of the Dashboard Gateway, which you entered when creating the Dashboard Gateway. Select Next to test the connection details to the Dashboard Gateway, which may take longer than expected. Step 21 Select Use an Existing Site and select the site name you used in your existing setup. Use the Tableau site as the target to save the dashboard layouts Step 22 Specify the dashboard layouts either built-in to the setup, or if you downloaded a file of dashboard updates, browse to the file. Add the layouts built-in to the setup or a separate patch update Field Description Dashboards Shipped with Setup Select to add the dashboard layouts which are built-in to this Configuration Tool, if you did not download a separate dashboard layout package. Custom Dashboard Content Select to browse to a separate downloaded dashboards package. Step 23 Start the AternityPlatform service on these servers, in this order: Management Server Data Warehouse Server Aggregation Server Start the service in the Windows Services screen. Important If you have more than one of any of these servers, you must start the service on each one. Step 24 Reinstall the Aternity Data Source for Portal and Aternity REST API Servers, so that you can provide the new database passwords. Learn more about reinstalling the Aternity Data Source for Portal. Learn more about reinstalling the Aternity REST API Server. Step 25 Open a browser and sign in to Aternity. Sign in as the administrator for the next steps. Step 26 Open a browser and sign in to Aternity. Step 27 (Optional) If your custom attributes use a connection to the Aternity Oracle Database Server, enter the updated password inside Aternity's settings. If you defined custom attributes using a query in the database, select the Gear Icon > Settings > Advanced Settings > Aternity > Dataserver > Handlers > StaticsMessageHandler > DerivedAttrGeneratorManager > generatorsData, and enter the new password in the xml file. Change the database password if your attribute mapping is database dependent Step 28 Select User Icon > Change Password. Parent topic Secure your Aternity Deployment and Ensure Privacy