The Security Agents connect directly to the HDP Security Administration database.
Using the connection information you provided in the
install.properties file, manually verify that the mysql
database is accessible:
Log into the agent host as
root.Open the install.properties file and find the connection information, for example:
XAAUDIT.DB.HOSTNAME=poliymgr XAAUDIT.DB.DATABASE_NAME=xasecure XAAUDIT.DB.USER_NAME=xasecure XAAUDIT.DB.PASSWORD=hadoop
Telnet to the MySQL port from the agent host to the HDP Security Administration host:
telnet policymgr 3306 Trying 192.168.56.101... Connected to policymgr. Escape character is '^]'.
Using the same information, connect to the MySQL database from the command line:
mysql -u$XAAUDIT.DB.USER_NAME -p$XAAUDIT.DB.PASSWORD -h$XAAUDIT.DB.HOSTNAME $XAAUDIT.DB.DATABASE_NAME
For example:
mysql -uxasecure -phadoop -hpolicymgr xasecure Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4069 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
If the connection is rejected, verify MySQL user name and password as well as the permissions for the user to connect remotely.
