ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Report Manager not starting up due to errors regarding skip grant tables

book

Article ID: 237290

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

After upgrading to 21.2.6, Report Manager is no longer starting properly.

 

Errors seen:

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1290 (HY000) at line 26 in file: '/spectrum/Install-Tools/rpmgr/sql/srmdbapi/dcl/create_srmapi_user.sql': The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

Environment

Release : 21.2

Component : Spectrum Reporting

Resolution

In later versions of MySQL, certain tasks and queries cannot be run with skip-grant-tables turned on.  This is a security issue.

Therefore, this will need to be turned off in the $SPECROOT/mysql/my-spectrum.cnf file and processd restarted.