This is a multi-part message in MIME format.
--------------030301020606010700010503
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
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/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(a)mukhedkar.com
<mailto:prasad@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.
--------------030301020606010700010503
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<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&quo...
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(a)mukhedkar.com</a>&gt;</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>
--------------030301020606010700010503--