<div dir="ltr"><div>The hosts are setup to use secure connection so they will definitely whack out for sure. What you can do is to place the hosts into maintenance. Then make the dbase changes then restart the engine and re-add the hosts so they get configured properly with the new changes.<br>
</div>- DHC <br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Mar 13, 2013 at 1:56 AM, Karli Sjöberg <span dir="ltr">&lt;<a href="mailto:Karli.Sjoberg@slu.se" target="_blank">Karli.Sjoberg@slu.se</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>





<div>
tis 2013-03-12 klockan 16:38 -0500 skrev Dead Horse:
<div class="im"><blockquote type="CITE">Remote console access IMHO is still a very weak point in ovirt/RHEV. SPICE is a very nice protocol but IMHO is in dire need of a platform independent client and tighter integration into the user and web portals. Something I have done
 to workaround issues like these is to disable spice certificate checking and SSL.<br>
<br>
<pre>psql engine -U postgres -c &quot;UPDATE vdc_options set option_value = &#39;false&#39; where option_name = &#39;SSLEnabled&#39;&quot;
psql engine -U postgres -c &quot;UPDATE vdc_options set option_value = &#39;false&#39; where option_name = &#39;UseSecureConnectionWithServers&#39;&quot;
psql engine -U postgres -c &quot;UPDATE vdc_options set option_value = &#39;false&#39; where option_name =&#39;EnableSpiceRootCertificateValidation&#39;
- DHC
</pre>
</blockquote></div>
I tried those modifications to the database and restarted the engine which became very upset about it and couldn´t establish connections with any Hosts. I imagine I´d have to go around all config files on all machines involved so that no one tries to use any
 SSL for the changes to work, Since I just wanted to use it as a temporary solution until it was fixed for real, I didn´t want to make too much of a change from the standard config, and I think that encryption is a must on a network as open as ours any way.
 I reverted the database changes and restarted the engine again.<br>
<br>
The only solution presented this far has been trying 3.2 instead of our current 3.1, where &quot;engine-upgrade&quot; is the road-block hindering at this point.<span class="HOEnZb"><font color="#888888"><br>
<br>
/Karli</font></span><div><div class="h5"><br>
<br>
<blockquote type="CITE">&nbsp; </blockquote>
<blockquote type="CITE"><br>
<br>
</blockquote>
<blockquote type="CITE">On Fri, Mar 8, 2013 at 10:22 AM, Michal Skrivanek &lt;<a href="mailto:michal.skrivanek@redhat.com" target="_blank">michal.skrivanek@redhat.com</a>&gt; wrote:
</blockquote>
<blockquote type="CITE">
<blockquote><br>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>On 8 Mar 2013, at 15:51, Karli Sjöberg wrote: </blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote><br>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<blockquote type="CITE">tor 2013-03-07 klockan 13:52 +0100 skrev David Ja¹a:
<blockquote type="CITE">
<pre>Hi,

Karli Sjöberg pí¹e v Èt 07. 03. 2013 v 10:01 +0000:
&gt; Hi, it me again,
&gt; 
&gt; the last time this was discussed, the problem seemed to be centred
&gt; around Win/IE, but since patching to:
&gt; # rpm -qa | grep ovirt
&gt; ovirt-engine-config-3.1.0-4.fc17.noarch
&gt; ovirt-engine-dbscripts-3.1.0-4.fc17.noarch
&gt; ovirt-log-collector-3.1.0-0.git10d719.fc17.noarch
&gt; ovirt-engine-restapi-3.1.0-4.fc17.noarch
&gt; ovirt-image-uploader-3.1.0-0.git9c42c8.fc17.noarch
&gt; ovirt-engine-genericapi-3.1.0-4.fc17.noarch
&gt; ovirt-iso-uploader-3.1.0-0.git1841d9.fc17.noarch
&gt; ovirt-engine-webadmin-portal-3.1.0-4.fc17.noarch
&gt; ovirt-engine-setup-3.1.0-4.fc17.noarch
&gt; ovirt-engine-sdk-3.2.0.2-1.fc17.noarch
&gt; ovirt-engine-backend-3.1.0-4.fc17.noarch
&gt; ovirt-engine-tools-common-3.1.0-4.fc17.noarch
&gt; ovirt-engine-3.1.0-4.fc17.noarch
&gt; ovirt-engine-userportal-3.1.0-4.fc17.noarch
&gt; ovirt-engine-notification-service-3.1.0-4.fc17.noarch
&gt; 
&gt; No one is able to connect to a spice console though the Userportal at
&gt; all. 

