Install and configure for Red Hat Enterprise Linux and CentOS

Warning

This guide is not tested since stable/train.

This section describes how to install and configure the Database service for Red Hat Enterprise Linux 7 and CentOS 7.

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
    
  1. In the /etc/trove directory, edit the trove.conf file, here is an example:

    [DEFAULT]
    network_driver = trove.network.neutron.NeutronDriver
    management_networks = ef7541ad-9599-4285-878a-e0ab62032b03
    management_security_groups = d0d797f7-11d4-436e-89a3-ac8bca829f81
    cinder_volume_type = lvmdriver-1
    nova_keypair = trove-mgmt
    default_datastore = mysql
    taskmanager_manager = trove.taskmanager.manager.Manager
    trove_api_workers = 5
    transport_url = rabbit://stackrabbit:password@192.168.1.34:5672/
    control_exchange = trove
    rpc_backend = rabbit
    reboot_time_out = 300
    usage_timeout = 900
    agent_call_high_timeout = 1200
    use_syslog = False
    debug = True
    
    [keystone_authtoken]
    memcached_servers = localhost:11211
    cafile = /devstack/stack/data/ca-bundle.pem
    project_domain_name = Default
    project_name = service
    user_domain_name = Default
    password = password
    username = trove
    auth_url = http://192.168.1.34/identity
    auth_type = password
    
    [service_credentials]
    auth_url = http://192.168.1.34/identity/v3
    region_name = RegionOne
    project_name = service
    password = password
    project_domain_name = Default
    user_domain_name = Default
    username = trove
    
    [database]
    connection = mysql+pymysql://root:password@127.0.0.1/trove?charset=utf8
    
    [mariadb]
    tcp_ports = 3306,4444,4567,4568
    
    [mysql]
    tcp_ports = 3306
    
    [postgresql]
    tcp_ports = 5432
    
  2. 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.

  3. Edit the /etc/trove/trove-guestagent.conf file so that future trove guests can connect to your OpenStack environment, here is an example:

    [DEFAULT]
    log_file = trove-guestagent.log
    log_dir = /var/log/trove/
    ignore_users = os_admin
    control_exchange = trove
    transport_url = rabbit://stackrabbit:password@172.24.5.1:5672/
    rpc_backend = rabbit
    command_process_timeout = 60
    use_syslog = False
    debug = True
    
    [service_credentials]
    auth_url = http://192.168.1.34/identity/v3
    region_name = RegionOne
    project_name = service
    password = password
    project_domain_name = Default
    user_domain_name = Default
    username = trove
    
  4. 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