Bug 1429246

Description of problem:

I've imported a number of VMs that I previously was running under a
self-hosted libvirt configuration. Most of the VMs at the source did not
have a cdrom device (though some did) because I just added one as required.

Now that the VMs have been imported into oVirt, none of them have a
cdrom device. Even booting with the "Attach CD" option doesn't create a
cdrom device.

Version-Release number of selected component (if applicable):

4.1.0.3-1.el7.centos

How reproducible:

None of the VMs from this source have a cdrom device after import. I have not tried importing from other sources.

Steps to Reproduce:
1. Set up a libvirt provider.
2. Import a VM from it.

Actual results:
No cdrom device in the "Vm Devices" tab.

Expected results:
There should be a cdrom device listed.

Additional info:

The source libvirt system is running Debian Stretch with libvirt 3.0.0 and qemu 2.8.0.

I discussed this briefly on ovirt-users. The thread starts with Message-ID: <85be3a0e-7940-1923-c2ca-b05f67f3d667>

The workaround discussed works:

insert into vm_device (device_id, vm_id, type, device, is_managed, is_plugged, is_readonly, address) values (uuid_generate_v1(), (select vm_guid from vm_static where vm_name='your-vm-name'), 'disk', 'cdrom', 't', 't', 't', '');