Install and configure for Red Hat Enterprise Linux and CentOS¶

Prerequisites¶

Before you install and configure the Database service, you must create a database, service credentials, and API endpoints.

1. To create the database, complete these steps:

   • Use the database access client to connect to the database server as the root user:

     $ mysql -u root -p
     

   • Create the trove database:

     CREATE DATABASE trove;
     

   • Grant proper access to the trove database:

     GRANT ALL PRIVILEGES ON trove.* TO 'trove'@'localhost' \
       IDENTIFIED BY 'TROVE_DBPASS';
     GRANT ALL PRIVILEGES ON trove.* TO 'trove'@'%' \
       IDENTIFIED BY 'TROVE_DBPASS';
     

     Replace TROVE_DBPASS with a suitable password.

   • Exit the database access client.

2. Source the admin credentials to gain access to admin-only CLI commands:

   $ . admin-openrc
   

3. To create the service credentials, complete these steps:

   • Create the trove user:

     $ openstack user create --domain default --password-prompt trove
     User Password:
     Repeat User Password:
     +-----------+-----------------------------------+
     | Field     | Value                             |
     +-----------+-----------------------------------+
     | domain_id | default                           |
     | enabled   | True                              |
     | id        | ca2e175b851943349be29a328cc5e360  |
     | name      | trove                             |
     +-----------+-----------------------------------+
     

   • Add the admin role to the trove user:

     $ openstack role add --project service --user trove admin
     

     Note

     This command provides no output.

   • Create the trove service entity:

     $ openstack service create --name trove \
       --description "Database" database
     +-------------+-----------------------------------+
     | Field       | Value                             |
     +-------------+-----------------------------------+
     | description | Database                          |
     | enabled     | True                              |
     | id          | 727841c6f5df4773baa4e8a5ae7d72eb  |
     | name        | trove                             |
     | type        | database                          |
     +-------------+-----------------------------------+
     

4. Create the Database service API endpoints:

   $ openstack endpoint create --region RegionOne \
     database public http://controller:8779/v1.0/%\(tenant_id\)s
   +--------------+----------------------------------------------+
   | Field        | Value                                        |
   +--------------+----------------------------------------------+
   | enabled      | True                                         |
   | id           | 3f4dab34624e4be7b000265f25049609             |
   | interface    | public                                       |
   | region       | RegionOne                                    |
   | region_id    | RegionOne                                    |
   | service_id   | 727841c6f5df4773baa4e8a5ae7d72eb             |
   | service_name | trove                                        |
   | service_type | database                                     |
   | url          | http://controller:8779/v1.0/%\(tenant_id\)s  |
   +--------------+----------------------------------------------+
   
   $ openstack endpoint create --region RegionOne \
     database internal http://controller:8779/v1.0/%\(tenant_id\)s
   +--------------+----------------------------------------------+
   | Field        | Value                                        |
   +--------------+----------------------------------------------+
   | enabled      | True                                         |
   | id           | 9489f78e958e45cc85570fec7e836d98             |
   | interface    | internal                                     |
   | region       | RegionOne                                    |
   | region_id    | RegionOne                                    |
   | service_id   | 727841c6f5df4773baa4e8a5ae7d72eb             |
   | service_name | trove                                        |
   | service_type | database                                     |
   | url          | http://controller:8779/v1.0/%\(tenant_id\)s  |
   +--------------+----------------------------------------------+
   
   $ openstack endpoint create --region RegionOne \
     database admin http://controller:8779/v1.0/%\(tenant_id\)s
   +--------------+----------------------------------------------+
   | Field        | Value                                        |
   +--------------+----------------------------------------------+
   | enabled      | True                                         |
   | id           | 76091559514b40c6b7b38dde790efe99             |
   | interface    | admin                                        |
   | region       | RegionOne                                    |
   | region_id    | RegionOne                                    |
   | service_id   | 727841c6f5df4773baa4e8a5ae7d72eb             |
   | service_name | trove                                        |
   | service_type | database                                     |
   | url          | http://controller:8779/v1.0/%\(tenant_id\)s  |
   +--------------+----------------------------------------------+
   

Install and configure components¶

1. Install the packages:

   # yum install openstack-trove python-troveclient
   

2. In the /etc/trove directory, edit the trove.conf, trove-taskmanager.conf and trove-conductor.conf files and complete the following steps:

   • Provide appropriate values for the following settings:

     [DEFAULT]
     log_dir = /var/log/trove
     trove_auth_url = http://controller:5000/v2.0
     nova_compute_url = http://controller:8774/v2
     cinder_url = http://controller:8776/v1
     swift_url = http://controller:8080/v1/AUTH_
     notifier_queue_hostname = controller
     ...
     [database]
     connection = mysql+pymysql://trove:TROVE_DBPASS@controller/trove
     

   • Configure the Database service to use the RabbitMQ message broker by setting the following options in each file:

     [DEFAULT]
     ...
     rpc_backend = rabbit
     
     [oslo_messaging_rabbit]
     ...
     rabbit_host = controller
     rabbit_userid = openstack
     rabbit_password = RABBIT_PASS
     

3. Verify that the api-paste.ini file is present in /etc/trove.

   If the file is not present, you can get it from this location.

4. Edit the trove.conf file so it includes appropriate values for the settings shown below:

   [DEFAULT]
   auth_strategy = keystone
   ...
   # Config option for showing the IP address that nova doles out
   add_addresses = True
   network_label_regex = ^NETWORK_LABEL$
   ...
   api_paste_config = /etc/trove/api-paste.ini
   ...
   [keystone_authtoken]
   ...
   auth_uri = http://controller:5000
   auth_url = http://controller:35357
   auth_type = password
   project_domain_name = default
   user_domain_name = default
   project_name = service
   username = trove
   password = TROVE_PASS
   

5. Edit the trove-taskmanager.conf file so it includes the required settings to connect to the OpenStack Compute service as shown below:

   [DEFAULT]
   ...
   # Configuration options for talking to nova via the novaclient.
   # These options are for an admin user in your keystone config.
   # It proxy's the token received from the user to send to nova
   # via this admin users creds,
   # basically acting like the client via that proxy token.
   nova_proxy_admin_user = admin
   nova_proxy_admin_pass = ADMIN_PASS
   nova_proxy_admin_tenant_name = service
   taskmanager_manager = trove.taskmanager.manager.Manager
   

6. Edit the /etc/trove/trove-guestagent.conf file so that future trove guests can connect to your OpenStack environment:

   rabbit_host = controller
   rabbit_password = RABBIT_PASS
   nova_proxy_admin_user = admin
   nova_proxy_admin_pass = ADMIN_PASS
   nova_proxy_admin_tenant_name = service
   trove_auth_url = http://controller:35357/v2.0
   

7. Populate the trove database you created earlier in this procedure:

   # su -s /bin/sh -c "trove-manage db_sync" trove
     ...
     2016-04-06 22:00:17.771 10706 INFO trove.db.sqlalchemy.migration [-]
     Upgrading mysql+pymysql://trove:dbaasdb@controller/trove to version latest
   

   Note

   Ignore any deprecation messages in this output.

Finalize installation¶

Start the Database services and configure them to start when the system boots:

# systemctl enable openstack-trove-api.service \
  openstack-trove-taskmanager.service \
  openstack-trove-conductor.service

# systemctl start openstack-trove-api.service \
  openstack-trove-taskmanager.service \
  openstack-trove-conductor.service