12.3 Creating the Novell Audit Database

Novell Audit requires a database to store all of the collected events.

  1. From the Computer menu, select Gnome Terminal.

  2. Enter cd /opt/novell/idm/mysql/ access the MySQL client.

  3. Enter ./start-mysql-client.sh root n0v3ll to launch the MySQL client.

  4. Enter create database naudit; to create the database.

  5. Enter use mysql

  6. Enter grant all on naudit.* to auditusr@‘%’ identified by ‘n0v3ll’; to give users access to the naudit database.

  7. Enter select host,user from user; to specify the users that have access to the database.

  8. Enter flush privileges; to save the changes.

  9. Enter quit to exit.

  10. Enter exit to close the Gnome Terminal.

  11. Proceed to Section 12.4, Installing the Novell Audit Plug-Ins.