[Users] oVirt API Code 500 with Foreman

[Laszlo Hornyak]

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" <andrew at andrewklau.com>
> To: users at 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>