Looks like no one is getting host subject - again. Tomá¹?
</pre>
</blockquote>
<br>
Come on guys, please tell me if there´s anything we can do to troubleshoot this issue, to help solve a real show-stopper for us!<br>
<br>
</blockquote>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>Would you be able to try it in 3.2? </blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>It was known to be broken somewhere around 3.1 release&hellip;. </blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote><br>
<br>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>Thanks, </blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>michal </blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote><br>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<blockquote type="CITE"><br>
In using oVirt, our organisation is so close to being able to ship out thin-client kiosks instead of buying expensive new HW on a yearly basis, and have our users access their desktops from practically anywhere, even from home if they´d wish. The rest of the
 entire system works flawlessly, just to fall flat on it´s face right on the finish line. I think that is so sad and silly, because I really love the rest of this product! We´ve set up oVirt-3.1, made a POC template, defined a pool and have been able to have
 them prestarted as well. But if our users aren´t able to access their console in a seamless, easy way, then what good is it? And knowing that the console works just fine from the adminportal in several different client systems (Fedora, CentOS, Win7) makes
 me hope that it´s just this small, yet important piece that needs to be corrected.<br>
<br>
Anxiously awaiting your response<br>
Karli Sjöberg<br>
<br>
<br>
<blockquote type="CITE">
<pre>David

