Access Denied running RpmgrInitializeLandscape

Products

• Network Observability
• Spectrum

Issue/Introduction

I see the following running RpmgrInitializeLandscape

 

$ ./RpmgrInitializeLandscape.sh root <mysql password> -initHist 45 -all
Got exception connecting to mysql
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833)
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:416)
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238)
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at com.aprisma.spectrum.app.repmgr.util.RpmgrInitializeLandscape.main(RpmgrInitializeLandscape.java:59)

Environment

Dx NetOps Spectrum any version

Cause

Incorrect password for mysql root

Resolution

Run this command as the spectrum admin user but using the incorrect mysql password for mysql root will produce this error.  Using the correct password will allow the command to run to completion