What files/directories should be owned by the mysql user on CA Performance Management

Products

• CA Infrastructure Management
• CA Infrastructure Management
• CA Performance Management - Usage and Administration

Issue/Introduction

What files/directories should be owned by the mysql user on CA Performance Management

Environment

Release: IMDAGG99000-3.5-Infrastructure Management-Data Aggregator
Component:

Resolution

Starting in the top level MySql directory all files are owned by root.

The following directories under MySql are owned by mysql:

drwxrwxr-x. 7 mysql mysql 4096 Dec 4 06:16 ./data
drwxr-x---. 2 mysql mysql 36864 Dec 4 06:42 ./data/em
drwxr-x---. 2 mysql mysql 4096 Sep 6 09:31 ./data/mysql
drwxr-x---. 2 mysql mysql 24576 Dec 4 06:42 ./data/netqosportal
drwxr-x---. 2 mysql mysql 4096 Sep 6 09:31 ./data/performance_schema
drwxr-x---. 2 mysql mysql 12288 Sep 6 09:31 ./data/sys
drwxrwxr-x. 2 mysql root 4096 Dec 4 06:42 ./tmp

 

All files under thise directories are owned by mysql except:

-rw-rw----. 1 root root 5 Dec 4 06:16 ./data/mysqld_safe.pid

Which would be re-written by the mysqld_safe process which runs as root.
 

CAPC should be backed up and all CAPC/MySQL processes stopped before making any permission changes:

Back up CA Performance Center
How to restart the CA Performance Management CA Performance Center processes