Custom Query (98 matches)

In testing IG-MON-3 step 5, i found that the manifest cached for each ProtoGENI experiment reports dataplane IP addresses and MAC addresses (or at least it should do so fully once [instaticket:26] has been resolved). However, the only way i was easily able to find control IPs assigned to VMs was the interfaces table:

mysql> select * from interfaces where IP="172.17.3.1";
+---------+------+------+--------------+------------+-----------+-------------+----------------+-------+------+---------------+--------+--------+----------+------+-------+--------------------------------------+---------+
| node_id | card | port | mac          | IP         | IPaliases | mask        | interface_type | iface | role | current_speed | duplex | rtabid | vnode_id | whol | trunk | uuid                                 | logical |
+---------+------+------+--------------+------------+-----------+-------------+----------------+-------+------+---------------+--------+--------+----------+------+-------+--------------------------------------+---------+
| pcvm3-1 |    0 |    1 | 000000000000 | 172.17.3.1 | NULL      | 255.240.0.0 | generic        | eth0  | ctrl | 0             | full   |      0 | NULL     |    0 |     0 | e5b9ad51-a379-11e1-af1c-00009b6224df |       1 | 
+---------+------+------+--------------+------------+-----------+-------------+----------------+-------+------+---------------+--------+--------+----------+------+-------+--------------------------------------+---------+
1 row in set (0.00 sec)

This table appears to contain IPs only for running experiments, and does not appear to contain real MAC addresses.

1. How can i find what control IPs were assigned to what VMs belonging to now-terminated experiments?
2. How can i find out MAC address assignments for these VMs?

How would a site admin figure out what experiments are running on a given shared node? It's definitely possible to login to the node and view logs, and that's not too bad. However, for physical nodes, i often make use of the web UI, in particular ​https://boss.utah.geniracks.net/nodecontrol_list.php3?showtype=dl360, which (in red dot mode) maps physical nodes to experiments.

Maybe ​https://boss.utah.geniracks.net/showpool.php should have an optional "shownode" argument, which would cause it to show a table of experiments on that node?

I think this would have some value, so the value-to-effort proposition would be good, especially if it's easy to do. But let me know if there's an alternative easy way to get this information via the web UI "given a physical host which is acting as a shared node, what experiments are using resources on that host?"

The full information about my experiment (from ​https://boss.utah.geniracks.net/showexp.php3?experiment=952#details) shows:

Virtual Node Info:
ID              Type         OS              Qualified Name
--------------- ------------ --------------- --------------------
phys1 (pc2)     pc           FEDORA15-STD    phys1.ecgtest.pgeni-gpolab-bbn-com.utah.geniracks.net
virt1 (pc3)     pcvm         OPENVZ-STD      virt1.ecgtest.pgeni-gpolab-bbn-com.utah.geniracks.net

Of those, the phys1 address is in DNS, and is a valid way to get into the node:

capybara,[~],08:19(0)$ host phys1.ecgtest.pgeni-gpolab-bbn-com.utah.geniracks.net
phys1.ecgtest.pgeni-gpolab-bbn-com.utah.geniracks.net is an alias for pc2.utah.geniracks.net.
pc2.utah.geniracks.net has address 155.98.34.12

However, the virt1 address is not in DNS:

capybara,[~],08:19(0)$ host virt1.ecgtest.pgeni-gpolab-bbn-com.utah.geniracks.net
Host virt1.ecgtest.pgeni-gpolab-bbn-com.utah.geniracks.net not found: 3(NXDOMAIN)

Should it be?