mysql probe: Received null data for password
Article ID: 270278
Updated On:
Products
Issue/Introduction
We are using mysql probe and can no longer connect to the database.
After entering the password as soon as we test the connection it is showing error: "Received NULL data for password".
Newly created connections are also failing with the same error.
Environment
Release : 20.3 mysql probe 3.60
Cause
mysql 3.60 no longer support weak encryption:
The current version of the probe uses an industry-standard AES 256 encryption algorithm to encrypt passwords. Weaker encryption algorithms like AES 128 or TWOFISH are not supported.
Resolution
To use the latest version of the probe the weak encryption should be removed at the controller level and replaced with:
Variable name: NIM_PROBE_CRYPTO_MODE
Variable value: AES_128_COMPAT
Hence, either you downgrade to the old version of the probe (1.72) or you first set the environment variables as the release notes indicate and then upgrade to the new version of the probe (3.60).
Please check the Environment Variable on the robot and if you do no have any for NIM_PROBE_CRYPTO_MODE it means that it defaults to TWOFISH. to use the latest version of the probe use:
Variable name: NIM_PROBE_CRYPTO_MODE
Variable value: AES_128_COMPAT
Add the env. variable as described here:
Feedback
