Install and configure an openstack Virtual Machine. When you need to modify the ip address, you can modify the ip address in the database.

Install and configure an openstack Virtual Machine. When you need to modify the ip address, you can modify the ip address in the database.

Since many tables are created when the openstack environment is configured, the local ip address is configured.

Therefore, when the local machine needs to modify the ip address, it needs to synchronize all the environment-related ip addresses in the database.

Method:

1. Enter the database

[Root @ node Desktop] # mysql-uroot-p
Enter password:
Welcome to the MariaDB monitor. Commands end with; or \ g.
Your MariaDB connection id is 2
Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026

Copyright (c) 2000,201 4, Oracle, MariaDB Corporation AB and others.

Type 'help; 'or' \ H' for help. type' \ C' to clear the current input statement.

MariaDB [(none)]>

2. show database for all data;

MariaDB [(none)]> show databases;
+ -------------------- +
| Database |
+ -------------------- +
| Information_schema |
| Glance |
| Keystone |
| Mysql |
| Nova |
| Performance_schema |
| Test |
+ -------------------- +
7 rows in set (0.12 sec)

MariaDB [(none)]>

3. Enter the keystone Database

MariaDB [(none)]> use keystone;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with-

Database changed
MariaDB [keystone]>

4. view all data tables

MariaDB [keystone]> show tables;
+ ----------------------- +
| Tables_in_keystone |
+ ----------------------- +
| Assignment |
| Credential |
| Domain |
| Endpoint |
| Group |
| Migrate_version |
| Policy |
| Project |
| Region |
| Role |
| Service |
| Token |
| Trust |
| Trust_role |
| User |
| User_group_membership |
+ ----------------------- +
16 rows in set (0.00 sec)

MariaDB [keystone]>

5. view all content in the endpoint data table

MariaDB [keystone]> SELECT * FROM endpoint;
+ ---------------------------------- + ------------- + ------------------------------------ + ------- +
| Id | legacy_endpoint_id | interface | region | service_id | url | extra | enabled |
+ ---------------------------------- + ------------- + ------------------------------------ + ------- +
| 2c1bfecbc0354ce8998675ae450139b6 | f73717cab6d4464cb65171d31535efe3 | public | regionOne | region | http: // 192.168.0.22: 5000/v2.0 | {} | 1 |
| 458b7c2cf4614f2fade90836671795ea | region | admin | regionOne | 507666ec257f4090850853ce5fa06881 | http: // 192.168.0.22: 9292 | {} | 1 |
| Authorization | 3f6df8dffd5745228130066c9521888a | public | regionOne | region | http: // 192.168.0.22: 8774/v2/% (tenant_id) s |{}| 1 |
| Authorization | e1d8e224bc434587941d00f42b1b3d88 | internal | regionOne | 507666ec257f4090850853ce5fa06881 | http: // 192.168.0.22: 9292 |{}| 1 |
| Route | f73717cab6d4464cb65171d31535efe3 | admin | regionOne | da28568989314cb6562a069a8c4c4e | http: // 192.168.0.22: 35357/a0|{} | 1 |
| Route | f73717cab6d4464cb65171d31535efe3 | internal | regionOne | da28568989314cbcb6562a069a8c4c4e | http: // 192.168.0.22: 5000/v2.0 |{}| 1 |
| Tenant | 3f6df8dffd5745228130066c9521888a | internal | regionOne | region | http: // 192.168.0.22: 8774/v2/% (tenant_id) s |{}| 1 |
| Cfda-711e11547b3b03885e08bbdab5d | latest | public | regionOne | 507666ec257f4090850853ce5fa06881 | http: // 192.168.0.22: 9292 | {} | 1 |
| Tenant | 3f6df8dffd5745228130066c9521888a | admin | regionOne | region | http: // 192.168.0.22: 8774/v2/% (tenant_id) s |{}| 1 |
+ ---------------------------------- + ------------- + ------------------------------------ + ------- +
9 rows in set (0.00 sec)

MariaDB [keystone]>
6. Use the command to modify all the ip addresses in it.

For example:

update endpoint set url='http://192.168.0.22:5000/v2.0' where id='2c1bfecbc0354ce8998675ae511139b6';

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.