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@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">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> --------------030301020606010700010503--