Hi, Noam, looks like this is a bug in the free text comment, can you check it? I think this may be the issue. http://gerrit.ovirt.org/18061
Thx, Laszlo ----- Original Message ----- > From: "Andrew Lau" <and...@andrewklau.com> > To: users@ovirt.org > Sent: Wednesday, August 14, 2013 8:35:03 AM > Subject: [Users] oVirt API Code 500 with Foreman > > Hi, > > Foreman guys say this is probably an oVirt side issue.. > > I was successfully able to hook up my foreman server to the oVirt datacenter > using the compute resources section. It detected the available datacenters > and logged in fine. Logs showed code 200, I can view the VMs available, > power them on and shut them down from the foreman UI. > > But when I go to hosts->New Host and select oVirt I get the error: > > Error loading virtual machine information: Internal Server Error > > Logs are showing: > > Operation FAILED: statementcallback; bad sql grammar select * from (select * > from vds groups view where ( vds group id in (select vds groups storage > domain.vds group id from vds groups storage domain left outer join storage > pool with storage domain on vds groups storage domain.storage pool > id=storage pool with storage domain.id where ( storage pool with storage > domain.name like '%dc_01%' or storage pool with storage domain.description > like '%dc_01%' or storage pool with storage domain.comment like '%dc_01%' ) > )) order by name asc ) as t1 offset (1 -1) limit 100; nested exception is > org.postgresql.util.psqlexception: error: column storage pool with storage > domain.comment does not exist > position: 421 > Rendered common/500.html.erb (5.2ms) > Completed 500 Internal Server Error in 150ms (Views: 6.0ms | ActiveRecord: > 0.3ms) > > CentOS 6.4 - Foreman 1.2 > CentOS 6.4 - oVirt 3.3 Nightly > > Any suggestions? > > Thanks, > Andrew. > > _______________________________________________ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
