<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<div class="moz-cite-prefix">On 09/08/2014 08:41 PM, Punit Dambiwal
wrote:<br>
</div>
<blockquote
cite="mid:CAGZcrBkYRgZc1w3+-E2qzXqGUhtaSuFfODDyM6L1oYCYy2G7Tw@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Prasad,
<div><br>
</div>
<div>Yes..I am running Ovirt 3.4 but still didn't find the
scripts on the location :- </div>
<div><br>
</div>
<div>-------------------</div>
<div>
<div>[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
;"</div>
<div>sh: engine-psql.sh: No such file or directory</div>
<div>[root@cloud-mgmt dbscripts]# pwd</div>
<div>/usr/share/ovirt-engine/dbscripts</div>
<div>[root@cloud-mgmt dbscripts]#</div>
</div>
<div>-------------------</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Punit</div>
</div>
<div class="gmail_extra"><br>
<br>
</div>
</blockquote>
<br>
Punit,<br>
<br>
Create that script manually, Refer :
<a class="moz-txt-link-freetext" href="https://www.mail-archive.com/users@ovirt.org/msg20467.html">https://www.mail-archive.com/users@ovirt.org/msg20467.html</a><br>
or you can simply run ;<br>
<br>
<pre class="plain" name="code">#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 ;"
</pre>
Thanks,<br>
Prasad Mukhedkar<br>
<br>
<blockquote
cite="mid:CAGZcrBkYRgZc1w3+-E2qzXqGUhtaSuFfODDyM6L1oYCYy2G7Tw@mail.gmail.com"
type="cite">
<div class="gmail_extra">
<div class="gmail_quote">On Mon, Sep 8, 2014 at 4:44 PM, Prasad
Mukhedkar <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:prasad@mukhedkar.com" target="_blank">prasad@mukhedkar.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><span
class=""><br>
On 09/08/2014 01:53 PM, Punit Dambiwal wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
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...<br>
</blockquote>
</span>
If you're on 3.4, You will fine the above script at
/usr/share/ovirt-engine/dbscripts location on your ovirt
engine system.<span class=""><br>
<br>
|Secondly yes i am referring the Template CentOS...every
details i provide you in the previous mail is correct...<br>
<br>
</span>
show us "qemu-img info" output.<br>
<br>
<br>
<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>