- PAM Appliance is a black box. The MYSQL DB is not installed in PAM. It has to be created in your own environment, in a DB server.
- To prepare it is only necessary to create a new database accordingly. No tables are required to be created.
- When PAM communicates attaches the new MySQL Database the very first time, it will automatically create the tables.
Follow the below steps:
1) Install MySQL in a server.
Note: Ensure port 3306 is open between PAM and the MySQL Server.
2) Connect to MySQL and create the database.
mysql>create <Database Name>;
3) Grant privileges to the db user that is going to connect to the database from PAM:
mysql>GRANT ALL PRIVILEGES ON *.* TO root@'<PAM Hostname>' IDENTIFIED BY '<your password>' WITH GRANT OPTION;
[OR mysql>GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '<your password>' WITH GRANT OPTION;]
mysql> FLUSH PRIVILEGES;
4) Login to PAM and go to Config>>Logs
Configure the External Log Server with the server IP where the DB is connected, port and credentials.
5) Click on Update. You should get the following message:
6) Connect to your database and verify that tables get created:
mysql>use <Database Name>;
Eg: my <Database Name> is logpam