Connectrix: Unable to upgrade Windows DCNM from 11.2.1 to 11.3.1 [database connection error]
Summary: DCNM upgrade from 11.2.1 to 11.3.1 fails.
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
Upgrade from Windows DCNM version 11.2.1 to 11.3.1.
Symptom 1:
Upgrading Windows DCNM from version 11.2.1 to 11.3.1 does not complete. System shows a display with the following error:
Symptom 2:
DCNM_installer.log shows the following error:
Symptom 3:
Checked the path for the file installvariable.properties and it is missing form the directory.
Symptom 4:
The DCNM 11.3.1 UI installer does not complete with an empty database URL in the dialog if the following file is missing: [drive letter:]\Program Files\Cisco Systems\dcm\Uninstall_DCNM\installvariables.prop
Symptom 1:
Upgrading Windows DCNM from version 11.2.1 to 11.3.1 does not complete. System shows a display with the following error:
[DB connection error]
failed to connect to DB with the following input(s):
DB url:
DB user:
Please check DB server status/credentials
installation will be aborted on clicking ok
failed to connect to DB with the following input(s):
DB url:
DB user:
Please check DB server status/credentials
installation will be aborted on clicking ok
Symptom 2:
DCNM_installer.log shows the following error:
Fri Jan 24 14:57:22 EST 2020: ERROR - DCNM_LOG: Failed to read properties from file installvariables.propertiesE:\Cisco\dcm\Uninstall_DCNM\installvariables.properties (The system cannot find the file specified)
Fri Jan 24 14:57:22 EST 2020: DCNM_LOG:
+------------------------------------+
| Printing DB var values for upgrade |
+------------------------------------+
Selected DB Type : postgresql
Prev Selected DB Type : postgresql
DB name :
Prev DB name :
DB username :
Prev DB username :
DB jdbc url :
Is DB server resident :
Postgres 9.3 upgrade :
Fri Jan 24 14:57:22 EST 2020: DCNM_LOG:
+------------------------------------+
| Printing DB var values for upgrade |
+------------------------------------+
Selected DB Type : postgresql
Prev Selected DB Type : postgresql
DB name :
Prev DB name :
DB username :
Prev DB username :
DB jdbc url :
Is DB server resident :
Postgres 9.3 upgrade :
Symptom 3:
Checked the path for the file installvariable.properties and it is missing form the directory.
Symptom 4:
The DCNM 11.3.1 UI installer does not complete with an empty database URL in the dialog if the following file is missing: [drive letter:]\Program Files\Cisco Systems\dcm\Uninstall_DCNM\installvariables.prop
Cause
This is a known issue. Cisco issue number CSCvs80183 - DCNM 11.3.1 installer fails if installvariables.properties file is missing.
The file [drive letter]:\Program Files\Cisco Systems\dcm\Unistall_DCNM\installvariables.properties should have been created during a previous install, and it is necessary for the upgrade to version 11.3.1 to proceed.
The file [drive letter]:\Program Files\Cisco Systems\dcm\Unistall_DCNM\installvariables.properties should have been created during a previous install, and it is necessary for the upgrade to version 11.3.1 to proceed.
Resolution
Workaround 1:
If possible, find a copy of the original installvariables.properties file in a backup of the 11.2.1 server (or a VM snapshot or similar). Copy the original installvariables.properties file back to the existing server in the correct directory. The upgrade can proceed.
Workaround 2:
If there is an installvariables.properties file from another server running 11.3.1, and all the required information from the server failing to upgrade due to missing file is available (original usernames, passwords, IP addresses, and so forth, on the existing 11.2.1 server), the file from 11.3.1 can be edited to reflect the correct server information about the server that is failing to upgrade from 11.2.1. Edit the below properties inside the borrowed installvariables.properties file to exactly match the 11.2.1 server being upgraded. note, if you just copy the existing file from another server without editng it, install wil likely fail with this error:
Turn the known plain text passwords for the existing DCNM 11.2.1 server into encrypted password using: Cisco\dcm\dcnm\bin\encrypt_text.bat. When using 'encrypt_text.bat', it must be done from the DCNM server where the key will be used in order to get the correct encrypted string. Then put the encrypted form of the password in the new file entries noted below:
If possible, find a copy of the original installvariables.properties file in a backup of the 11.2.1 server (or a VM snapshot or similar). Copy the original installvariables.properties file back to the existing server in the correct directory. The upgrade can proceed.
Workaround 2:
If there is an installvariables.properties file from another server running 11.3.1, and all the required information from the server failing to upgrade due to missing file is available (original usernames, passwords, IP addresses, and so forth, on the existing 11.2.1 server), the file from 11.3.1 can be edited to reflect the correct server information about the server that is failing to upgrade from 11.2.1. Edit the below properties inside the borrowed installvariables.properties file to exactly match the 11.2.1 server being upgraded. note, if you just copy the existing file from another server without editng it, install wil likely fail with this error:
Turn the known plain text passwords for the existing DCNM 11.2.1 server into encrypted password using: Cisco\dcm\dcnm\bin\encrypt_text.bat. When using 'encrypt_text.bat', it must be done from the DCNM server where the key will be used in order to get the correct encrypted string. Then put the encrypted form of the password in the new file entries noted below:
server
DCNM_IP_ADDRESS= IP address for DCNM Server
SERVER_IP_ADDRESS= IP address for DCNM Server
FEDERATED_NODES= empty
DCNM_ADMIN_USER_PASSWORD= DCNM password
DCNM_DB_USER_PASSWORD_TEMP= Postgres password
DB_CONNECTION_PASSWORD_TEMP= Postgres password
DCNM_DB_USER_PASSWORD= Postgres password
DB_CONNECTION_PASSWORD= Postgres password
ADMIN_PASSWORD= Postgres password with 123 appended on the end
ADMIN_PASSWORD_TEMP= Postgres password with 123 appended on the end
DCNM_IP_ADDRESS= IP address for DCNM Server
SERVER_IP_ADDRESS= IP address for DCNM Server
FEDERATED_NODES= empty
DCNM_ADMIN_USER_PASSWORD= DCNM password
DCNM_DB_USER_PASSWORD_TEMP= Postgres password
DB_CONNECTION_PASSWORD_TEMP= Postgres password
DCNM_DB_USER_PASSWORD= Postgres password
DB_CONNECTION_PASSWORD= Postgres password
ADMIN_PASSWORD= Postgres password with 123 appended on the end
ADMIN_PASSWORD_TEMP= Postgres password with 123 appended on the end
Once correctly edited, save the file in the noted path, and the install can proceed.
Workaround 3:
Run the attached script files (create-install-properties).zip to create a new installvariables.properties file based on the current DCNM instance.
1. unzip and copy the contents of create-install-properties folder to the directory below. the unzipped folder contains a .bat file to execute and a folder called prop which contains blank 11.2, 11.3, and 11.5 installvariables.properties versions, and you will specify the version needed in the command execution.
Workaround 3:
Run the attached script files (create-install-properties).zip to create a new installvariables.properties file based on the current DCNM instance.
1. unzip and copy the contents of create-install-properties folder to the directory below. the unzipped folder contains a .bat file to execute and a folder called prop which contains blank 11.2, 11.3, and 11.5 installvariables.properties versions, and you will specify the version needed in the command execution.
c:\users\administrator\AppData\local\temp\
2. open a command prompt, change to the directory above, and then run the script as follows:
c:\users\administrator\appdata\local\temp\create-install-prop.bat dcnmversion adminpassword databasepassword
example from a dcnm 11.3 instance with the file missing, where the dcnm admin paasword and dcm postgres dataabase password are set the same:
c:\users\administrator\appdata\local\temp\create-install-prop.bat 11.3 P@55word! P@55word!
3. Once this completes successfully, you will find a new installvariables.properties file in the apropriate directory and you can proceed with install.
Additional Information
Verify that the encrypted password entries in the installer.properties are correct. You can find what they should be by going to the file postgresql.cfg.xml (oracle.cfg.xml for Oracle DBs) in the [drive letter]:\Program Files\Cisco Systems\dcm\wildfly-10.1.0.Final\standalone\conf directory.
Alternatively, you can generate the encrypted string by using the encrypt_text.bat file that is found in the [drive letter]:\Program Files\Cisco Systems\dcm\dcnm\bin directory.
Note: Run this script on the DCNM server where the key will be used to get the correct encrypted string. Also, if the password contains special characters they must be escaped using the \ character to get the correct encrypted string.
Alternatively, you can generate the encrypted string by using the encrypt_text.bat file that is found in the [drive letter]:\Program Files\Cisco Systems\dcm\dcnm\bin directory.
Note: Run this script on the DCNM server where the key will be used to get the correct encrypted string. Also, if the password contains special characters they must be escaped using the \ character to get the correct encrypted string.
Products
Connectrix MDS-Series Data Center Network ManagerArticle Properties
Article Number: 000170091
Article Type: Solution
Last Modified: 30 Aug 2022
Version: 4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.