Clean NetBackup for OpenStack database resources
NetBackup for OpenStack creates a database for the nbosdmapi service. This database needs to be cleaned.
Login into the database cluster.
## On RHOSP podman exec -it galera-bundle-podman-0 mysql -u root
Run the following SQL statements to clean the database.
## Clean database DROP DATABASE nbosdmapi; ## Clean nbosdmapi user MariaDB [mysql]> select user, host from mysql.user where user='nbosdmapi'; +-----------+-------------+ | user | host | +-----------+-------------+ | nbosdmapi | 172.25.2.10 | | nbosdmapi | 172.25.2.8 | +-----------+-------------+ 2 rows in set (0.00 sec) => Delete those user accounts MariaDB [mysql]> DROP USER nbosdmapi@172.25.2.10; Query OK, 0 rows affected (0.82 sec) MariaDB [mysql]> DROP USER nbosdmapi@172.25.2.8; Query OK, 0 rows affected (0.05 sec) => Verify that nbosdmapi user got cleaned MariaDB [mysql]> select user, host from mysql.user where user='nbosdmapi'; Empty set (0.00 sec)