While attempting the 22.2.4 upgrade the PC installer is asking me for root pw to mysql. I've tried every one I know and that used to be on this MySQL and none work. Need some help to get PC upgraded.
The DX NetOps Performance Management installer is asking for a database password for the root user during an upgrade. This is not a normal expected question. When the correct complex MySQL password is entered the result is rejection. The installer just returns a password rejection saying it's not valid. No more specific error is seen.
Attempts to connect to MySQL independent of the running services, using CLI tools, also fail. This is despite use of the known correct password. An example of the error from attempts to connect to the MySQL CLI look like this.
The Portal server involved was running for over 200 days without reboot.
All supported DX NetOps Performance Management releases
The MySQL /tmp/msyql.sock file was removed from the system after the MySQL service was started.
No specific reason for the file being removed is known. Being placed in /tmp suggests some cleanup process, or possible user interaction resulted in the file being removed.
The /etc/my.cnf states the socket file mysql is using is the /tmp/mysql.sock file.
If no longer present post MySQL start to resolve it we would take the following steps.
See the Restart NetOps Portal documentation topic for steps to stop and start the Portal web server services and it's MySQL database.