You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by cs user <ac...@gmail.com> on 2015/07/15 11:51:46 UTC
4.5.1 Guest allocated same IP address as router
Hi Folks,
Been testing with 4.5.1, all looks fine. However we have just hit an issue
where a guest has been allocated the same IP as the eth0 address of the
router for the pod.
Has anyone come across this issue before?
Here is how the db looks (Apologies for the formatting)!
mysql> select * from nics where ip4_address='192.168.188.60';
+-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
| id | uuid | instance_id | mac_address
| ip4_address | netmask | gateway | ip_type |
broadcast_uri | network_id | mode | state | strategy |
reserver_name | reservation_id |
device_id | update_time | isolation_uri | ip6_address | default_nic
| vm_type | created | removed | ip6_gateway |
ip6_cidr | secondary_ip | display_nic |
+-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
| 51 | 17f22eb2-5937-423e-9aeb-946e895310e4 | 5 |
06:41:2a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | 52b54070-d8bb-4f63-8ae5-6053d404dc7b |
0 | 2015-06-09 15:37:43 | NULL | NULL | 1 |
DomainRouter | 2015-06-09 12:01:02 | 2015-06-09 14:37:43 | NULL |
NULL | 0 | 1 |
| 61 | 94ff4fce-557a-4035-adb4-62df44db3057 | NULL | NULL
| 192.168.188.60 | NULL | NULL | NULL | NULL
| 204 | NULL | Reserved | PlaceHolder | NULL
| NULL | 0 | 2015-06-09
13:01:03 | NULL | NULL | 0 | DomainRouter |
2015-06-09 12:01:03 | NULL | NULL | NULL |
0 | 1 |
| 2988 | 43be41d8-a19e-4610-a27e-720aabc4da05 | 645 |
06:ba:5c:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | 8f442303-7a7b-4fd2-a33e-56f312f5f526 |
0 | 2015-07-09 14:24:40 | NULL | NULL | 1 |
DomainRouter | 2015-07-07 07:48:33 | 2015-07-09 13:24:40 | NULL |
NULL | 0 | 1 |
| 5358 | 18c1caed-00a9-4d58-b698-31ff186843e6 | 1262 |
06:66:3a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | dcf9c27f-4bf1-4ea1-870f-075eed81d021 |
0 | 2015-07-07 18:58:38 | NULL | NULL | 1 | User
| 2015-07-07 14:43:05 | 2015-07-07 17:58:38 | NULL | NULL
| 0 | 1 |
| 6208 | bfcd8921-1270-4ecb-b877-83ead6661d62 | 1461 |
06:0d:96:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | 245c5451-85a4-4ed1-b302-1075dd6bb064 |
0 | 2015-07-10 11:46:57 | NULL | NULL | 1 |
DomainRouter | 2015-07-09 14:30:43 | 2015-07-10 10:46:57 | NULL |
NULL | 0 | 1 |
| 6296 | 1622e49a-0008-4753-9b3a-deb76010aeef | 1482 |
06:88:1e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | ef8bcd64-083f-4ff8-bfa9-7948409d3e6d |
0 | 2015-07-09 16:40:34 | NULL | NULL | 1 | User
| 2015-07-09 14:40:51 | 2015-07-09 15:40:34 | NULL | NULL
| 0 | 1 |
| 7163 | e82597d6-090c-4745-a3da-db7ebbf042f9 | 1716 |
06:c5:56:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | 25d22aa0-da55-471a-976e-d1c595d2295d |
0 | 2015-07-10 11:51:07 | NULL | NULL | 1 |
DomainRouter | 2015-07-10 10:49:40 | 2015-07-10 10:51:07 | NULL |
NULL | 0 | 1 |
| 7178 | 0f07cda5-cd9d-4c2c-9b19-d2079c17eb7f | 1719 |
06:a7:04:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | 749b5fde-5b08-4e3d-aab2-2ce8296c9f56 |
0 | 2015-07-10 12:08:03 | NULL | NULL | 1 |
DomainRouter | 2015-07-10 10:53:02 | 2015-07-10 11:08:03 | NULL |
NULL | 0 | 1 |
| 7561 | acb34e0e-6aaa-456f-b78d-3bc878c9cf57 | 1743 |
06:fc:9a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Reserved | Start |
DirectPodBasedNetworkGuru | 9d4a595f-792f-45d9-a6d2-376905b03f87 |
0 | 2015-07-13 13:06:33 | NULL | NULL | 1 |
DomainRouter | 2015-07-10 12:19:03 | NULL | NULL |
NULL | 0 | 1 |
| 8731 | 5eaa2c45-9e87-458e-a0ee-0cef47ee56d2 | 2023 |
06:6f:34:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | bef0328f-3026-4713-9ab8-25f044964562 |
0 | 2015-07-13 12:28:08 | NULL | NULL | 1 | User
| 2015-07-13 09:56:19 | 2015-07-13 11:28:08 | NULL | NULL
| 0 | 1 |
| 9826 | 3fde86fd-98d5-4577-84cd-64cefb58a80f | 2317 |
06:2b:08:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | 2f16495c-dfa0-4fa0-8cc8-37ea471ace57 |
0 | 2015-07-13 15:20:56 | NULL | NULL | 1 | User
| 2015-07-13 13:38:44 | 2015-07-13 14:20:56 | NULL | NULL
| 0 | 1 |
| 10976 | fd3c75e0-03f4-491a-ab8a-56423f19b7a1 | 2619 |
06:65:70:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | b7ae777e-0343-4ef7-8f04-3bd6574e68b1 |
0 | 2015-07-14 08:51:40 | NULL | NULL | 1 | User
| 2015-07-13 16:34:52 | 2015-07-14 07:51:39 | NULL | NULL
| 0 | 1 |
| 12414 | 077d0612-516c-4f6e-bfab-e341bfe1c968 | 3384 |
06:4b:1e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | ae793f2f-4cb3-46be-b179-53a7aaf1aa8a |
0 | 2015-07-14 15:34:36 | NULL | NULL | 1 | User
| 2015-07-14 13:48:41 | 2015-07-14 14:34:36 | NULL | NULL
| 0 | 1 |
| 12722 | aba0a0dd-90cf-44c0-92e8-0e69b6d00347 | 3692 |
06:8a:9e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Deallocating | Start |
DirectPodBasedNetworkGuru | d934f096-337d-4705-9be7-38063191f055 |
0 | 2015-07-14 17:28:50 | NULL | NULL | 1 | User
| 2015-07-14 15:14:42 | 2015-07-14 16:28:50 | NULL | NULL
| 0 | 1 |
| 13200 | fb116e28-002c-4659-80bd-76a7972ca406 | 4170 |
06:98:b0:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
| vlan://untagged | 204 | Dhcp | Reserved | Start |
DirectPodBasedNetworkGuru | 6955c8dd-9fe4-4e04-ac7f-9c9fe48340cf |
0 | 2015-07-15 08:52:33 | NULL | NULL | 1 | User
| 2015-07-15 07:52:31 | NULL | NULL | NULL
| 0 | 1 |
+-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
15 rows in set (0.02 sec)
mysql> select * from user_ip_address where public_ip_address =
'192.168.188.60';
+------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
| id | uuid | account_id | domain_id |
public_ip_address | data_center_id | source_nat | allocated |
vlan_db_id | one_to_one_nat | vm_id | state | mac_address |
source_network_id | network_id | physical_network_id | is_system | vpc_id |
dnat_vmip | is_portable | display | removed | created |
+------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
| 2771 | 8751030c-c279-4334-8082-c036acabe00a | 2 | 1 |
192.168.188.60 | 1 | 0 | 2015-07-15 07:52:33 |
6 | 0 | NULL | Allocated | 600 |
204 | NULL | 200 | 0 | NULL | NULL |
0 | 1 | NULL | NULL |
+------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
1 row in set (0.00 sec)
mysql> select * from vm_instance where instance_name='i-2-4170-VM';
+------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
| id | name | uuid
| instance_name | state | vm_template_id | guest_os_id |
private_mac_address | private_ip_address | pod_id | data_center_id |
host_id | last_host_id | proxy_id | proxy_assign_time | vnc_password
| ha_enabled | limit_cpu_use |
update_count | update_time | created | removed | type |
vm_type | account_id | domain_id | service_offering_id | reservation_id
| hypervisor_type | disk_offering_id | owner | host_name
| display_name |
desired_state | dynamically_scalable | display_vm | power_state |
power_state_update_time | power_state_update_count | power_host |
+------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
| 4170 | VM-2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc |
2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc | i-2-4170-VM | Running |
217 | 144 | 06:98:b0:00:02:58 | 192.168.188.60 | 6 |
1 | 16 | 16 | NULL | NULL |
sdsdsdsdsdsdsdsdsdfdfdf3534r3f3r3f3f3r3f3f3f3f3f3f3f3f3 | 1 |
0 | 3 | 2015-07-15 07:53:56 | 2015-07-15 07:52:31 | NULL
| User | User | 2 | 1 | 93 |
6955c8dd-9fe4-4e04-ac7f-9c9fe48340cf | XenServer | NULL |
2 | VM-2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc |
e3274915-6666-4a91-a2be-071f2176d1d7 | NULL | 0
| 1 | PowerOn | 2015-07-15 07:56:07 |
3 | 16 |
+------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
1 row in set (0.02 sec)
mysql> select * from vm_instance where instance_name='r-1743-VM';
+------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
| id | name | uuid | instance_name |
state | vm_template_id | guest_os_id | private_mac_address |
private_ip_address | pod_id | data_center_id | host_id | last_host_id |
proxy_id | proxy_assign_time | vnc_password
| ha_enabled | limit_cpu_use | update_count | update_time
| created | removed | type | vm_type |
account_id | domain_id | service_offering_id | reservation_id
| hypervisor_type | disk_offering_id | owner | host_name |
display_name | desired_state | dynamically_scalable | display_vm |
power_state | power_state_update_time | power_state_update_count |
power_host |
+------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
| 1743 | r-1743-VM | c6a6def4-820f-4233-bb7c-fa3df61cb6c0 | r-1743-VM |
Running | 215 | 184 | 0e:00:a9:fe:01:c5 |
169.254.1.197 | 6 | 1 | 11 | 11 |
NULL | NULL |
sdsdsdsdsdsdsdsdsdfdfdf3534r3f3r3f3f3r3f3f3f3f3f3f3f3f3 | 1 |
0 | 8 | 2015-07-13 12:07:52 | 2015-07-10 12:19:03 | NULL
| DomainRouter | DomainRouter | 1 | 1 |
43 | 9d4a595f-792f-45d9-a6d2-376905b03f87 | XenServer |
NULL | NULL | NULL | NULL | NULL |
0 | 1 | PowerOn | 2015-07-15 07:13:05 |
3 | 11 |
+------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
1 row in set (0.02 sec)
Cheers!
Re: 4.5.1 Guest allocated same IP address as router
Posted by cs user <ac...@gmail.com>.
Hi Folks,
Seeing this with a second 4.5.1 environment, upgraded from 4.3. Basic
networking, 2 pods , 1 zone. The ip address of the second router is always
cleared and never reallocated on a network restart, which leads to vm's
being allocated the router ip address.
Cheers
On Thu, Jul 16, 2015 at 9:17 AM, cs user <ac...@gmail.com> wrote:
> Hi Folks,
>
> Bit more info here, It seems that after a network restart with the clean
> option, one of the router ip's is not being reserved correctly:
>
> mysql> select id,account_id,domain_id,public_ip_address,state,allocated
> from user_ip_address where public_ip_address in
> ('192.168.188.60','192.168.186.203');
>
> +------+------------+-----------+-------------------+-----------+---------------------+
> | id | account_id | domain_id | public_ip_address | state |
> allocated |
>
> +------+------------+-----------+-------------------+-----------+---------------------+
> | 1013 | 1 | 1 | 192.168.186.203 | Allocated |
> 2015-06-09 11:59:48 |
> | 2771 | NULL | NULL | 192.168.188.60 | Free | NULL
> |
>
> +------+------------+-----------+-------------------+-----------+---------------------+
> 2 rows in set (0.00 sec)
>
> The two addresses above are the two IP's of the router's in each pod. This
> is with basic networking. The second one has not been reserved correctly,
> and so instances are are being assigned the same IP.
>
> Cheers
>
>
>
>
> On Wed, Jul 15, 2015 at 10:51 AM, cs user <ac...@gmail.com> wrote:
>
>> Hi Folks,
>>
>> Been testing with 4.5.1, all looks fine. However we have just hit an
>> issue where a guest has been allocated the same IP as the eth0 address of
>> the router for the pod.
>>
>> Has anyone come across this issue before?
>>
>> Here is how the db looks (Apologies for the formatting)!
>>
>> mysql> select * from nics where ip4_address='192.168.188.60';
>>
>> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
>> | id | uuid | instance_id |
>> mac_address | ip4_address | netmask | gateway |
>> ip_type | broadcast_uri | network_id | mode | state | strategy
>> | reserver_name | reservation_id |
>> device_id | update_time | isolation_uri | ip6_address | default_nic
>> | vm_type | created | removed | ip6_gateway |
>> ip6_cidr | secondary_ip | display_nic |
>>
>> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
>> | 51 | 17f22eb2-5937-423e-9aeb-946e895310e4 | 5 |
>> 06:41:2a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | 52b54070-d8bb-4f63-8ae5-6053d404dc7b |
>> 0 | 2015-06-09 15:37:43 | NULL | NULL | 1 |
>> DomainRouter | 2015-06-09 12:01:02 | 2015-06-09 14:37:43 | NULL |
>> NULL | 0 | 1 |
>> | 61 | 94ff4fce-557a-4035-adb4-62df44db3057 | NULL | NULL
>> | 192.168.188.60 | NULL | NULL | NULL | NULL
>> | 204 | NULL | Reserved | PlaceHolder | NULL
>> | NULL | 0 | 2015-06-09
>> 13:01:03 | NULL | NULL | 0 | DomainRouter |
>> 2015-06-09 12:01:03 | NULL | NULL | NULL |
>> 0 | 1 |
>> | 2988 | 43be41d8-a19e-4610-a27e-720aabc4da05 | 645 |
>> 06:ba:5c:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | 8f442303-7a7b-4fd2-a33e-56f312f5f526 |
>> 0 | 2015-07-09 14:24:40 | NULL | NULL | 1 |
>> DomainRouter | 2015-07-07 07:48:33 | 2015-07-09 13:24:40 | NULL |
>> NULL | 0 | 1 |
>> | 5358 | 18c1caed-00a9-4d58-b698-31ff186843e6 | 1262 |
>> 06:66:3a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | dcf9c27f-4bf1-4ea1-870f-075eed81d021 |
>> 0 | 2015-07-07 18:58:38 | NULL | NULL | 1 | User
>> | 2015-07-07 14:43:05 | 2015-07-07 17:58:38 | NULL | NULL
>> | 0 | 1 |
>> | 6208 | bfcd8921-1270-4ecb-b877-83ead6661d62 | 1461 |
>> 06:0d:96:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | 245c5451-85a4-4ed1-b302-1075dd6bb064 |
>> 0 | 2015-07-10 11:46:57 | NULL | NULL | 1 |
>> DomainRouter | 2015-07-09 14:30:43 | 2015-07-10 10:46:57 | NULL |
>> NULL | 0 | 1 |
>> | 6296 | 1622e49a-0008-4753-9b3a-deb76010aeef | 1482 |
>> 06:88:1e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | ef8bcd64-083f-4ff8-bfa9-7948409d3e6d |
>> 0 | 2015-07-09 16:40:34 | NULL | NULL | 1 | User
>> | 2015-07-09 14:40:51 | 2015-07-09 15:40:34 | NULL | NULL
>> | 0 | 1 |
>> | 7163 | e82597d6-090c-4745-a3da-db7ebbf042f9 | 1716 |
>> 06:c5:56:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | 25d22aa0-da55-471a-976e-d1c595d2295d |
>> 0 | 2015-07-10 11:51:07 | NULL | NULL | 1 |
>> DomainRouter | 2015-07-10 10:49:40 | 2015-07-10 10:51:07 | NULL |
>> NULL | 0 | 1 |
>> | 7178 | 0f07cda5-cd9d-4c2c-9b19-d2079c17eb7f | 1719 |
>> 06:a7:04:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | 749b5fde-5b08-4e3d-aab2-2ce8296c9f56 |
>> 0 | 2015-07-10 12:08:03 | NULL | NULL | 1 |
>> DomainRouter | 2015-07-10 10:53:02 | 2015-07-10 11:08:03 | NULL |
>> NULL | 0 | 1 |
>> | 7561 | acb34e0e-6aaa-456f-b78d-3bc878c9cf57 | 1743 |
>> 06:fc:9a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Reserved | Start |
>> DirectPodBasedNetworkGuru | 9d4a595f-792f-45d9-a6d2-376905b03f87 |
>> 0 | 2015-07-13 13:06:33 | NULL | NULL | 1 |
>> DomainRouter | 2015-07-10 12:19:03 | NULL | NULL |
>> NULL | 0 | 1 |
>> | 8731 | 5eaa2c45-9e87-458e-a0ee-0cef47ee56d2 | 2023 |
>> 06:6f:34:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | bef0328f-3026-4713-9ab8-25f044964562 |
>> 0 | 2015-07-13 12:28:08 | NULL | NULL | 1 | User
>> | 2015-07-13 09:56:19 | 2015-07-13 11:28:08 | NULL | NULL
>> | 0 | 1 |
>> | 9826 | 3fde86fd-98d5-4577-84cd-64cefb58a80f | 2317 |
>> 06:2b:08:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | 2f16495c-dfa0-4fa0-8cc8-37ea471ace57 |
>> 0 | 2015-07-13 15:20:56 | NULL | NULL | 1 | User
>> | 2015-07-13 13:38:44 | 2015-07-13 14:20:56 | NULL | NULL
>> | 0 | 1 |
>> | 10976 | fd3c75e0-03f4-491a-ab8a-56423f19b7a1 | 2619 |
>> 06:65:70:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | b7ae777e-0343-4ef7-8f04-3bd6574e68b1 |
>> 0 | 2015-07-14 08:51:40 | NULL | NULL | 1 | User
>> | 2015-07-13 16:34:52 | 2015-07-14 07:51:39 | NULL | NULL
>> | 0 | 1 |
>> | 12414 | 077d0612-516c-4f6e-bfab-e341bfe1c968 | 3384 |
>> 06:4b:1e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | ae793f2f-4cb3-46be-b179-53a7aaf1aa8a |
>> 0 | 2015-07-14 15:34:36 | NULL | NULL | 1 | User
>> | 2015-07-14 13:48:41 | 2015-07-14 14:34:36 | NULL | NULL
>> | 0 | 1 |
>> | 12722 | aba0a0dd-90cf-44c0-92e8-0e69b6d00347 | 3692 |
>> 06:8a:9e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
>> DirectPodBasedNetworkGuru | d934f096-337d-4705-9be7-38063191f055 |
>> 0 | 2015-07-14 17:28:50 | NULL | NULL | 1 | User
>> | 2015-07-14 15:14:42 | 2015-07-14 16:28:50 | NULL | NULL
>> | 0 | 1 |
>> | 13200 | fb116e28-002c-4659-80bd-76a7972ca406 | 4170 |
>> 06:98:b0:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
>> | vlan://untagged | 204 | Dhcp | Reserved | Start |
>> DirectPodBasedNetworkGuru | 6955c8dd-9fe4-4e04-ac7f-9c9fe48340cf |
>> 0 | 2015-07-15 08:52:33 | NULL | NULL | 1 | User
>> | 2015-07-15 07:52:31 | NULL | NULL | NULL
>> | 0 | 1 |
>>
>> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
>> 15 rows in set (0.02 sec)
>>
>>
>> mysql> select * from user_ip_address where public_ip_address =
>> '192.168.188.60';
>>
>> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
>> | id | uuid | account_id | domain_id |
>> public_ip_address | data_center_id | source_nat | allocated |
>> vlan_db_id | one_to_one_nat | vm_id | state | mac_address |
>> source_network_id | network_id | physical_network_id | is_system | vpc_id |
>> dnat_vmip | is_portable | display | removed | created |
>>
>> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
>> | 2771 | 8751030c-c279-4334-8082-c036acabe00a | 2 | 1 |
>> 192.168.188.60 | 1 | 0 | 2015-07-15 07:52:33 |
>> 6 | 0 | NULL | Allocated | 600 |
>> 204 | NULL | 200 | 0 | NULL | NULL |
>> 0 | 1 | NULL | NULL |
>>
>> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
>> 1 row in set (0.00 sec)
>>
>>
>> mysql> select * from vm_instance where instance_name='i-2-4170-VM';
>>
>> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
>> | id | name | uuid
>> | instance_name | state | vm_template_id | guest_os_id |
>> private_mac_address | private_ip_address | pod_id | data_center_id |
>> host_id | last_host_id | proxy_id | proxy_assign_time | vnc_password
>> | ha_enabled | limit_cpu_use |
>> update_count | update_time | created | removed | type |
>> vm_type | account_id | domain_id | service_offering_id | reservation_id
>> | hypervisor_type | disk_offering_id | owner | host_name
>> | display_name |
>> desired_state | dynamically_scalable | display_vm | power_state |
>> power_state_update_time | power_state_update_count | power_host |
>>
>> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
>> | 4170 | VM-2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc |
>> 2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc | i-2-4170-VM | Running |
>> 217 | 144 | 06:98:b0:00:02:58 | 192.168.188.60 | 6 |
>> 1 | 16 | 16 | NULL | NULL |
>> sdsdsdsdsdsdsdsdsdfdfdf3534r3f3r3f3f3r3f3f3f3f3f3f3f3f3 | 1 |
>> 0 | 3 | 2015-07-15 07:53:56 | 2015-07-15 07:52:31 | NULL
>> | User | User | 2 | 1 | 93 |
>> 6955c8dd-9fe4-4e04-ac7f-9c9fe48340cf | XenServer | NULL |
>> 2 | VM-2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc |
>> e3274915-6666-4a91-a2be-071f2176d1d7 | NULL | 0
>> | 1 | PowerOn | 2015-07-15 07:56:07 |
>> 3 | 16 |
>>
>> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
>> 1 row in set (0.02 sec)
>>
>>
>> mysql> select * from vm_instance where instance_name='r-1743-VM';
>>
>> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
>> | id | name | uuid | instance_name
>> | state | vm_template_id | guest_os_id | private_mac_address |
>> private_ip_address | pod_id | data_center_id | host_id | last_host_id |
>> proxy_id | proxy_assign_time | vnc_password
>> | ha_enabled | limit_cpu_use | update_count | update_time
>> | created | removed | type | vm_type |
>> account_id | domain_id | service_offering_id | reservation_id
>> | hypervisor_type | disk_offering_id | owner | host_name |
>> display_name | desired_state | dynamically_scalable | display_vm |
>> power_state | power_state_update_time | power_state_update_count |
>> power_host |
>>
>> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
>> | 1743 | r-1743-VM | c6a6def4-820f-4233-bb7c-fa3df61cb6c0 | r-1743-VM
>> | Running | 215 | 184 | 0e:00:a9:fe:01:c5 |
>> 169.254.1.197 | 6 | 1 | 11 | 11 |
>> NULL | NULL |
>> sdsdsdsdsdsdsdsdsdfdfdf3534r3f3r3f3f3r3f3f3f3f3f3f3f3f3 | 1 |
>> 0 | 8 | 2015-07-13 12:07:52 | 2015-07-10 12:19:03 | NULL
>> | DomainRouter | DomainRouter | 1 | 1 |
>> 43 | 9d4a595f-792f-45d9-a6d2-376905b03f87 | XenServer |
>> NULL | NULL | NULL | NULL | NULL |
>> 0 | 1 | PowerOn | 2015-07-15 07:13:05 |
>> 3 | 11 |
>>
>> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
>> 1 row in set (0.02 sec)
>>
>> Cheers!
>>
>>
>
Re: 4.5.1 Guest allocated same IP address as router
Posted by cs user <ac...@gmail.com>.
Hi Folks,
Bit more info here, It seems that after a network restart with the clean
option, one of the router ip's is not being reserved correctly:
mysql> select id,account_id,domain_id,public_ip_address,state,allocated
from user_ip_address where public_ip_address in
('192.168.188.60','192.168.186.203');
+------+------------+-----------+-------------------+-----------+---------------------+
| id | account_id | domain_id | public_ip_address | state | allocated
|
+------+------------+-----------+-------------------+-----------+---------------------+
| 1013 | 1 | 1 | 192.168.186.203 | Allocated |
2015-06-09 11:59:48 |
| 2771 | NULL | NULL | 192.168.188.60 | Free | NULL
|
+------+------------+-----------+-------------------+-----------+---------------------+
2 rows in set (0.00 sec)
The two addresses above are the two IP's of the router's in each pod. This
is with basic networking. The second one has not been reserved correctly,
and so instances are are being assigned the same IP.
Cheers
On Wed, Jul 15, 2015 at 10:51 AM, cs user <ac...@gmail.com> wrote:
> Hi Folks,
>
> Been testing with 4.5.1, all looks fine. However we have just hit an issue
> where a guest has been allocated the same IP as the eth0 address of the
> router for the pod.
>
> Has anyone come across this issue before?
>
> Here is how the db looks (Apologies for the formatting)!
>
> mysql> select * from nics where ip4_address='192.168.188.60';
>
> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
> | id | uuid | instance_id | mac_address
> | ip4_address | netmask | gateway | ip_type |
> broadcast_uri | network_id | mode | state | strategy |
> reserver_name | reservation_id |
> device_id | update_time | isolation_uri | ip6_address | default_nic
> | vm_type | created | removed | ip6_gateway |
> ip6_cidr | secondary_ip | display_nic |
>
> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
> | 51 | 17f22eb2-5937-423e-9aeb-946e895310e4 | 5 |
> 06:41:2a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 52b54070-d8bb-4f63-8ae5-6053d404dc7b |
> 0 | 2015-06-09 15:37:43 | NULL | NULL | 1 |
> DomainRouter | 2015-06-09 12:01:02 | 2015-06-09 14:37:43 | NULL |
> NULL | 0 | 1 |
> | 61 | 94ff4fce-557a-4035-adb4-62df44db3057 | NULL | NULL
> | 192.168.188.60 | NULL | NULL | NULL | NULL
> | 204 | NULL | Reserved | PlaceHolder | NULL
> | NULL | 0 | 2015-06-09
> 13:01:03 | NULL | NULL | 0 | DomainRouter |
> 2015-06-09 12:01:03 | NULL | NULL | NULL |
> 0 | 1 |
> | 2988 | 43be41d8-a19e-4610-a27e-720aabc4da05 | 645 |
> 06:ba:5c:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 8f442303-7a7b-4fd2-a33e-56f312f5f526 |
> 0 | 2015-07-09 14:24:40 | NULL | NULL | 1 |
> DomainRouter | 2015-07-07 07:48:33 | 2015-07-09 13:24:40 | NULL |
> NULL | 0 | 1 |
> | 5358 | 18c1caed-00a9-4d58-b698-31ff186843e6 | 1262 |
> 06:66:3a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | dcf9c27f-4bf1-4ea1-870f-075eed81d021 |
> 0 | 2015-07-07 18:58:38 | NULL | NULL | 1 | User
> | 2015-07-07 14:43:05 | 2015-07-07 17:58:38 | NULL | NULL
> | 0 | 1 |
> | 6208 | bfcd8921-1270-4ecb-b877-83ead6661d62 | 1461 |
> 06:0d:96:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 245c5451-85a4-4ed1-b302-1075dd6bb064 |
> 0 | 2015-07-10 11:46:57 | NULL | NULL | 1 |
> DomainRouter | 2015-07-09 14:30:43 | 2015-07-10 10:46:57 | NULL |
> NULL | 0 | 1 |
> | 6296 | 1622e49a-0008-4753-9b3a-deb76010aeef | 1482 |
> 06:88:1e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | ef8bcd64-083f-4ff8-bfa9-7948409d3e6d |
> 0 | 2015-07-09 16:40:34 | NULL | NULL | 1 | User
> | 2015-07-09 14:40:51 | 2015-07-09 15:40:34 | NULL | NULL
> | 0 | 1 |
> | 7163 | e82597d6-090c-4745-a3da-db7ebbf042f9 | 1716 |
> 06:c5:56:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 25d22aa0-da55-471a-976e-d1c595d2295d |
> 0 | 2015-07-10 11:51:07 | NULL | NULL | 1 |
> DomainRouter | 2015-07-10 10:49:40 | 2015-07-10 10:51:07 | NULL |
> NULL | 0 | 1 |
> | 7178 | 0f07cda5-cd9d-4c2c-9b19-d2079c17eb7f | 1719 |
> 06:a7:04:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 749b5fde-5b08-4e3d-aab2-2ce8296c9f56 |
> 0 | 2015-07-10 12:08:03 | NULL | NULL | 1 |
> DomainRouter | 2015-07-10 10:53:02 | 2015-07-10 11:08:03 | NULL |
> NULL | 0 | 1 |
> | 7561 | acb34e0e-6aaa-456f-b78d-3bc878c9cf57 | 1743 |
> 06:fc:9a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Reserved | Start |
> DirectPodBasedNetworkGuru | 9d4a595f-792f-45d9-a6d2-376905b03f87 |
> 0 | 2015-07-13 13:06:33 | NULL | NULL | 1 |
> DomainRouter | 2015-07-10 12:19:03 | NULL | NULL |
> NULL | 0 | 1 |
> | 8731 | 5eaa2c45-9e87-458e-a0ee-0cef47ee56d2 | 2023 |
> 06:6f:34:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | bef0328f-3026-4713-9ab8-25f044964562 |
> 0 | 2015-07-13 12:28:08 | NULL | NULL | 1 | User
> | 2015-07-13 09:56:19 | 2015-07-13 11:28:08 | NULL | NULL
> | 0 | 1 |
> | 9826 | 3fde86fd-98d5-4577-84cd-64cefb58a80f | 2317 |
> 06:2b:08:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 2f16495c-dfa0-4fa0-8cc8-37ea471ace57 |
> 0 | 2015-07-13 15:20:56 | NULL | NULL | 1 | User
> | 2015-07-13 13:38:44 | 2015-07-13 14:20:56 | NULL | NULL
> | 0 | 1 |
> | 10976 | fd3c75e0-03f4-491a-ab8a-56423f19b7a1 | 2619 |
> 06:65:70:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | b7ae777e-0343-4ef7-8f04-3bd6574e68b1 |
> 0 | 2015-07-14 08:51:40 | NULL | NULL | 1 | User
> | 2015-07-13 16:34:52 | 2015-07-14 07:51:39 | NULL | NULL
> | 0 | 1 |
> | 12414 | 077d0612-516c-4f6e-bfab-e341bfe1c968 | 3384 |
> 06:4b:1e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | ae793f2f-4cb3-46be-b179-53a7aaf1aa8a |
> 0 | 2015-07-14 15:34:36 | NULL | NULL | 1 | User
> | 2015-07-14 13:48:41 | 2015-07-14 14:34:36 | NULL | NULL
> | 0 | 1 |
> | 12722 | aba0a0dd-90cf-44c0-92e8-0e69b6d00347 | 3692 |
> 06:8a:9e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | d934f096-337d-4705-9be7-38063191f055 |
> 0 | 2015-07-14 17:28:50 | NULL | NULL | 1 | User
> | 2015-07-14 15:14:42 | 2015-07-14 16:28:50 | NULL | NULL
> | 0 | 1 |
> | 13200 | fb116e28-002c-4659-80bd-76a7972ca406 | 4170 |
> 06:98:b0:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Reserved | Start |
> DirectPodBasedNetworkGuru | 6955c8dd-9fe4-4e04-ac7f-9c9fe48340cf |
> 0 | 2015-07-15 08:52:33 | NULL | NULL | 1 | User
> | 2015-07-15 07:52:31 | NULL | NULL | NULL
> | 0 | 1 |
>
> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
> 15 rows in set (0.02 sec)
>
>
> mysql> select * from user_ip_address where public_ip_address =
> '192.168.188.60';
>
> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
> | id | uuid | account_id | domain_id |
> public_ip_address | data_center_id | source_nat | allocated |
> vlan_db_id | one_to_one_nat | vm_id | state | mac_address |
> source_network_id | network_id | physical_network_id | is_system | vpc_id |
> dnat_vmip | is_portable | display | removed | created |
>
> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
> | 2771 | 8751030c-c279-4334-8082-c036acabe00a | 2 | 1 |
> 192.168.188.60 | 1 | 0 | 2015-07-15 07:52:33 |
> 6 | 0 | NULL | Allocated | 600 |
> 204 | NULL | 200 | 0 | NULL | NULL |
> 0 | 1 | NULL | NULL |
>
> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
> 1 row in set (0.00 sec)
>
>
> mysql> select * from vm_instance where instance_name='i-2-4170-VM';
>
> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> | id | name | uuid
> | instance_name | state | vm_template_id | guest_os_id |
> private_mac_address | private_ip_address | pod_id | data_center_id |
> host_id | last_host_id | proxy_id | proxy_assign_time | vnc_password
> | ha_enabled | limit_cpu_use |
> update_count | update_time | created | removed | type |
> vm_type | account_id | domain_id | service_offering_id | reservation_id
> | hypervisor_type | disk_offering_id | owner | host_name
> | display_name |
> desired_state | dynamically_scalable | display_vm | power_state |
> power_state_update_time | power_state_update_count | power_host |
>
> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> | 4170 | VM-2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc |
> 2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc | i-2-4170-VM | Running |
> 217 | 144 | 06:98:b0:00:02:58 | 192.168.188.60 | 6 |
> 1 | 16 | 16 | NULL | NULL |
> sdsdsdsdsdsdsdsdsdfdfdf3534r3f3r3f3f3r3f3f3f3f3f3f3f3f3 | 1 |
> 0 | 3 | 2015-07-15 07:53:56 | 2015-07-15 07:52:31 | NULL
> | User | User | 2 | 1 | 93 |
> 6955c8dd-9fe4-4e04-ac7f-9c9fe48340cf | XenServer | NULL |
> 2 | VM-2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc |
> e3274915-6666-4a91-a2be-071f2176d1d7 | NULL | 0
> | 1 | PowerOn | 2015-07-15 07:56:07 |
> 3 | 16 |
>
> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> 1 row in set (0.02 sec)
>
>
> mysql> select * from vm_instance where instance_name='r-1743-VM';
>
> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> | id | name | uuid | instance_name
> | state | vm_template_id | guest_os_id | private_mac_address |
> private_ip_address | pod_id | data_center_id | host_id | last_host_id |
> proxy_id | proxy_assign_time | vnc_password
> | ha_enabled | limit_cpu_use | update_count | update_time
> | created | removed | type | vm_type |
> account_id | domain_id | service_offering_id | reservation_id
> | hypervisor_type | disk_offering_id | owner | host_name |
> display_name | desired_state | dynamically_scalable | display_vm |
> power_state | power_state_update_time | power_state_update_count |
> power_host |
>
> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> | 1743 | r-1743-VM | c6a6def4-820f-4233-bb7c-fa3df61cb6c0 | r-1743-VM
> | Running | 215 | 184 | 0e:00:a9:fe:01:c5 |
> 169.254.1.197 | 6 | 1 | 11 | 11 |
> NULL | NULL |
> sdsdsdsdsdsdsdsdsdfdfdf3534r3f3r3f3f3r3f3f3f3f3f3f3f3f3 | 1 |
> 0 | 8 | 2015-07-13 12:07:52 | 2015-07-10 12:19:03 | NULL
> | DomainRouter | DomainRouter | 1 | 1 |
> 43 | 9d4a595f-792f-45d9-a6d2-376905b03f87 | XenServer |
> NULL | NULL | NULL | NULL | NULL |
> 0 | 1 | PowerOn | 2015-07-15 07:13:05 |
> 3 | 11 |
>
> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> 1 row in set (0.02 sec)
>
> Cheers!
>
>