Had followed steps given in https://docs.openstack.org – Content mostly from openstack.org – This is just a compilation on steps followed by me. Minor changes may be observed as I had installed on Debian 9.6.
Install python-openstack client in all nodes
apt install python-openstackclient
On controller node install MariaDB – Will be used by Openstack services.
apt install mysql-server python-pymysql
Create and edit the /etc/mysql/conf.d/openstack.cnf
[mysqld] bind-address = 10.0.0.18 default-storage-engine = innodb innodb_file_per_table max_connections = 4096 collation-server = utf8_general_ci character-set-server = utf8
Update the bind address for mysql service to bind to the controller node ip so that services can connect. Also update the
default character set to utf8 from ut8mb4
root@controller:~# nano /etc/mysql/mariadb.conf.d/50-server.cnf ... ... # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 10.0.0.18 ... ... # # * Character sets # # MySQL/MariaDB default is Latin1, but in Debian we rather default to the full # utf8 4-byte character set. See also client.cnf # character-set-server = utf8 collation-server = utf8_general_ci root@controller:~# nano /etc/mysql/mariadb.conf.d/50-client.cnf [client] # Default is Latin1, if you need UTF-8 set this (also in server section) default-character-set = utf8 nano /etc/mysql/mariadb.conf.d/50-mysql-clients.cnf [mysql] default-character-set = utf8
Restart mysql service
root@controller:~# service mysql restart