Openstack installation : SQL Database and Openstack client

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.

Previous Post : Install NTP (all nodes)
Next Post     : Install Message Queue (controller)

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