Issue creating a Token Vault using MySQL for Cloud Data Protection 4.x

Products

• CDP Integration Server

Issue/Introduction

Attempting to create a Token Vault in MySQL results in a failed to save error when using a non-root user.

Cause

The store procedure that is created in the tokenspace1 database uses a function that sets a global variable.  This is the only database that uses this stored procedure.
For the server to create this stored procedure it needs the SUPER privilege.  This is not part of the grant all set of privileges as such using GRANT ALL on the cdp user will not work.  The default root user has this privilege by default.

Resolution

Grant SUPER to the user attempting to connect to the Tokenspace1 database.

GRANT ALL on tokenspace1.* to 'cdpadmin'@'localhost';
GRANT SUPER on *.* to 'cdpadmin'@'localhost';