[ovirt-users] Template Size different in dashboard and storage...

[Prasad Mukhedkar]

On 09/08/2014 08:41 PM, Punit Dambiwal wrote:
> Hi Prasad,
>
> Yes..I am running Ovirt 3.4 but still didn't find the scripts on the 
> location :-
>
> -------------------
> [root at cloud-mgmt dbscripts]# sh engine-psql.sh -c "select vm_name, 
> image_group_id,image_guid from vm_device, vm_static,images where 
> vm_name in('CentOS') and vm_device.type='disk' and 
> vm_device.device='disk' and vm_device.vm_id=vm_static.vm_guid and 
> images.image_group_id=vm_device.device_id order by vm_name ;"
> sh: engine-psql.sh: No such file or directory
> [root at cloud-mgmt dbscripts]# pwd
> /usr/share/ovirt-engine/dbscripts
> [root at cloud-mgmt dbscripts]#
> -------------------
>
> Thanks,
> Punit
>
>

Punit,

  Create that script manually, Refer : 
https://www.mail-archive.com/users@ovirt.org/msg20467.html
or you can simply run ;

#source /etc/ovirt-engine/engine.conf.d/10-setup-database.conf

#PGPASSWORD=$ENGINE_DB_PASSWORD psql -U postgres -d engine -c  "select vm_name, image_group_id,image_guid from vm_device,
vm_static,images where vm_name in('CentOS') and vm_device.type='disk'
and vm_device.device='disk' and vm_device.vm_id=vm_static.vm_guid and
images.image_group_id=vm_device.device_id order by vm_name ;"

Thanks,
Prasad Mukhedkar

> On Mon, Sep 8, 2014 at 4:44 PM, Prasad Mukhedkar <prasad at mukhedkar.com 
> <mailto:prasad at mukhedkar.com>> wrote:
>
>
>     On 09/08/2014 01:53 PM, Punit Dambiwal wrote:
>
>         I didn't find this script "engine-psql.sh" in my engine
>         server,would you mind to let me know the exact path for this
>         script file...
>
>     If you're on 3.4, You will fine the above script at
>     /usr/share/ovirt-engine/dbscripts location on your ovirt engine
>     system.
>
>      |Secondly yes i am referring the Template CentOS...every details
>     i provide you in the previous mail is correct...
>
>     show us "qemu-img info" output.
>
>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20140909/17f68073/attachment-0001.html>