<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"><<a href="mailto:gianluca.cecchi@gmail.com" target="_blank">gianluca.cecchi@gmail.com</a>></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"><<a href="mailto:michal.skrivanek@redhat.com" target="_blank">michal.skrivanek@redhat.com</a>></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>
> On 05 Jul 2016, at 11:05, Gianluca Cecchi <<a href="mailto:gianluca.cecchi@gmail.com" target="_blank">gianluca.cecchi@gmail.com</a>> wrote:<br>
><br>
> Hello,<br>
> I have problems configuring and testing serial console in 4.0<br>
><br>
> As soon as in web admin portal (connected as admin) I click on top right "admin@internal-authz" --> options to add the publc key I get this in engine.log (no errors yet in gui):<br>
><br>
><br>
> 2016-07-05 10:59:21,667 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-63) [] Query 'GetUserProfileQuery' 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>
> 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 "public.user_profiles"</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"> "pk_profile_id" PRIMARY KEY, btree (profile_id)</div><div class="gmail_extra"> "idx_user_profiles_user_id" btree (user_id)</div><div class="gmail_extra">Foreign-key constraints:</div><div class="gmail_extra"> "fk_user_id" 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'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>