Install a virtual machine with an OpenStack environment and modify IP in the database when you need to modify IP

With the OpenStack environment in place, many tables have been created and the IP of this machine has been configured

So when the machine needs to modify the IP, it needs to synchronize all the environment-related IP in the database

Method:

1. Enter the database

[Email protected] 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) MariaDB, Oracle, Ab and others of the Corporation.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

MariaDB [(None)]>

2. Show all data show database;

MariaDB [(none)]> show databases;
+--------------------+
| database           |
+--------------------+
| information_schema |
| glance              |
| keystone           |
| mysql              |
| nova               |
| performance_schema |
| test               |
+--------------------+
7 rows in Set (0.12 sec)

MariaDB [(none)]>

3. Go to Keystone Database

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

Database changed
MariaDB [keystone]>

4. View all data Sheets

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 |
+-----------------------+
Rows in Set (0.00 sec)

MariaDB [keystone]>

5. View all the contents of the endpoint data sheet

MariaDB [keystone]> SELECT * from endpoint;
+----------------------------------+----------------------------------+-----------+-----------+---------------- ------------------+-------------------------------------------+-------+---------+
| ID | legacy_endpoint_id | interface | Region | service_id | URL | Extra | Enabled |
+----------------------------------+----------------------------------+-----------+-----------+---------------- ------------------+-------------------------------------------+-------+---------+
| 2c1bfecbc0354ce8998675ae511139b6 | F73717cab6d4464cb65171d31535efe3 | Public | Regionone | da28568989314cbcb6562a069a8c4c4e | http://192.168.0.22:5000/v2.0 |       {}    | 1 |
| 458b7c2cf4614f2fade90836671795ea | E1d8e224bc434587941d00f42b1b3d88 | admin | Regionone | 507666ec257f4090850853ce5fa06881 | http://192.168.0.22:9292 |       {}    | 1 |
| 565afe887f1244afb1bc2c75cb05b3f7 | 3f6df8dffd5745228130066c9521888a | Public | Regionone | 30162d7fd4c448f481a617a47138a087 | http://192.168.0.22:8774/v2/% (tenant_id) s |       {}    | 1 |
| 849d71c20521483480a02ca7e248d2b3 | E1d8e224bc434587941d00f42b1b3d88 | Internal | Regionone | 507666ec257f4090850853ce5fa06881 | http://192.168.0.22:9292 |       {}    | 1 |
| 886f672ed16a4b4c9a1959846cdb6790 | F73717cab6d4464cb65171d31535efe3 | admin | Regionone | da28568989314cbcb6562a069a8c4c4e | http://192.168.0.22:35357/v2.0 |       {}    | 1 |
| 99b9f854f7ab409bad2902376cfa26e0 | F73717cab6d4464cb65171d31535efe3 | Internal | Regionone | da28568989314cbcb6562a069a8c4c4e | http://192.168.0.22:5000/v2.0 |       {}    | 1 |
| b0ffbaf2b9854f07a9741fe7f7ee51f9 | 3f6df8dffd5745228130066c9521888a | Internal | Regionone | 30162d7fd4c448f481a617a47138a087 | http://192.168.0.22:8774/v2/% (tenant_id) s |       {}    | 1 |
| cf450711e11547b3b03885e08bbdab5d | E1d8e224bc434587941d00f42b1b3d88 | Public | Regionone | 507666ec257f4090850853ce5fa06881 | http://192.168.0.22:9292 |       {}    | 1 |
| ee495ededf0b46bb9f8db1efef85da71 | 3f6df8dffd5745228130066c9521888a | admin | Regionone | 30162d7fd4c448f481a617a47138a087 | 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 inside.

For example:

Update set URL=' http://192.168.0.22:5000/v2.0'where id=' 2c1bfecbc0354ce8998675ae511139b6';

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Install a virtual machine with an OpenStack environment and modify IP in the database when you need to modify IP