Comment 3 for bug 1833650

Revision history for this message
Piotr Kopec (pkopec) wrote :

I just went through the install guide myself by coppy-paste and I did not hit this problem. There are following commands that you are probably missing that sets the permissions:
```
MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'%' \
  IDENTIFIED BY 'NOVA_DBPASS';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' \
  IDENTIFIED BY 'NOVA_DBPASS';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova_cell0.* TO 'nova'@'%' \
  IDENTIFIED BY 'NOVA_DBPASS';
```
The percent sign '%' is there to accept connection from any client address. Moreover you also need to remember to configure DB to listen on IP address of the controller node as specified in the SQL install guide [1]

[1] https://docs.openstack.org/install-guide/environment-sql-database-rdo.html