Install a virtual machine with an OpenStack environment, and synchronize IP changes in the database when you need to change IP

Source: Internet
Author: User

Thank you for your friends to support this blog, welcome to discuss the exchange, because of limited capacity and time, mistakes are unavoidable, welcome correction.
If reproduced, please retain the author's information.


Blog Address: http://blog.csdn.net/qq_21398167

Original post address: http://blog.csdn.net/qq_21398167/article/details/46729717

Because the OpenStack environment was configured, very many tables were created. is configured with the native IP

So when the machine needs to change the IP, you need 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.  Command s 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), Oracle, MariaDB Corporation Ab and others.

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 the full 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 change all the IP inside.

Like what:

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



Install a virtual machine with an OpenStack environment, and synchronize IP changes in the database when you need to change IP

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.