Add network details for the vpn_users. #7292
Description
ISSUE TYPE
- Improvement/Enhancement request
COMPONENT NAME
Componet:API
Componet:Database
Component: UI
CLOUDSTACK VERSION
4.18 nightly
4.17.2
SUMMARY
Add network details for the vpn_users.
Since vpn users are associated with a particular network or a vpc.
It would be handy for the admin to identify the users and the respective network they belong to
Also, the database and API's should be modified to include the network id
Database details
MariaDB [cloud]> desc vpn_users;
+-----------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+----------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| uuid | varchar(40) | YES | UNI | NULL | |
| owner_id | bigint(20) unsigned | NO | MUL | NULL | |
| domain_id | bigint(20) unsigned | NO | MUL | NULL | |
| username | varchar(255) | NO | MUL | NULL | |
| password | varchar(255) | NO | | NULL | |
| state | char(32) | NO | | NULL | |
+-----------+---------------------+------+-----+---------+----------------+
7 rows in set (0.04 sec)
MariaDB [cloud]> select * from vpn_users;
+----+--------------------------------------+----------+-----------+----------+--------------------------------------------------+--------+
| id | uuid | owner_id | domain_id | username | password | state |
+----+--------------------------------------+----------+-----------+----------+--------------------------------------------------+--------+
| 1 | 7440ec75-5d19-4c31-b0d6-f4d3fe089eea | 2 | 1 | test | cgURXqya5xXFAJ1zO38DUMja6sKbh+Z0k6EMMoLiAkYee33K | Active |
+----+--------------------------------------+----------+-----------+----------+--------------------------------------------------+--------+
Api
https://cloudstack.apache.org/api/apidocs-4.17/apis/listVpnUsers.html
https://cloudstack.apache.org/api/apidocs-4.17/apis/addVpnUser.html
UI
EXPECTED RESULTS
Admin User should be identify the network a particular vpn user belongs to
ACTUAL RESULTS
Admin User is unable identify the network a particular vpn user belongs to