[Openstack] extract user-data 유저 데이터 추출

# Extract user-data in Openstack

관리자로 데이터베이스에서 유저데이터를 추출할 때 사용

728x90

# Use Database nova (DB의 nova 데이터베이스 사용)

- MariaDB [(none)]> use nova;

root@controller:~# mysql
MariaDB [(none)]> use nova;
MariaDB [nova]> desc instances;
+--------------------------+-----------------------+------+-----+---------+----------------+
| Field                    | Type                  | Null | Key | Default | Extra          |
+--------------------------+-----------------------+------+-----+---------+----------------+
| created_at               | datetime              | YES  |     | NULL    |                |
...
| host                     | varchar(255)          | YES  | MUL | NULL    |                |
| user_data                | mediumtext            | YES  |     | NULL    |                |
| reservation_id           | varchar(255)          | YES  | MUL | NULL    |                |
...
| hidden                   | tinyint(1)            | YES  |     | NULL    |                |
+--------------------------+-----------------------+------+-----+---------+----------------+

 

- MariaDB [nova]> select user_data from instances where uuid='[instance_id]';

MariaDB [nova]> select user_data from instances where uuid='[instance_id]';
+--------------------------------------------------------------+
| user_data                                                    |
+--------------------------------------------------------------+
| I2Nsb3VkLWNvbmZpZwpbY2xvdWQtaW5pdF0KLi4uCnVzZXItZGF0YQouLi4= |
+--------------------------------------------------------------+

반응형

# Decode user-data in base64 (base64로 유저데이터확인)

- Save user_data in tmp_file (유저데이터 값을 임시로 저장)

root@controller:~# cat tmp_file
I2Nsb3VkLWNvbmZpZwpbY2xvdWQtaW5pdF0KLi4uCnVzZXItZGF0YQouLi4=

 

- Decode tmp_file (base64를 이용해 임시 저장한 유저데이터 값 decode)

root@controller:~# base64 -d tmp_file

root@controller:~# base64 -d tmp_file
#cloud-config
[cloud-init]
...
user-data
...