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@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@cloud-mgmt dbscripts]# pwd
/usr/share/ovirt-engine/dbscripts
[root@cloud-mgmt dbscripts]#
-------------------

Thanks,
Punit



Punit,

Create that script manually, Refer : https://www.mail-archive.com/[email protected]/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 <[email protected] <mailto:[email protected]>> 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.





_______________________________________________
Users mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/users

Reply via email to