DX NetOps SRB-RIB Service shows service status as available but database as down

Products

• Network Observability

Issue/Introduction

After upgrading to Spectrum we were seeing that the SRM-RIB service status within the NetOps portal was showing available but the SRM database status was showing down.

Environment

All Supported Releases

Cause

Database Password  was modified within the /opt/SRM/srm-rib/webapps/srm-rib/WEB-INF/application.properties file.

 

Resolution

Please review the Database password within opt/SRM/srm-rib/webapps/srm-rib/WEB-INF/application.properties

rib.minVersion=1.0

rib.currentVersion=1.0

# Spectrum Report Manager Database connection settings

db.queryTimeout=120

db.validationQueryTimeout=3000

db.validationQuery=SELECT 1 FROM DUAL

db.host=****************

db.port=3306

db.database=reporting

db.connection.params=characterEncoding=UTF-8&useSSL=true&verifyServerCertificate=false

db.testOnBorrow=false

db.timeBetweenEvictionRunsMillis=30000

db.maxActive=80

db.username=SRM_user

db.password=**************( Needs to be encrypted password when db.passwordEncrypted=true)

db.testOnReturn=false

db.passwordEncrypted=true

db.testWhileIdle=true

db.driverClassName=com.mysql.cj.jdbc.Driver

Once the password is corrected , please restart the srm_rib.service.