You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafficcontrol.apache.org by da...@apache.org on 2016/11/14 17:07:13 UTC

[10/53] [abbrv] incubator-trafficcontrol git commit: fixing integration fixtures.

http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/af0c115e/traffic_ops/app/lib/Fixtures/Integration/Server.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Fixtures/Integration/Server.pm b/traffic_ops/app/lib/Fixtures/Integration/Server.pm
index 6723d04..20f0588 100644
--- a/traffic_ops/app/lib/Fixtures/Integration/Server.pm
+++ b/traffic_ops/app/lib/Fixtures/Integration/Server.pm
@@ -33,8 +33,8 @@ my %definition_for = (
 			host_name => 'atsec-chi-00',
 			ilo_ip_gateway => '172.16.2.1',
 			interface_name => 'bond0',
-			phys_location => '5',
-			cachegroup => '93',
+			phys_location => '3',
+			cachegroup => '9',
 			domain_name => 'chi.kabletown.net',
 			ip6_gateway => '2033:D0D0:3300::2:1',
 			rack => 'RR 119.02',
@@ -75,13 +75,13 @@ my %definition_for = (
 			type => '13',
 			ilo_ip_netmask => '255.255.255.0',
 			ip6_gateway => '2033:D0D0:3300::2:1',
-			phys_location => '5',
+			phys_location => '3',
 			xmpp_passwd => 'X',
 			ip_netmask => '255.255.255.0',
 			rack => 'RR 119.02',
 			router_port_name => '2',
 			status => '1',
-			cachegroup => '93',
+			cachegroup => '9',
 			cdn_id => '1',
 			ilo_ip_address => '172.16.2.7',
 			ilo_password => '',
@@ -114,7 +114,7 @@ my %definition_for = (
 			ilo_username => '',
 			ip6_address => '2033:D0D0:3300::2:4/64',
 			mgmt_ip_gateway => '',
-			cachegroup => '93',
+			cachegroup => '9',
 			ilo_password => '',
 			last_updated => '2015-12-10 15:44:37',
 			router_port_name => '2',
@@ -127,7 +127,7 @@ my %definition_for = (
 			ip_address => '10.10.2.4',
 			ip_netmask => '255.255.255.0',
 			mgmt_ip_address => '',
-			phys_location => '5',
+			phys_location => '3',
 			router_host_name => 'rtr-chi.kabletown.net',
 			upd_pending => '0',
 			mgmt_ip_netmask => '',
@@ -149,7 +149,7 @@ my %definition_for = (
 			ilo_ip_gateway => '172.16.2.1',
 			ip_address => '10.10.2.5',
 			mgmt_ip_address => '',
-			phys_location => '5',
+			phys_location => '3',
 			ip6_gateway => '2033:D0D0:3300::2:1',
 			rack => 'RR 119.02',
 			ilo_ip_address => '172.16.2.9',
@@ -160,7 +160,7 @@ my %definition_for = (
 			ilo_username => '',
 			router_port_name => '2',
 			type => '13',
-			cachegroup => '93',
+			cachegroup => '9',
 			domain_name => 'chi.kabletown.net',
 			interface_name => 'bond0',
 			ip_gateway => '10.10.2.1',
@@ -186,7 +186,7 @@ my %definition_for = (
 			profile => '7',
 			domain_name => 'chi.kabletown.net',
 			mgmt_ip_gateway => '',
-			phys_location => '6',
+			phys_location => '4',
 			interface_name => 'bond0',
 			ip6_address => '2033:D0D0:3300::2:6/64',
 			ip_netmask => '255.255.255.0',
@@ -198,7 +198,7 @@ my %definition_for = (
 			ip_gateway => '10.10.2.1',
 			rack => 'RR 119.02',
 			type => '13',
-			cachegroup => '93',
+			cachegroup => '9',
 			ilo_ip_netmask => '255.255.255.0',
 			ilo_password => '',
 			ilo_username => '',
@@ -223,7 +223,7 @@ my %definition_for = (
 			ip_netmask => '255.255.255.0',
 			mgmt_ip_address => '',
 			status => '1',
-			cachegroup => '93',
+			cachegroup => '9',
 			ilo_username => '',
 			xmpp_id => 'atsec-chi-05-dummyxmpp',
 			profile => '7',
@@ -233,7 +233,7 @@ my %definition_for = (
 			xmpp_passwd => 'X',
 			ilo_password => '',
 			ip_address => '10.10.2.7',
-			phys_location => '6',
+			phys_location => '4',
 			rack => 'RR 119.02',
 			ip6_address => '2033:D0D0:3300::2:7/64',
 			mgmt_ip_gateway => '',
@@ -254,7 +254,7 @@ my %definition_for = (
 		using => {
 			host_name => 'atsec-chi-06',
 			type => '13',
-			cachegroup => '93',
+			cachegroup => '9',
 			ip_address => '10.10.2.8',
 			mgmt_ip_address => '',
 			router_port_name => '2',
@@ -264,7 +264,7 @@ my %definition_for = (
 			mgmt_ip_netmask => '',
 			interface_mtu => '9000',
 			interface_name => 'bond0',
-			phys_location => '6',
+			phys_location => '4',
 			mgmt_ip_gateway => '',
 			xmpp_passwd => 'X',
 			ilo_password => '',
@@ -295,12 +295,12 @@ my %definition_for = (
 			xmpp_id => 'atsec-chi-07-dummyxmpp',
 			xmpp_passwd => 'X',
 			ilo_username => '',
-			phys_location => '6',
+			phys_location => '4',
 			profile => '7',
 			tcp_port => '80',
 			upd_pending => '0',
 			mgmt_ip_netmask => '',
-			cachegroup => '93',
+			cachegroup => '9',
 			ilo_password => '',
 			interface_mtu => '9000',
 			interface_name => 'bond0',
@@ -337,13 +337,13 @@ my %definition_for = (
 			ip_gateway => '10.10.2.1',
 			ilo_username => '',
 			last_updated => '2015-12-10 15:44:37',
-			phys_location => '6',
+			phys_location => '4',
 			status => '1',
 			ip_address => '10.10.2.10',
 			upd_pending => '0',
 			rack => 'RR 119.02',
 			tcp_port => '80',
-			cachegroup => '93',
+			cachegroup => '9',
 			interface_mtu => '9000',
 			ip6_gateway => '2033:D0D0:3300::2:1',
 			mgmt_ip_address => '',
@@ -382,9 +382,9 @@ my %definition_for = (
 			tcp_port => '80',
 			ip_gateway => '10.10.5.1',
 			rack => 'RR 119.02',
-			phys_location => '11',
+			phys_location => '5',
 			profile => '5',
-			cachegroup => '96',
+			cachegroup => '8',
 			xmpp_passwd => 'X',
 			ip6_address => '2033:D0D0:3300::5:2/64',
 			last_updated => '2015-12-10 15:44:37',
@@ -404,7 +404,7 @@ my %definition_for = (
 			domain_name => 'den.kabletown.net',
 			ip6_gateway => '2033:D0D0:3300::5:1',
 			xmpp_passwd => 'X',
-			cachegroup => '96',
+			cachegroup => '8',
 			ilo_password => '',
 			interface_mtu => '9000',
 			ip6_address => '2033:D0D0:3300::5:3/64',
@@ -428,7 +428,7 @@ my %definition_for = (
 			interface_name => 'bond0',
 			ip_netmask => '255.255.255.0',
 			mgmt_ip_address => '',
-			phys_location => '11',
+			phys_location => '5',
 			tcp_port => '80',
 			ip_gateway => '10.10.5.1',
 		},
@@ -452,9 +452,9 @@ my %definition_for = (
 			upd_pending => '0',
 			status => '1',
 			domain_name => 'den.kabletown.net',
-			phys_location => '11',
+			phys_location => '5',
 			profile => '5',
-			cachegroup => '96',
+			cachegroup => '8',
 			cdn_id => '1',
 			ip6_gateway => '2033:D0D0:3300::5:1',
 			xmpp_id => 'atsec-den-02-dummyxmpp',
@@ -487,7 +487,7 @@ my %definition_for = (
 			type => '13',
 			ip6_gateway => '2033:D0D0:3300::5:1',
 			ip_netmask => '255.255.255.0',
-			phys_location => '11',
+			phys_location => '5',
 			profile => '5',
 			upd_pending => '0',
 			ilo_ip_gateway => '172.16.5.1',
@@ -496,7 +496,7 @@ my %definition_for = (
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_gateway => '',
 			router_host_name => 'rtr-den.kabletown.net',
-			cachegroup => '96',
+			cachegroup => '8',
 			ilo_ip_netmask => '255.255.255.0',
 			interface_mtu => '9000',
 			mgmt_ip_address => '',
@@ -521,9 +521,9 @@ my %definition_for = (
 			upd_pending => '0',
 			cdn_id => '2',
 			ip_netmask => '255.255.255.0',
-			cachegroup => '96',
+			cachegroup => '8',
 			type => '13',
-			phys_location => '12',
+			phys_location => '6',
 			interface_name => 'bond0',
 			ilo_ip_netmask => '255.255.255.0',
 			ilo_ip_gateway => '172.16.5.1',
@@ -549,7 +549,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-den-05',
-			cachegroup => '96',
+			cachegroup => '8',
 			ilo_username => '',
 			interface_name => 'bond0',
 			ip_address => '10.10.5.7',
@@ -577,7 +577,7 @@ my %definition_for = (
 			ip6_address => '2033:D0D0:3300::5:7/64',
 			mgmt_ip_address => '',
 			mgmt_ip_netmask => '',
-			phys_location => '12',
+			phys_location => '6',
 			rack => 'RR 119.02',
 		},
 	},
@@ -597,11 +597,11 @@ my %definition_for = (
 			ip6_gateway => '2033:D0D0:3300::5:1',
 			mgmt_ip_address => '',
 			mgmt_ip_gateway => '',
-			phys_location => '12',
+			phys_location => '6',
 			status => '1',
 			upd_pending => '0',
 			xmpp_id => 'atsec-den-06-dummyxmpp',
-			cachegroup => '96',
+			cachegroup => '8',
 			ilo_ip_address => '172.16.5.12',
 			interface_name => 'bond0',
 			ip_gateway => '10.10.5.1',
@@ -635,7 +635,7 @@ my %definition_for = (
 			ip_netmask => '255.255.255.0',
 			mgmt_ip_gateway => '',
 			status => '1',
-			cachegroup => '96',
+			cachegroup => '8',
 			ip_address => '10.10.5.9',
 			type => '13',
 			ilo_password => '',
@@ -650,7 +650,7 @@ my %definition_for = (
 			router_host_name => 'rtr-den.kabletown.net',
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_netmask => '',
-			phys_location => '12',
+			phys_location => '6',
 			upd_pending => '0',
 			ilo_ip_gateway => '172.16.5.1',
 		},
@@ -667,14 +667,14 @@ my %definition_for = (
 			rack => 'RR 119.02',
 			cdn_id => '2',
 			ip6_gateway => '2033:D0D0:3300::5:1',
-			phys_location => '12',
+			phys_location => '6',
 			domain_name => 'den.kabletown.net',
 			interface_mtu => '9000',
 			ilo_password => '',
 			interface_name => 'bond0',
 			router_host_name => 'rtr-den.kabletown.net',
 			status => '1',
-			cachegroup => '96',
+			cachegroup => '8',
 			ilo_ip_netmask => '255.255.255.0',
 			mgmt_ip_gateway => '',
 			profile => '7',
@@ -707,7 +707,7 @@ my %definition_for = (
 			router_host_name => 'rtr-hou.kabletown.net',
 			status => '1',
 			upd_pending => '0',
-			cachegroup => '94',
+			cachegroup => '12',
 			ilo_ip_address => '172.16.3.6',
 			mgmt_ip_address => '',
 			cdn_id => '1',
@@ -734,7 +734,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-hou-01',
-			cachegroup => '94',
+			cachegroup => '12',
 			ilo_password => '',
 			interface_name => 'bond0',
 			ip_gateway => '10.10.3.1',
@@ -799,7 +799,7 @@ my %definition_for = (
 			ip_gateway => '10.10.3.1',
 			ip_netmask => '255.255.255.0',
 			interface_mtu => '9000',
-			cachegroup => '94',
+			cachegroup => '12',
 			ilo_username => '',
 		},
 	},
@@ -818,7 +818,7 @@ my %definition_for = (
 			interface_mtu => '9000',
 			status => '1',
 			xmpp_passwd => 'X',
-			cachegroup => '94',
+			cachegroup => '12',
 			mgmt_ip_netmask => '',
 			router_port_name => '3',
 			ip_address => '10.10.3.5',
@@ -865,7 +865,7 @@ my %definition_for = (
 			router_host_name => 'rtr-hou.kabletown.net',
 			router_port_name => '3',
 			mgmt_ip_address => '',
-			cachegroup => '94',
+			cachegroup => '12',
 			ip_gateway => '10.10.3.1',
 			ip_netmask => '255.255.255.0',
 			last_updated => '2015-12-10 15:44:37',
@@ -886,7 +886,7 @@ my %definition_for = (
 			ip6_gateway => '2033:D0D0:3300::3:1',
 			profile => '7',
 			rack => 'RR 119.02',
-			cachegroup => '94',
+			cachegroup => '12',
 			ilo_ip_gateway => '172.16.3.1',
 			interface_mtu => '9000',
 			ip_gateway => '10.10.3.1',
@@ -940,7 +940,7 @@ my %definition_for = (
 			profile => '7',
 			ilo_username => '',
 			rack => 'RR 119.02',
-			cachegroup => '94',
+			cachegroup => '12',
 			domain_name => 'hou.kabletown.net',
 			xmpp_passwd => 'X',
 			ip6_address => '2033:D0D0:3300::3:8/64',
@@ -962,7 +962,7 @@ my %definition_for = (
 			ip_address => '10.10.3.9',
 			ip6_gateway => '2033:D0D0:3300::3:1',
 			xmpp_id => 'atsec-hou-07-dummyxmpp',
-			cachegroup => '94',
+			cachegroup => '12',
 			ilo_ip_netmask => '255.255.255.0',
 			ip_gateway => '10.10.3.1',
 			ip_netmask => '255.255.255.0',
@@ -1021,7 +1021,7 @@ my %definition_for = (
 			rack => 'RR 119.02',
 			profile => '7',
 			router_port_name => '3',
-			cachegroup => '94',
+			cachegroup => '12',
 			phys_location => '8',
 		},
 	},
@@ -1033,7 +1033,7 @@ my %definition_for = (
 			status => '1',
 			ilo_ip_netmask => '255.255.255.0',
 			mgmt_ip_address => '',
-			phys_location => '3',
+			phys_location => '9',
 			profile => '5',
 			router_host_name => 'rtr-lax.kabletown.net',
 			tcp_port => '80',
@@ -1044,7 +1044,7 @@ my %definition_for = (
 			interface_mtu => '9000',
 			ip_netmask => '255.255.255.0',
 			mgmt_ip_gateway => '',
-			cachegroup => '92',
+			cachegroup => '7',
 			cdn_id => '1',
 			rack => 'RR 119.02',
 			ilo_ip_gateway => '172.16.1.1',
@@ -1093,10 +1093,10 @@ my %definition_for = (
 			tcp_port => '80',
 			type => '13',
 			ilo_password => '',
-			phys_location => '3',
+			phys_location => '9',
 			router_host_name => 'rtr-lax.kabletown.net',
 			domain_name => 'lax.kabletown.net',
-			cachegroup => '92',
+			cachegroup => '7',
 		},
 	},
 	## id => 30
@@ -1112,7 +1112,7 @@ my %definition_for = (
 			ip6_gateway => '2033:D0D0:3300::1:1',
 			profile => '5',
 			xmpp_id => 'atsec-lax-02-dummyxmpp',
-			cachegroup => '92',
+			cachegroup => '7',
 			ilo_ip_netmask => '255.255.255.0',
 			interface_mtu => '9000',
 			ip6_address => '2033:D0D0:3300::1:4/64',
@@ -1132,7 +1132,7 @@ my %definition_for = (
 			cdn_id => '1',
 			ilo_ip_address => '172.16.1.8',
 			ip_gateway => '10.10.1.1',
-			phys_location => '3',
+			phys_location => '9',
 			status => '1',
 		},
 	},
@@ -1153,10 +1153,10 @@ my %definition_for = (
 			ip_gateway => '10.10.1.1',
 			router_host_name => 'rtr-lax.kabletown.net',
 			status => '1',
-			cachegroup => '92',
+			cachegroup => '7',
 			ilo_ip_address => '172.16.1.9',
 			last_updated => '2015-12-10 15:44:37',
-			phys_location => '3',
+			phys_location => '9',
 			profile => '5',
 			rack => 'RR 119.02',
 			type => '13',
@@ -1194,11 +1194,11 @@ my %definition_for = (
 			upd_pending => '0',
 			ip_netmask => '255.255.255.0',
 			mgmt_ip_address => '',
-			phys_location => '4',
+			phys_location => '10',
 			rack => 'RR 119.02',
 			router_host_name => 'rtr-lax.kabletown.net',
 			router_port_name => '1',
-			cachegroup => '92',
+			cachegroup => '7',
 			ip6_address => '2033:D0D0:3300::1:6/64',
 			last_updated => '2015-12-10 15:44:37',
 			status => '1',
@@ -1232,10 +1232,10 @@ my %definition_for = (
 			ip_address => '10.10.1.7',
 			interface_mtu => '9000',
 			last_updated => '2015-12-10 15:44:36',
-			phys_location => '4',
+			phys_location => '10',
 			status => '1',
 			xmpp_passwd => 'X',
-			cachegroup => '92',
+			cachegroup => '7',
 			ilo_ip_address => '172.16.1.11',
 			ip_netmask => '255.255.255.0',
 			router_host_name => 'rtr-lax.kabletown.net',
@@ -1257,10 +1257,10 @@ my %definition_for = (
 			rack => 'RR 119.02',
 			status => '1',
 			type => '13',
-			cachegroup => '92',
+			cachegroup => '7',
 			ip_address => '10.10.1.8',
 			ip_gateway => '10.10.1.1',
-			phys_location => '4',
+			phys_location => '10',
 			xmpp_id => 'atsec-lax-06-dummyxmpp',
 			cdn_id => '2',
 			interface_name => 'bond0',
@@ -1314,9 +1314,9 @@ my %definition_for = (
 			interface_name => 'bond0',
 			upd_pending => '0',
 			mgmt_ip_netmask => '',
-			phys_location => '4',
+			phys_location => '10',
 			profile => '7',
-			cachegroup => '92',
+			cachegroup => '7',
 			ip_address => '10.10.1.9',
 			last_updated => '2015-12-10 15:44:37',
 		},
@@ -1336,7 +1336,7 @@ my %definition_for = (
 			ilo_password => '',
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_address => '',
-			phys_location => '4',
+			phys_location => '10',
 			interface_mtu => '9000',
 			xmpp_passwd => 'X',
 			ilo_ip_gateway => '172.16.1.1',
@@ -1351,7 +1351,7 @@ my %definition_for = (
 			rack => 'RR 119.02',
 			router_port_name => '1',
 			xmpp_id => 'atsec-lax-08-dummyxmpp',
-			cachegroup => '92',
+			cachegroup => '7',
 			ilo_ip_address => '172.16.1.14',
 			ip6_gateway => '2033:D0D0:3300::1:1',
 			ip_gateway => '10.10.1.1',
@@ -1364,14 +1364,14 @@ my %definition_for = (
 		using => {
 			host_name => 'atsec-nyc-00',
 			interface_mtu => '9000',
-			cachegroup => '91',
+			cachegroup => '10',
 			interface_name => 'bond0',
 			xmpp_id => 'atsec-nyc-00-dummyxmpp',
 			router_host_name => 'rtr-nyc.kabletown.net',
 			status => '1',
 			cdn_id => '1',
 			ilo_password => '',
-			phys_location => '1',
+			phys_location => '11',
 			rack => 'RR 119.02',
 			tcp_port => '80',
 			domain_name => 'nyc.kabletown.net',
@@ -1405,7 +1405,7 @@ my %definition_for = (
 			interface_name => 'bond0',
 			ip6_gateway => '2033:D0D0:3300::0:1',
 			tcp_port => '80',
-			cachegroup => '91',
+			cachegroup => '10',
 			ilo_password => '',
 			ip_address => '10.10.0.3',
 			xmpp_passwd => 'X',
@@ -1413,7 +1413,7 @@ my %definition_for = (
 			mgmt_ip_address => '',
 			type => '13',
 			cdn_id => '1',
-			phys_location => '1',
+			phys_location => '11',
 			xmpp_id => 'atsec-nyc-01-dummyxmpp',
 			ip_netmask => '255.255.255.0',
 			router_host_name => 'rtr-nyc.kabletown.net',
@@ -1439,7 +1439,7 @@ my %definition_for = (
 			host_name => 'atsec-nyc-02',
 			mgmt_ip_netmask => '',
 			rack => 'RR 119.02',
-			cachegroup => '91',
+			cachegroup => '10',
 			domain_name => 'nyc.kabletown.net',
 			ip6_gateway => '2033:D0D0:3300::0:1',
 			last_updated => '2015-12-10 15:44:37',
@@ -1448,7 +1448,7 @@ my %definition_for = (
 			status => '1',
 			ip_gateway => '10.10.0.1',
 			router_port_name => '0',
-			phys_location => '1',
+			phys_location => '11',
 			profile => '5',
 			type => '13',
 			ilo_ip_address => '172.16.0.8',
@@ -1474,7 +1474,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-nyc-03',
-			phys_location => '1',
+			phys_location => '11',
 			router_host_name => 'rtr-nyc.kabletown.net',
 			status => '1',
 			mgmt_ip_address => '',
@@ -1486,7 +1486,7 @@ my %definition_for = (
 			mgmt_ip_netmask => '',
 			ip6_address => '2033:D0D0:3300::0:5/64',
 			ip_netmask => '255.255.255.0',
-			cachegroup => '91',
+			cachegroup => '10',
 			xmpp_passwd => 'X',
 			upd_pending => '0',
 			ilo_password => '',
@@ -1524,12 +1524,12 @@ my %definition_for = (
 			rack => 'RR 119.02',
 			profile => '7',
 			type => '13',
-			cachegroup => '91',
+			cachegroup => '10',
 			ilo_username => '',
 			interface_name => 'bond0',
 			mgmt_ip_address => '',
 			mgmt_ip_gateway => '',
-			phys_location => '2',
+			phys_location => '12',
 			xmpp_id => 'atsec-nyc-04-dummyxmpp',
 			ip6_address => '2033:D0D0:3300::0:6/64',
 			ilo_ip_address => '172.16.0.10',
@@ -1550,7 +1550,7 @@ my %definition_for = (
 			host_name => 'atsec-nyc-05',
 			ilo_ip_netmask => '255.255.255.0',
 			ip_address => '10.10.0.7',
-			cachegroup => '91',
+			cachegroup => '10',
 			ilo_ip_gateway => '172.16.0.1',
 			mgmt_ip_address => '',
 			profile => '7',
@@ -1560,7 +1560,7 @@ my %definition_for = (
 			status => '1',
 			interface_name => 'bond0',
 			ip6_gateway => '2033:D0D0:3300::0:1',
-			phys_location => '2',
+			phys_location => '12',
 			upd_pending => '0',
 			xmpp_id => 'atsec-nyc-05-dummyxmpp',
 			ilo_password => '',
@@ -1588,7 +1588,7 @@ my %definition_for = (
 			ip6_gateway => '2033:D0D0:3300::0:1',
 			ip_netmask => '255.255.255.0',
 			mgmt_ip_netmask => '',
-			phys_location => '2',
+			phys_location => '12',
 			upd_pending => '0',
 			interface_mtu => '9000',
 			ilo_username => '',
@@ -1614,7 +1614,7 @@ my %definition_for = (
 			ilo_ip_address => '172.16.0.12',
 			interface_name => 'bond0',
 			profile => '7',
-			cachegroup => '91',
+			cachegroup => '10',
 		},
 	},
 	## id => 44
@@ -1626,7 +1626,7 @@ my %definition_for = (
 			xmpp_passwd => 'X',
 			ip6_gateway => '2033:D0D0:3300::0:1',
 			ip_gateway => '10.10.0.1',
-			phys_location => '2',
+			phys_location => '12',
 			mgmt_ip_address => '',
 			profile => '7',
 			type => '13',
@@ -1648,7 +1648,7 @@ my %definition_for = (
 			status => '1',
 			cdn_id => '2',
 			ilo_ip_netmask => '255.255.255.0',
-			cachegroup => '91',
+			cachegroup => '10',
 			tcp_port => '80',
 			ip_address => '10.10.0.9',
 			router_host_name => 'rtr-nyc.kabletown.net',
@@ -1682,13 +1682,13 @@ my %definition_for = (
 			profile => '7',
 			rack => 'RR 119.02',
 			upd_pending => '0',
-			cachegroup => '91',
+			cachegroup => '10',
 			ilo_password => '',
 			ilo_username => '',
 			xmpp_passwd => 'X',
 			cdn_id => '2',
 			mgmt_ip_gateway => '',
-			phys_location => '2',
+			phys_location => '12',
 		},
 	},
 	## id => 46
@@ -1713,7 +1713,7 @@ my %definition_for = (
 			interface_mtu => '9000',
 			mgmt_ip_netmask => '',
 			xmpp_passwd => 'X',
-			cachegroup => '95',
+			cachegroup => '11',
 			cdn_id => '1',
 			ip_gateway => '10.10.4.1',
 			type => '13',
@@ -1724,7 +1724,7 @@ my %definition_for = (
 			status => '1',
 			last_updated => '2015-12-10 15:44:36',
 			mgmt_ip_gateway => '',
-			phys_location => '9',
+			phys_location => '13',
 			rack => 'RR 119.02',
 		},
 	},
@@ -1733,7 +1733,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-phl-01',
-			phys_location => '9',
+			phys_location => '13',
 			router_port_name => '4',
 			ilo_password => '',
 			ip6_address => '2033:D0D0:3300::4:3/64',
@@ -1742,7 +1742,7 @@ my %definition_for = (
 			rack => 'RR 119.02',
 			tcp_port => '80',
 			type => '13',
-			cachegroup => '95',
+			cachegroup => '11',
 			ilo_ip_gateway => '172.16.4.1',
 			ip_gateway => '10.10.4.1',
 			router_host_name => 'rtr-phl.kabletown.net',
@@ -1790,13 +1790,13 @@ my %definition_for = (
 			status => '1',
 			ilo_password => '',
 			last_updated => '2015-12-10 15:44:37',
-			phys_location => '9',
+			phys_location => '13',
 			profile => '5',
 			cdn_id => '1',
 			upd_pending => '0',
 			router_host_name => 'rtr-phl.kabletown.net',
 			rack => 'RR 119.02',
-			cachegroup => '95',
+			cachegroup => '11',
 			domain_name => 'phl.kabletown.net',
 			ilo_ip_address => '172.16.4.8',
 			ip_gateway => '10.10.4.1',
@@ -1807,7 +1807,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-phl-03',
-			phys_location => '9',
+			phys_location => '13',
 			status => '1',
 			upd_pending => '0',
 			ilo_ip_netmask => '255.255.255.0',
@@ -1827,7 +1827,7 @@ my %definition_for = (
 			ip6_gateway => '2033:D0D0:3300::4:1',
 			ip_address => '10.10.4.5',
 			xmpp_passwd => 'X',
-			cachegroup => '95',
+			cachegroup => '11',
 			cdn_id => '1',
 			interface_mtu => '9000',
 			ip6_address => '2033:D0D0:3300::4:5/64',
@@ -1844,7 +1844,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-phl-04',
-			cachegroup => '95',
+			cachegroup => '11',
 			ilo_ip_netmask => '255.255.255.0',
 			ilo_password => '',
 			interface_name => 'bond0',
@@ -1868,7 +1868,7 @@ my %definition_for = (
 			upd_pending => '0',
 			interface_mtu => '9000',
 			last_updated => '2015-12-10 15:44:37',
-			phys_location => '10',
+			phys_location => '14',
 			domain_name => 'phl.kabletown.net',
 			ip6_address => '2033:D0D0:3300::4:6/64',
 			ip6_gateway => '2033:D0D0:3300::4:1',
@@ -1881,7 +1881,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-phl-05',
-			cachegroup => '95',
+			cachegroup => '11',
 			ilo_username => '',
 			interface_name => 'bond0',
 			ip6_gateway => '2033:D0D0:3300::4:1',
@@ -1896,7 +1896,7 @@ my %definition_for = (
 			router_host_name => 'rtr-phl.kabletown.net',
 			xmpp_passwd => 'X',
 			type => '13',
-			phys_location => '10',
+			phys_location => '14',
 			upd_pending => '0',
 			xmpp_id => 'atsec-phl-05-dummyxmpp',
 			cdn_id => '2',
@@ -1918,7 +1918,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-phl-06',
-			cachegroup => '95',
+			cachegroup => '11',
 			ilo_password => '',
 			router_host_name => 'rtr-phl.kabletown.net',
 			router_port_name => '4',
@@ -1941,7 +1941,7 @@ my %definition_for = (
 			mgmt_ip_netmask => '',
 			xmpp_passwd => 'X',
 			ip_netmask => '255.255.255.0',
-			phys_location => '10',
+			phys_location => '14',
 			rack => 'RR 119.02',
 			ip_gateway => '10.10.4.1',
 			status => '1',
@@ -1955,7 +1955,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsec-phl-07',
-			cachegroup => '95',
+			cachegroup => '11',
 			domain_name => 'phl.kabletown.net',
 			ilo_password => '',
 			ip_gateway => '10.10.4.1',
@@ -1979,7 +1979,7 @@ my %definition_for = (
 			router_host_name => 'rtr-phl.kabletown.net',
 			router_port_name => '4',
 			tcp_port => '80',
-			phys_location => '10',
+			phys_location => '14',
 			status => '1',
 			ilo_ip_netmask => '255.255.255.0',
 			interface_name => 'bond0',
@@ -1997,7 +1997,7 @@ my %definition_for = (
 			mgmt_ip_netmask => '',
 			router_port_name => '4',
 			type => '13',
-			cachegroup => '95',
+			cachegroup => '11',
 			ip6_gateway => '2033:D0D0:3300::4:1',
 			xmpp_id => 'atsec-phl-08-dummyxmpp',
 			rack => 'RR 119.02',
@@ -2011,7 +2011,7 @@ my %definition_for = (
 			ilo_ip_gateway => '172.16.4.1',
 			interface_mtu => '9000',
 			interface_name => 'bond0',
-			phys_location => '10',
+			phys_location => '14',
 			upd_pending => '0',
 			mgmt_ip_address => '',
 			profile => '7',
@@ -2031,7 +2031,7 @@ my %definition_for = (
 			host_name => 'atsmid-east-00',
 			ip_gateway => '10.11.0.1',
 			last_updated => '2015-12-10 15:44:37',
-			cachegroup => '1',
+			cachegroup => '4',
 			domain_name => 'east.kabletown.net',
 			ilo_username => '',
 			rack => 'RR 119.02',
@@ -2057,7 +2057,7 @@ my %definition_for = (
 			mgmt_ip_gateway => '',
 			ilo_ip_netmask => '255.255.255.0',
 			ip6_gateway => '2033:D0D1:3300::0:1',
-			phys_location => '1',
+			phys_location => '11',
 			xmpp_passwd => 'X',
 		},
 	},
@@ -2083,8 +2083,8 @@ my %definition_for = (
 			ilo_ip_netmask => '255.255.255.0',
 			ilo_password => '',
 			ilo_username => '',
-			cachegroup => '1',
-			phys_location => '1',
+			cachegroup => '4',
+			phys_location => '11',
 			rack => 'RR 119.02',
 			domain_name => 'east.kabletown.net',
 			ip6_gateway => '2033:D0D1:3300::0:1',
@@ -2119,7 +2119,7 @@ my %definition_for = (
 			interface_name => 'bond0',
 			ip6_address => '2033:D0D1:3300::0:4/64',
 			mgmt_ip_gateway => '',
-			phys_location => '1',
+			phys_location => '11',
 			profile => '15',
 			upd_pending => '0',
 			cdn_id => '2',
@@ -2127,7 +2127,7 @@ my %definition_for = (
 			ilo_ip_netmask => '255.255.255.0',
 			ip_address => '10.11.0.3',
 			router_port_name => '0',
-			cachegroup => '1',
+			cachegroup => '4',
 			ilo_password => '',
 			ip6_gateway => '2033:D0D1:3300::0:1',
 			last_updated => '2015-12-10 15:44:37',
@@ -2147,12 +2147,12 @@ my %definition_for = (
 			ip6_address => '2033:D0D1:3300::0:5/64',
 			xmpp_id => 'atsmid-east-03-dummyxmpp',
 			mgmt_ip_address => '',
-			phys_location => '1',
+			phys_location => '11',
 			profile => '13',
 			mgmt_ip_gateway => '',
 			tcp_port => '80',
 			type => '22',
-			cachegroup => '1',
+			cachegroup => '4',
 			ilo_ip_gateway => '172.17.0.1',
 			interface_name => 'bond0',
 			router_port_name => '0',
@@ -2177,7 +2177,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsmid-east-04',
-			cachegroup => '1',
+			cachegroup => '4',
 			interface_name => 'bond0',
 			profile => '15',
 			ilo_ip_netmask => '255.255.255.0',
@@ -2205,7 +2205,7 @@ my %definition_for = (
 			xmpp_id => 'atsmid-east-04-dummyxmpp',
 			ilo_ip_gateway => '172.17.0.1',
 			ip_address => '10.11.0.5',
-			phys_location => '2',
+			phys_location => '12',
 			type => '22',
 		},
 	},
@@ -2226,7 +2226,7 @@ my %definition_for = (
 			ilo_password => '',
 			interface_mtu => '9000',
 			tcp_port => '80',
-			cachegroup => '1',
+			cachegroup => '4',
 			domain_name => 'east.kabletown.net',
 			ilo_username => '',
 			upd_pending => '0',
@@ -2238,7 +2238,7 @@ my %definition_for = (
 			mgmt_ip_address => '',
 			ip6_gateway => '2033:D0D1:3300::0:1',
 			ip_netmask => '255.255.255.0',
-			phys_location => '2',
+			phys_location => '12',
 			ip6_address => '2033:D0D1:3300::0:7/64',
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_gateway => '',
@@ -2260,7 +2260,7 @@ my %definition_for = (
 			ip6_address => '2033:D0D1:3300::0:8/64',
 			ilo_ip_netmask => '255.255.255.0',
 			mgmt_ip_netmask => '',
-			phys_location => '2',
+			phys_location => '12',
 			profile => '15',
 			ilo_ip_address => '172.17.0.12',
 			last_updated => '2015-12-10 15:44:36',
@@ -2272,7 +2272,7 @@ my %definition_for = (
 			domain_name => 'east.kabletown.net',
 			ip6_gateway => '2033:D0D1:3300::0:1',
 			ip_address => '10.11.0.7',
-			cachegroup => '1',
+			cachegroup => '4',
 			ip_gateway => '10.11.0.1',
 			mgmt_ip_address => '',
 			mgmt_ip_gateway => '',
@@ -2293,7 +2293,7 @@ my %definition_for = (
 			xmpp_id => 'atsmid-east-07-dummyxmpp',
 			last_updated => '2015-12-10 15:44:37',
 			xmpp_passwd => 'X',
-			cachegroup => '1',
+			cachegroup => '4',
 			ilo_ip_address => '172.17.0.13',
 			interface_name => 'bond0',
 			ip6_gateway => '2033:D0D1:3300::0:1',
@@ -2301,7 +2301,7 @@ my %definition_for = (
 			ilo_ip_netmask => '255.255.255.0',
 			interface_mtu => '9000',
 			ip_address => '10.11.0.8',
-			phys_location => '2',
+			phys_location => '12',
 			router_host_name => 'rtr-east.kabletown.net',
 			ilo_ip_gateway => '172.17.0.1',
 			ip6_address => '2033:D0D1:3300::0:9/64',
@@ -2331,7 +2331,7 @@ my %definition_for = (
 			interface_mtu => '9000',
 			ip_netmask => '255.255.255.0',
 			mgmt_ip_gateway => '',
-			phys_location => '2',
+			phys_location => '12',
 			ilo_password => '',
 			ip_gateway => '10.11.0.1',
 			tcp_port => '80',
@@ -2346,7 +2346,7 @@ my %definition_for = (
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_netmask => '',
 			xmpp_passwd => 'X',
-			cachegroup => '1',
+			cachegroup => '4',
 			ip_address => '10.11.0.9',
 			mgmt_ip_address => '',
 			ilo_ip_netmask => '255.255.255.0',
@@ -2372,7 +2372,7 @@ my %definition_for = (
 			rack => 'RR 119.02',
 			mgmt_ip_address => '',
 			mgmt_ip_netmask => '',
-			phys_location => '3',
+			phys_location => '9',
 			xmpp_id => 'atsmid-west-00-dummyxmpp',
 			xmpp_passwd => 'X',
 			cdn_id => '2',
@@ -2387,7 +2387,7 @@ my %definition_for = (
 			mgmt_ip_gateway => '',
 			upd_pending => '0',
 			tcp_port => '80',
-			cachegroup => '2',
+			cachegroup => '6',
 			ilo_ip_netmask => '255.255.255.0',
 			interface_mtu => '9000',
 			ip6_address => '2033:D0D1:3300::1:2/64',
@@ -2409,7 +2409,7 @@ my %definition_for = (
 			ilo_ip_address => '172.17.1.7',
 			interface_name => 'bond0',
 			mgmt_ip_netmask => '',
-			phys_location => '3',
+			phys_location => '9',
 			profile => '13',
 			tcp_port => '80',
 			ilo_ip_gateway => '172.17.1.1',
@@ -2420,7 +2420,7 @@ my %definition_for = (
 			ip6_address => '2033:D0D1:3300::1:3/64',
 			ip6_gateway => '2033:D0D1:3300::1:1',
 			mgmt_ip_gateway => '',
-			cachegroup => '2',
+			cachegroup => '6',
 			domain_name => 'west.kabletown.net',
 			mgmt_ip_address => '',
 			xmpp_id => 'atsmid-west-01-dummyxmpp',
@@ -2441,7 +2441,7 @@ my %definition_for = (
 			ip_netmask => '255.255.255.0',
 			status => '6',
 			tcp_port => '80',
-			cachegroup => '2',
+			cachegroup => '6',
 			ip_gateway => '10.11.1.1',
 			router_host_name => 'rtr-west.kabletown.net',
 			ilo_ip_address => '172.17.1.8',
@@ -2463,7 +2463,7 @@ my %definition_for = (
 			ilo_ip_gateway => '172.17.1.1',
 			mgmt_ip_address => '',
 			mgmt_ip_netmask => '',
-			phys_location => '3',
+			phys_location => '9',
 			interface_name => 'bond0',
 			upd_pending => '0',
 		},
@@ -2488,10 +2488,10 @@ my %definition_for = (
 			interface_mtu => '9000',
 			mgmt_ip_gateway => '',
 			ip_netmask => '255.255.255.0',
-			phys_location => '3',
+			phys_location => '9',
 			tcp_port => '80',
 			upd_pending => '0',
-			cachegroup => '2',
+			cachegroup => '6',
 			ip6_gateway => '2033:D0D1:3300::1:1',
 			mgmt_ip_address => '',
 			rack => 'RR 119.02',
@@ -2516,7 +2516,7 @@ my %definition_for = (
 			ip6_address => '2033:D0D1:3300::1:6/64',
 			mgmt_ip_gateway => '',
 			profile => '15',
-			cachegroup => '2',
+			cachegroup => '6',
 			ilo_ip_address => '172.17.1.10',
 			interface_name => 'bond0',
 			router_host_name => 'rtr-west.kabletown.net',
@@ -2524,7 +2524,7 @@ my %definition_for = (
 			upd_pending => '0',
 			xmpp_id => 'atsmid-west-04-dummyxmpp',
 			cdn_id => '2',
-			phys_location => '4',
+			phys_location => '10',
 			ilo_password => '',
 			ip_gateway => '10.11.1.1',
 			last_updated => '2015-12-10 15:44:36',
@@ -2547,7 +2547,7 @@ my %definition_for = (
 		new => 'Server',
 		using => {
 			host_name => 'atsmid-west-05',
-			phys_location => '4',
+			phys_location => '10',
 			tcp_port => '80',
 			ip6_address => '2033:D0D1:3300::1:7/64',
 			ip_gateway => '10.11.1.1',
@@ -2556,7 +2556,7 @@ my %definition_for = (
 			xmpp_passwd => 'X',
 			ilo_ip_netmask => '255.255.255.0',
 			type => '22',
-			cachegroup => '2',
+			cachegroup => '6',
 			ip6_gateway => '2033:D0D1:3300::1:1',
 			ip_netmask => '255.255.255.0',
 			last_updated => '2015-12-10 15:44:37',
@@ -2596,7 +2596,7 @@ my %definition_for = (
 			ip6_gateway => '2033:D0D1:3300::1:1',
 			ip_netmask => '255.255.255.0',
 			profile => '15',
-			cachegroup => '2',
+			cachegroup => '6',
 			ip_address => '10.11.1.7',
 			type => '22',
 			xmpp_passwd => 'X',
@@ -2607,7 +2607,7 @@ my %definition_for = (
 			cdn_id => '2',
 			interface_name => 'bond0',
 			mgmt_ip_address => '',
-			phys_location => '4',
+			phys_location => '10',
 			router_port_name => '1',
 			status => '6',
 			ilo_ip_gateway => '172.17.1.1',
@@ -2633,11 +2633,11 @@ my %definition_for = (
 			ip6_address => '2033:D0D1:3300::1:9/64',
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_netmask => '',
-			phys_location => '4',
+			phys_location => '10',
 			rack => 'RR 119.02',
 			mgmt_ip_gateway => '',
 			tcp_port => '80',
-			cachegroup => '2',
+			cachegroup => '6',
 			domain_name => 'west.kabletown.net',
 			ilo_username => '',
 			interface_mtu => '9000',
@@ -2672,13 +2672,13 @@ my %definition_for = (
 			rack => 'RR 119.02',
 			router_port_name => '1',
 			type => '22',
-			cachegroup => '2',
+			cachegroup => '6',
 			domain_name => 'west.kabletown.net',
 			profile => '15',
 			interface_name => 'bond0',
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_gateway => '',
-			phys_location => '4',
+			phys_location => '10',
 			xmpp_passwd => 'X',
 			ilo_ip_gateway => '172.17.1.1',
 			ip6_address => '2033:D0D1:3300::1:10/64',
@@ -2705,7 +2705,7 @@ my %definition_for = (
 			router_host_name => '',
 			router_port_name => '',
 			tcp_port => '80',
-			cachegroup => '101',
+			cachegroup => '3',
 			ilo_ip_netmask => '',
 			mgmt_ip_address => '',
 			rack => 'RR 119.02',
@@ -2724,7 +2724,7 @@ my %definition_for = (
 			upd_pending => '0',
 			interface_mtu => '1500',
 			mgmt_ip_gateway => '',
-			phys_location => '1',
+			phys_location => '11',
 		},
 	},
 	## id => 74
@@ -2756,8 +2756,8 @@ my %definition_for = (
 			ilo_username => '',
 			upd_pending => '0',
 			xmpp_id => '',
-			phys_location => '1',
-			cachegroup => '102',
+			phys_location => '11',
+			cachegroup => '5',
 			interface_name => 'eth1',
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_address => '',
@@ -2786,7 +2786,7 @@ my %definition_for = (
 			ip_gateway => '127.0.0.5',
 			profile => '21',
 			xmpp_id => '',
-			cachegroup => '1',
+			cachegroup => '4',
 			cdn_id => '2',
 			ilo_ip_netmask => '',
 			ip6_gateway => undef,
@@ -2797,7 +2797,7 @@ my %definition_for = (
 			mgmt_ip_netmask => '',
 			router_port_name => '',
 			last_updated => '2015-12-10 15:44:36',
-			phys_location => '1',
+			phys_location => '11',
 			type => '28',
 		},
 	},
@@ -2812,12 +2812,12 @@ my %definition_for = (
 			ip_netmask => '255.255.255.0',
 			interface_mtu => '9000',
 			mgmt_ip_gateway => undef,
-			phys_location => '100',
+			phys_location => '1',
 			rack => 'RR 119.02',
 			domain_name => 'cle.kabletown.net',
 			ilo_username => undef,
 			xmpp_passwd => 'X',
-			cachegroup => '5',
+			cachegroup => '1',
 			mgmt_ip_netmask => undef,
 			last_updated => '2015-12-10 15:44:37',
 			router_port_name => undef,
@@ -2849,8 +2849,8 @@ my %definition_for = (
 			cdn_id => '2',
 			ilo_ip_netmask => undef,
 			mgmt_ip_netmask => undef,
-			phys_location => '101',
-			cachegroup => '5',
+			phys_location => '2',
+			cachegroup => '1',
 			ilo_ip_address => undef,
 			ilo_ip_gateway => undef,
 			ilo_username => undef,
@@ -2893,7 +2893,7 @@ my %definition_for = (
 			type => '27',
 			router_host_name => undef,
 			router_port_name => undef,
-			cachegroup => '3',
+			cachegroup => '2',
 			interface_name => 'bond0',
 			ip_address => '172.39.29.39',
 			mgmt_ip_gateway => undef,
@@ -2909,7 +2909,7 @@ my %definition_for = (
 			ip6_address => '2033:D021:3300::333/64',
 			ip_netmask => '255.255.255.0',
 			last_updated => '2015-12-10 15:44:37',
-			phys_location => '100',
+			phys_location => '1',
 		},
 	},
 	## id => 79
@@ -2928,7 +2928,7 @@ my %definition_for = (
 			status => '6',
 			tcp_port => '80',
 			mgmt_ip_address => undef,
-			phys_location => '101',
+			phys_location => '2',
 			mgmt_ip_netmask => undef,
 			domain_name => 'clw.kabletown.net',
 			ip6_gateway => '2033:D021:3300::1',
@@ -2936,7 +2936,7 @@ my %definition_for = (
 			profile => '20',
 			rack => 'RR 119.02',
 			xmpp_passwd => 'X',
-			cachegroup => '3',
+			cachegroup => '2',
 			last_updated => '2015-12-10 15:44:37',
 			router_host_name => undef,
 			interface_mtu => '9000',
@@ -2967,9 +2967,9 @@ my %definition_for = (
 			ip_gateway => '172.39.99.1',
 			mgmt_ip_gateway => undef,
 			profile => '1',
-			cachegroup => '5',
+			cachegroup => '1',
 			ip_address => '172.39.99.39',
-			phys_location => '100',
+			phys_location => '1',
 			ilo_ip_gateway => undef,
 			last_updated => '2015-12-10 15:44:37',
 			mgmt_ip_netmask => undef,
@@ -2992,7 +2992,7 @@ my %definition_for = (
 		using => {
 			host_name => 'trtr-cle-02',
 			ip_gateway => '172.39.99.1',
-			phys_location => '101',
+			phys_location => '2',
 			profile => '2',
 			type => '4',
 			upd_pending => '0',
@@ -3001,7 +3001,7 @@ my %definition_for = (
 			ilo_ip_gateway => undef,
 			xmpp_passwd => 'X',
 			interface_name => 'bond0',
-			cachegroup => '5',
+			cachegroup => '1',
 			cdn_id => '2',
 			ilo_ip_netmask => undef,
 			mgmt_ip_address => undef,
@@ -3040,7 +3040,7 @@ my %definition_for = (
 			type => '4',
 			profile => '1',
 			xmpp_passwd => 'X',
-			cachegroup => '3',
+			cachegroup => '2',
 			mgmt_ip_netmask => undef,
 			cdn_id => '1',
 			ilo_password => undef,
@@ -3055,7 +3055,7 @@ my %definition_for = (
 			xmpp_id => 'trtr-clw-01-dummyxmpp',
 			ilo_ip_netmask => undef,
 			last_updated => '2015-12-10 15:44:37',
-			phys_location => '100',
+			phys_location => '1',
 			tcp_port => '80',
 			upd_pending => '0',
 		},
@@ -3071,7 +3071,7 @@ my %definition_for = (
 			router_host_name => undef,
 			mgmt_ip_gateway => undef,
 			rack => 'RR 119.02',
-			cachegroup => '3',
+			cachegroup => '2',
 			ilo_ip_gateway => undef,
 			ilo_password => undef,
 			interface_mtu => '9000',
@@ -3083,7 +3083,7 @@ my %definition_for = (
 			mgmt_ip_netmask => undef,
 			tcp_port => '80',
 			last_updated => '2015-12-10 15:44:37',
-			phys_location => '101',
+			phys_location => '2',
 			upd_pending => '0',
 			cdn_id => '2',
 			ilo_ip_netmask => undef,

http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/af0c115e/traffic_ops/app/lib/Test/IntegrationTestHelper.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Test/IntegrationTestHelper.pm b/traffic_ops/app/lib/Test/IntegrationTestHelper.pm
index b9670ed..578cea4 100644
--- a/traffic_ops/app/lib/Test/IntegrationTestHelper.pm
+++ b/traffic_ops/app/lib/Test/IntegrationTestHelper.pm
@@ -156,7 +156,7 @@ sub load_core_data {
 	$self->load_all_fixtures( Fixtures::Integration::Region->new($schema_values) );
 	$self->load_all_fixtures( Fixtures::Integration::PhysLocation->new($schema_values) );
 	$self->load_all_fixtures( Fixtures::Integration::Status->new($schema_values) );
-	# $self->load_all_fixtures( Fixtures::Integration::Cachegroup->new($schema_values) );
+	$self->load_all_fixtures( Fixtures::Integration::Cachegroup->new($schema_values) );
 	$self->load_all_fixtures( Fixtures::Integration::Regex->new($schema_values) );
 	$self->load_all_fixtures( Fixtures::Integration::Parameter->new($schema_values) );
 	$self->load_all_fixtures( Fixtures::Integration::Profile->new($schema_values) );
@@ -171,18 +171,16 @@ sub load_core_data {
 	diag "Done!";
 }
 
+# Tearing down the Cachegroup table requires deleting them in a specific order, because
+# of the 'parent_cachegroup_id' and nested references.
 sub delete_cachegroups {
 	my $self   = shift;
-	my $schema = shift;
 
-	#	my $sql     = 'IS NOT NULL AND type != 7';
-	#	my $parents = $schema->resultset('Cachegroup')->search( { parent_cachegroup_id => \$sql } );
-	#	$parents->delete;
-	my $orgs = $schema->resultset('Cachegroup')->search( { type => 6 } );
-	$orgs->delete;
-	$orgs = $schema->resultset('Cachegroup')->search( { type => 7 } );
-	$orgs->delete;
-	$schema->resultset('Cachegroup')->delete_all;
+	my $dbh    = Schema->database_handle;
+	my $cg = $dbh->prepare("TRUNCATE TABLE cachegroup CASCADE;");
+	$cg->execute();
+	$cg->finish();
+	$dbh->disconnect;
 }
 
 sub unload_core_data {