Set up the REST Application Database
Prior to installing Cloudera Cybersecurity Platform (CCP), you must set up the REST application database.
- Connect to MySQL and create a Metron REST database:
mysql -uroot -p -e "CREATE DATABASE IF NOT EXISTS metronrest;"
-
Create a Metron user in MySQL with a password, then apply database access permission
to the Metron user:
CREATE USER 'metron'@'$REST_HOST' IDENTIFIED BY 'Myp@ssw0rd'; GRANT ALL PRIVILEGES ON metronrest.* TO 'metron'@'$REST_HOST';
- Create user and authorities tables:
use metronrest; create table if not exists users( username varchar(50) not null primary key, password varchar(50) not null, enabled boolean not null ); create table authorities ( username varchar(50) not null, authority varchar(50) not null, constraint fk_authorities_users foreign key(username) references users(username) ); create unique index ix_auth_username on authorities (username,authority);
- Add one or more users to the REST application:
use metronrest; insert into users (username, password, enabled) values ('your_username', 'your_password',1); insert into authorities (username, authority) values ('your_username', 'ROLE_USER');
-
Exit MySQL:
quit
-
Install the appropriate MySQL client library for your version of MySQL. For
example:
cd $METRON_HOME/lib wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5. 1.41.tar.gz tar xf mysql-connector-java-5.1.41.tar.gz
- To add additional users:
use metronrest; insert into users (username, password, enabled) values ('your_username', 'your_password',1); insert into authorities (username, authority) values ('your_username', 'ROLE_USER'); commit;