[Users] cannot add new logical network to host

Thu Nov 15 19:26:15 UTC 2012

On Thu, Nov 15, 2012 at 12:59 PM, Alan Johnson <alan at datdec.com> wrote:

> Be sure to read my other post before running with this as it may be a dead
> end, but here is the dump from last night's backup (just the one row):
>
> INSERT INTO vds_interface(addr, bond_name, bond_type, gateway, id,
> is_bond, bond_opts, mac_addr, name, network_name, speed, subnet,
> boot_protocol, type, VDS_ID, vlan_id, mtu, bridged)
>          VALUES(v_addr, v_bond_name, v_bond_type, v_gateway, v_id,
> v_is_bond, v_bond_opts, v_mac_addr, v_name, v_network_name, v_speed,
> v_subnet, v_boot_protocol, v_type, v_vds_id, v_vlan_id, v_mtu, v_bridged);
> END; $$;
>

Whoops!  I didn't actually read the SQL before sending, just skimmed
looking for anything sensitive   I see now that this is not at all useful.
 Here is a CSV output of that table:

"id","name","network_name","vds_id","mac_addr","is_bond","bond_name","bond_type","bond_opts","vlan_id","speed","addr","subnet","gateway","boot_protocol","type","_create_date","_update_date","mtu","bridged"
"d9843c29-ff18-4f26-ba9c-19c24a3dc65d","bond0","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
16:25:13.441602-04","2012-11-14 15:11:13.867575-05","1500","0"
"41e44be1-1e6a-4468-b613-0defc957e57a","bond1","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
16:25:13.444754-04","2012-11-14 15:11:13.871171-05","1500","0"
"4aac622e-942b-424d-b37c-c9cac9c3eaa9","bond2","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
16:25:13.447615-04","2012-11-14 15:11:13.874052-05","1500","0"
"2f3edf8c-60e6-4b0e-9a77-fd15f395ad2c","em1","ovirtmgmt","88089a7c-124e-11e2-877b-52540021f621","84:8f:69:75:50:e9","","","","","","1000","192.168.119.158","255.255.255.0","192.168.119.110","1","2","2012-10-09
16:25:13.421371-04","2012-11-14 15:11:13.876869-05","1500","1"
"59c2ce88-2f1e-4342-98f6-6e4c0fdcc60a","bond0","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
12:36:20.430133-04","2012-11-14 15:11:18.753809-05","1500","0"
"8f185782-29c7-4bea-95ef-ab02306bb7a1","bond1","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
12:36:20.43354-04","2012-11-14 15:11:18.75761-05","1500","0"
"3eaa26a9-10d0-4e8f-aab8-a02b7e5cb33b","bond2","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
12:36:20.43681-04","2012-11-14 15:11:18.761024-05","1500","0"
"2d931dfa-9b57-4342-8c1d-feb122bb908f","em2","","88089a7c-124e-11e2-877b-52540021f621","84:8f:69:75:50:eb","","","","","","1000","10.10.5.102","255.255.255.0","","","0","2012-10-09
16:25:13.429715-04","2012-11-14 15:11:13.879592-05","9000","0"
"53dcddb6-4494-4f8e-8b5c-ad139ceb551b","em1","ovirtmgmt","acb1a7d6-122d-11e2-9f25-52540021f621","84:8f:69:75:50:8e","","","","","","1000","192.168.119.186","255.255.255.0","192.168.119.110","1","2","2012-10-09
12:36:20.414512-04","2012-11-14 15:11:18.764122-05","1500","1"
"37d0d8d7-d512-4a74-99c2-e61fe82b893e","em2","","acb1a7d6-122d-11e2-9f25-52540021f621","84:8f:69:75:50:90","","","","","","1000","10.10.5.103","255.255.255.0","","","0","2012-10-09
12:36:20.419835-04","2012-11-14 15:11:18.770674-05","9000","0"
"a31eb4bc-dc2c-4697-8d72-e61e41fc2bdb","bond2","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14
15:06:01.669305-05","2012-11-14 16:01:05.967822-05","1500","0"
"c8d832d2-e789-46de-a5b5-9d4bbbdada72","em1","ovirtmgmt","ec7b4186-2e95-11e2-abe4-52540021f621","84:8f:69:75:50:81","","","","","","1000","192.168.119.156","255.255.255.0","192.168.119.110","1","2","2012-11-14
15:06:01.648564-05","2012-11-14 16:01:05.969595-05","1500","1"
"bc5892b9-6b96-4034-b828-9d46b1c38060","em2","","ec7b4186-2e95-11e2-abe4-52540021f621","84:8f:69:75:50:83","","","","","","1000","10.10.5.101","255.255.255.0","","","0","2012-11-14
15:06:01.654161-05","2012-11-14 16:01:05.971152-05","9000","0"
"bfe14fb3-2040-4ece-bd99-51fe31eabfc4","bond4","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14
15:06:01.657521-05","2012-11-14 16:01:05.972706-05","1500","0"
"7d544efc-9942-4596-990a-9e6841d592d1","bond3","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14
15:06:01.660389-05","2012-11-14 16:01:05.974151-05","1500","0"
"238cbbc3-b1e0-404e-bf1d-e1ab95eed352","bond0","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14
15:06:01.663768-05","2012-11-14 16:01:05.975702-05","1500","0"
"8c081d29-86a0-46e7-8bf9-89c7c17bf24b","bond1","","ec7b4186-2e95-11e2-abe4-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-11-14
15:06:01.666703-05","2012-11-14 16:01:05.977166-05","1500","0"
"f88cfbee-1468-4e53-8fd8-7285ff46dede","bond4","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
16:25:13.434369-04","2012-11-14 15:11:13.885784-05","1500","0"
"369b0757-078a-4b18-b0de-d42cca1bcbad","bond3","","88089a7c-124e-11e2-877b-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
16:25:13.438335-04","2012-11-14 15:11:13.888115-05","1500","0"
"42825d0d-acb0-46e0-b84d-aee4cdee3f55","em1","ovirtmgmt","e5a52b3c-0f10-11e2-94c2-52540021f621","84:8f:69:75:50:f6","","","","","","1000","192.168.119.188","255.255.255.0","192.168.119.110","1","2","2012-10-05
13:25:47.081134-04","2012-11-14 15:11:15.811989-05","1500","1"
"774504e6-ad28-419f-84ba-b5d138462472","em2","","e5a52b3c-0f10-11e2-94c2-52540021f621","84:8f:69:75:50:f8","","","","","","1000","10.10.5.104","255.255.255.0","","","0","2012-10-05
13:25:47.089057-04","2012-11-14 15:11:15.817492-05","9000","0"
"bfe6b177-dd9f-4a93-a362-fcb179b9b11b","bond4","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05
13:25:47.092754-04","2012-11-14 15:11:15.819832-05","1500","0"
"ab7a9220-e82d-4e53-b685-ca2b72c39dd2","bond3","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05
13:25:47.096358-04","2012-11-14 15:11:15.822037-05","1500","0"
"f29d29c7-15c8-4879-bd8e-e0b22ce42a39","bond0","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05
13:25:47.100471-04","2012-11-14 15:11:15.82839-05","1500","0"
"d9be872b-2114-47a6-99ae-8be459c9e79a","bond1","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05
13:25:47.10407-04","2012-11-14 15:11:15.831098-05","1500","0"
"d689ce0e-fdce-4460-a7d9-db70dbd5361e","bond2","","e5a52b3c-0f10-11e2-94c2-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-05
13:25:47.107418-04","2012-11-14 15:11:15.833994-05","1500","0"
"59d3a367-818f-4264-99d2-98c8114f8b5e","bond4","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
12:36:20.423303-04","2012-11-14 15:11:18.744598-05","1500","0"
"b0369321-0285-4757-b991-8c2e74f33706","bond3","","acb1a7d6-122d-11e2-9f25-52540021f621","00:00:00:00:00:00","1","","","","","","","","","0","0","2012-10-09
12:36:20.426796-04","2012-11-14 15:11:18.750523-05","1500","0"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20121115/9e210ad7/attachment-0001.html>