&gt; I´ve tried this from my workstation, running Fedora 17:
&gt; ================================================================================
&gt; $ SPICEC_DEBUG_LEVEL=0 firefox
&gt; (plugin-container:18293): SpiceXPI-CRITICAL **: controller connect:
&gt; Filen eller katalogen finns inte
&gt; (plugin-container:18293): SpiceXPI-CRITICAL **: controller connect:
&gt; Filen eller katalogen finns inte
&gt; (plugin-container:18293): SpiceXPI-CRITICAL **: could not get browser
&gt; window, when trying to call OnDisconnected
&gt; ================================================================================
&gt; 
&gt; 
&gt; Here´s a collegue of mine, running Win7/IE9:
&gt; ================================================================================
&gt; 1362648766 INFO [7196:5208] spicex_init_logger: started
&gt; 1362648766 DEBUG [7196:5208] COSpiceX::put_DynamicMenu: DynamicMenu
&gt; 1362648766 INFO [7196:5208] COSpiceX::put_FullScreen: New FullScreen
&gt; request newVal=0xffffffff
&gt; 1362648766 DEBUG [7196:5208] COSpiceX::Connect: Running spicec (C:
&gt; \Users\jope\AppData\Local\virt-viewer\bin\remote-viewer.exe
&gt; --spice-controller)
&gt; 1362648766 INFO [7196:5208] COSpiceX::Connect: spicec pid 1640
&gt; 1362648766 DEBUG [7196:5208] COSpiceX::Connect: connecting to spice
&gt; client&#39;s pipe
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_init: sending init
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_wstr: sending msg id 1 :
&gt; str 130.238.96.135 (1)
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_value: sending msg id 2
&gt; value 5906
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_value: sending msg id 3
&gt; value 5907
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_wstr: sending password
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_wstr: sending msg id 11 :
&gt; str IT-Avdelningen-1:%d - Press SHIFT+F12 to Release Cursor (1)
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_value: sending msg id 10
&gt; value 1
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_wstr: sending msg id 14 :
&gt; str release-cursor=shift+f12,toggle-fullscreen=shift+f11 (1)
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_wstr: sending msg id 5 :
&gt; str main,inputs,scursor,splayback,srecord,sdisplay (1)
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_wstr: sending msg id 7 :
&gt; str DEFAULT (1)
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_wstr: sending msg id 8 :
&gt; str C:\Users\jope\AppData\Local\Temp\truststore.pem (1)
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_msg: sending msg id 16
&gt; 1362648767 DEBUG [7196:5208] COSpiceX::send_msg: sending msg id 17
&gt; 1362648767 INFO [7196:5208] COSpiceX::ExecuteUsbCtrl: USB sharing is
&gt; not requested
&gt; 1362648771 INFO [7196:7480] COSpiceX::event_thread: exit_code=0
&gt; error_code=1
&gt; ================================================================================
&gt; 
&gt; 
&gt; And another collegue running CentOS-6.3/Firefox:
&gt; ================================================================================
&gt; 2013-03-07 09:42:41,651 DEBUG nsPluginInstance::SetHostIP:
&gt; 130.238.96.132
&gt; 2013-03-07 09:42:41,652 DEBUG nsPluginInstance::SetPort: 5900
&gt; 2013-03-07 09:42:41,652 DEBUG nsPluginInstance::SetTitle:
&gt; IT-Avdelningen-2:%d - Press SHIFT+F12 to Release Cursor
&gt; 2013-03-07 09:42:41,652 DEBUG nsPluginInstance::SetDynamicMenu: 
&gt; 2013-03-07 09:42:41,652 DEBUG nsPluginInstance::SetFullScreen: 1
&gt; 2013-03-07 09:42:41,652 DEBUG nsPluginInstance::SetPassword: Password
&gt; set
&gt; 2013-03-07 09:42:41,652 DEBUG nsPluginInstance::SetNumberOfMonitors: 1
&gt; 2013-03-07 09:42:41,652 DEBUG nsPluginInstance::SetUsbListenPort: 0
&gt; 2013-03-07 09:42:41,652 DEBUG nsPluginInstance::SetAdminConsole: 1
&gt; 2013-03-07 09:42:41,653 DEBUG nsPluginInstance::SetSecurePort: 5901
&gt; 2013-03-07 09:42:41,653 DEBUG nsPluginInstance::SetSSLChannels:
&gt; original channels: smain,sinputs,scursor,splayback,srecord,sdisplay
&gt; 2013-03-07 09:42:41,653 DEBUG nsPluginInstance::SetSSLChannels:
&gt; modified channels: main,inputs,cursor,playback,record,display
&gt; 2013-03-07 09:42:41,653 DEBUG nsPluginInstance::SetGuestHostName:
&gt; IT-Avdelningen-2
&gt; 2013-03-07 09:42:41,653 DEBUG nsPluginInstance::SetCipherSuite:
&gt; DEFAULT
&gt; 2013-03-07 09:42:41,653 DEBUG nsPluginInstance::SetTrustStore:
&gt; Certificate:
&gt;     Data:
&gt;         Version: 3 (0x2)
&gt;         Serial Number: 15 (0xf)
&gt;         Signature Algorithm: sha1WithRSAEncryption
&gt;         Issuer: C=US, O=SLU, CN=CA-storm.slu.se.80985
&gt;         Validity
&gt;             Not Before: Sep 26 14:21:06 2012
&gt;             Not After : Sep 25 12:21:06 2022 GMT
&gt;         Subject: C=US, O=SLU, CN=CA-storm.slu.se.80985
&gt;         Subject Public Key Info:
&gt;             Public Key Algorithm: rsaEncryption
&gt;                 Public-Key: (1024 bit)
&gt;                 Modulus:
&gt;                     00:a2:94:89:18:26:79:49:6b:c6:28:6c:f2:95:e9:
&gt;                     a7:71:00:22:c6:79:c2:9e:10:63:ef:34:5c:ab:62:
&gt;                     36:a0:7a:84:d0:79:77:4c:9d:3d:39:8f:97:93:c5:
&gt;                     f6:fb:5b:0b:f8:9b:ad:d8:53:2d:a6:b6:03:45:d4:
&gt;                     76:45:f1:af:99:42:74:07:4c:48:7d:28:96:31:9e:
&gt;                     88:cf:90:d9:e7:d9:cf:55:a8:bd:37:a0:8f:f1:26:
&gt;                     89:a9:ab:64:78:a4:02:60:9b:3a:a7:07:db:6e:75:
&gt;                     32:e5:8f:51:7f:50:02:15:d8:c8:7b:68:c1:54:e1:
&gt;                     9f:c2:d2:cf:53:c3:58:b3:15
&gt;                 Exponent: 65537 (0x10001)
&gt;         X509v3 extensions:
&gt;             X509v3 Subject Key Identifier: 
&gt; 
&gt; FE:8F:57:F1:A0:AF:45:36:9F:AC:C9:6B:EE:F9:D1:3E:18:78:B9:EA
&gt;             Authority Information Access: 
&gt;                 CA Issuers - URI:<a href="http://storm.slu.se/ca.crt" target="_blank">http://storm.slu.se:80/ca.crt</a>
&gt; 
&gt;             X509v3 Authority Key Identifier: 
&gt; 
&gt; keyid:FE:8F:57:F1:A0:AF:45:46:9F:NC:C9:6B:EE:F9:D1:3E:18:78:B9:EA
&gt;                 DirName:/C=US/O=SLU/CN=CA-storm.slu.se.80985
&gt;                 serial:0F
&gt; 
&gt;             X509v3 Basic Constraints: critical
&gt;                 CA:TRUE
&gt;             X509v3 Key Usage: critical
&gt;                 Certificate Sign, CRL Sign
&gt;     Signature Algorithm: sha1WithRSAEncryption
&gt;         45:e4:15:23:fa:55:78:89:24:66:7c:e2:33:41:ea:98:00:12:
&gt;         0c:25:e5:e6:3a:c7:f8:f9:4d:83:47:d3:80:9b:c0:78:bc:ab:
&gt;         61:ae:6d:a1:cf:43:cb:cb:31:2c:94:72:21:b0:58:f0:8b:69:
&gt;         0d:c4:73:f2:44:95:52:06:23:6c:71:7a:9b:fc:5f:98:21:35:
&gt;         26:e1:a3:bb:65:bb:d2:81:bb:48:96:99:b7:04:e6:15:af:93:
&gt;         a1:60:e4:bf:05:d3:b0:4b:e4:e2:4b:21:82:d7:2b:3d:19:ef:
&gt;         a4:5a:23:58:74:ef:1a:80:14:8b:89:b2:a7:bd:c2:21:66:1f:
&gt;         e0:7e
&gt; -----BEGIN CERTIFICATE-----
&gt; MIIC1DCCAj2gAwIBAgIBDzANBgkqhkiG9w0BAQUFADA7MQswCQYDVQQGEwJVUzEM
&gt; MAoGA1UEChMDU0xVMR4wHAYDVQQDExVDQS1zdG9ybS5zbHUuc2UuODA5ODUwIhcR
&gt; MTIwOTI2MTQyMTA2LTAxMDAXDTIyMDkyNTEyMjEwNlowOzELMAkGA1UEBhMCVVMx
&gt; DDAKBgNVBAoTA1NMVTEeMBwGA1UEAxMVQ0Etc3Rvcm0uc2x1LnNlLjgwOTg1MIGf
&gt; MA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCilIkYJnlJa8YobPKV6adxACLGecKe
&gt; EGPvNFyrYjageoTQeXdMnT05j5eTxfb7Wwv4m63YUy2mtgNF1HZF8a+ZQnQHTEh9
&gt; KJYxnojPkNnn2c9WqL03oI/xJompq2R4pAJgmzqnB9tudTLlj1F/UAIV2Mh7aMFU
&gt; 4Z/C0s9Tw1izFQIDAQABo4HjMIHgMB0GA1UdDgQWBBT+j1fxoK9FRp+syWvu+dE+
&gt; GHi56jA5BggrBgEFBQcBAQQtMCswKQYIKwYBBQUHMAKGHWh0dHA6Ly9zdG9ybS5z
&gt; bHUuc2U6ODAvY2EuY3J0MGMGA1UdIRcMFqAFP6PV/Ggr0VGn6zJa+750T4YeLnq
&gt; oT+kPTA7MQswCQYDVQQGEwJVUzEMMAoGA1UEChMDU0xVMR4wHAYDVQQDExVDQS1z
&gt; dG9ybS5zbHUuc2UuODA5ODWCAQ8wDwYDVR0TAQH/BAUwAwEB/zAOBgNVHQ8BAf8E
&gt; BAMCAQYwDQYJKoZIhvcNAQEFBQADgYEAReQVI/pVeIkkZnziM0HqmAASDCXl5jrH
&gt; +PlNg0fTgJvAeLyrYa5toc9Dy8sxLJRyIbBY8ItpDcRz8kSVUgYjbHF6m/xfmCE1
&gt; JuGju2W70oG7SGaZtwTmFa+ToWDkvwXTsEvk4kshgtcrPRnvpFojWHTvGoAUi4my
&gt; p73CIWYf4H4=
&gt; -----END CERTIFICATE-----
&gt; 
&gt; 2013-03-07 09:42:41,653 DEBUG nsPluginInstance::SetHotKeys:
&gt; release-cursor=shift+f12,toggle-fullscreen=shift+f11
&gt; 2013-03-07 09:42:41,653 DEBUG nsPluginInstance::SetNoTaskMgrExecution:
&gt; 0
&gt; 2013-03-07 09:42:41,654 DEBUG nsPluginInstance::SetSendCtrlAltDelete:
&gt; 0
&gt; 2013-03-07 09:42:41,654 DEBUG nsPluginInstance::SetUsbAutoShare: 1
&gt; 2013-03-07 09:42:41,654 DEBUG nsPluginInstance::SetUsbFilter:
&gt; -1,60186,10000,256,1|-1,1118,245,-1,1|-1,1133,2245,-1,1|-1,1133,2242,5,1|8,-1,-1,-1,1|7,-1,-1,-1,1|-1,-1,-1,-1,0
&gt; 2013-03-07 09:42:41,654 INFO  nsPluginInstance::Connect:
&gt; SPICE_XPI_SOCKET: /tmp/spicec-scQYmJ/spice-xpi
&gt; 2013-03-07 09:42:41,654 INFO  nsPluginInstance::Connect:
&gt; SPICE_FOREIGN_MENU_SOCKET: /tmp/spicec-scQYmJ/spice-foreign
&gt; 2013-03-07 09:42:41,655 DEBUG nsPluginInstance::Connect: Controller
&gt; pid: 10340
&gt; 2013-03-07 09:42:41,655 DEBUG QErrorHandler: Something went wrong:
&gt; connect error, 2
&gt; 2013-03-07 09:42:41,655 DEBUG SpiceController::Connect: Connect Error
&gt; 2013-03-07 09:42:41,655 DEBUG QErrorHandler: Something went wrong:
&gt; connect error, 2
&gt; 2013-03-07 09:42:41,655 DEBUG SpiceController::Connect: Connect Error
&gt; 2013-03-07 09:42:41,655 INFO  nsPluginInstance::Connect:
&gt; Launching /usr/libexec/spice-xpi-client 
&gt; 2013-03-07 09:42:42,655 DEBUG SpiceController::Connect: Connected!
&gt; 2013-03-07 09:42:44,723 INFO  nsPluginInstance::Connect: Initiating
&gt; connection with controller
&gt; 2013-03-07 09:42:48,652 DEBUG nsPluginInstance::ControllerWaitHelper:
&gt; Controller finished, pid: 10340, exit code: 0
&gt; 2013-03-07 09:42:48,653 ERROR nsPluginInstance::CallOnDisconnected:
&gt; could not get browser window, when trying to call OnDisconnected
&gt; ================================================================================
&gt; 
&gt; 
&gt; If there´s anything we can do to help resolve this issue once and for
&gt; all, just name it! It so hurts to see this otherwise great product
&gt; tripping over on it´s face so close to the finish line:(
&gt; 
&gt; Best Regards
&gt; Karli Sjöberg 
&gt; _______________________________________________
&gt; Users mailing list
&gt; <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>
&gt; <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a>

</pre>
</blockquote>
<br>
<br>
</blockquote>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<blockquote type="CITE">_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a>
</blockquote>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote><br>
<br>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote><br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
<br>
</blockquote>
</blockquote>
<blockquote type="CITE"><br>
<br>
</blockquote>
<br>
</div></div></div>

</blockquote></div><br></div>