<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Fri, Jul 8, 2016 at 4:46 PM, Gianluca Cecchi <span dir="ltr">&lt;<a href="mailto:gianluca.cecchi@gmail.com" target="_blank">gianluca.cecchi@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir="ltr"><span class=""><br><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jul 8, 2016 at 12:56 PM, Michal Skrivanek <span dir="ltr">&lt;<a href="mailto:michal.skrivanek@redhat.com" target="_blank">michal.skrivanek@redhat.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><span><br>
&gt; On 05 Jul 2016, at 11:05, Gianluca Cecchi &lt;<a href="mailto:gianluca.cecchi@gmail.com" target="_blank">gianluca.cecchi@gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt; Hello,<br>
&gt; I have problems configuring and testing serial console in 4.0<br>
&gt;<br>
&gt; As soon as in web admin portal (connected as admin) I click on top right &quot;admin@internal-authz&quot; --&gt; options to add the publc key I get this in engine.log (no errors yet in gui):<br>
&gt;<br>
&gt;<br>
&gt; 2016-07-05 10:59:21,667 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-63) [] Query &#39;GetUserProfileQuery&#39; failed: PreparedStatementCallback; bad SQL grammar [select * from  getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet.<br>
&gt; 2016-07-05 10:59:21,668 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-63) [] Exception: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from  getuserprofilebyuserid(?)]; nested exception is org.postgresql.util.PSQLException: The column name user_portal_vm_auto_login was not found in this ResultSet.<br>
<br>
</span>perhaps some issue with upgrade? There’s no catch in the upgrade script so it sounds weird, and it works fine on my upgraded setup.<br>
But anyway, can you check your db if it has that user_portal_vm_auto_login column in user_profiles table at all?<br>
<br>
Thanks,<br>
michal<br>
<div><div><br></div></div>
<br>
</blockquote></div><br></div><div class="gmail_extra"><br></div></span><div class="gmail_extra">It seems not...</div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">engine=# \d user_profiles</div><div class="gmail_extra">     Table &quot;public.user_profiles&quot;</div><div class="gmail_extra">      Column       | Type | Modifiers </div><div class="gmail_extra">-------------------+------+-----------</div><div class="gmail_extra"> profile_id        | uuid | not null</div><div class="gmail_extra"> user_id           | uuid | not null</div><div class="gmail_extra"> ssh_public_key    | text | </div><div class="gmail_extra"> ssh_public_key_id | uuid | </div><div class="gmail_extra">Indexes:</div><div class="gmail_extra">    &quot;pk_profile_id&quot; PRIMARY KEY, btree (profile_id)</div><div class="gmail_extra">    &quot;idx_user_profiles_user_id&quot; btree (user_id)</div><div class="gmail_extra">Foreign-key constraints:</div><div class="gmail_extra">    &quot;fk_user_id&quot; FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE</div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">engine=# select count(*) from user_profiles;</div><div class="gmail_extra"> count </div><div class="gmail_extra">-------</div><div class="gmail_extra">     1</div><div class="gmail_extra">(1 row)</div><div class="gmail_extra"><br></div><div class="gmail_extra">Any upgrade log file to cross-check what has caused problems in upgrading the table&#39;s structure?</div><div class="gmail_extra"><br></div><div><br></div></div></div></div>
</blockquote></div><br></div><div class="gmail_extra">BTW: how to run the script validatedb.sh in /usr/share/ovirt-engine/setup/dbutils ?</div><div class="gmail_extra"><br></div></div>