<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jul 8, 2016 at 5:39 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"><div><div class="h5"><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><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></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>
</blockquote></div><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">ok, based on timestamp of engine upgrade</div><div class="gmail_extra"><br></div><div class="gmail_extra">-rw-r--r--. 1 root root 3332293 Jul 4 16:12 ovirt-engine-setup-20160704160226-xvkjw9.log<br></div><div class="gmail_extra"><br></div><div class="gmail_extra"> I indeed find this ERROR in engine.log that didn't raised any block from what I remember:<br></div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">2016-07-04 16:19:42,090 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-59) [] Query 'GetUserProfileQuery' faile</div><div class="gmail_extra">d: PreparedStatementCallback; bad SQL grammar [select * from getuserprofilebyuserid(?)]; nested exception is <a href="http://org.postgresql.util.PS">org.postgresql.util.PS</a></div><div class="gmail_extra">QLException: The column name user_portal_vm_auto_login was not found in this ResultSet.</div><div class="gmail_extra">2016-07-04 16:19:42,091 ERROR [org.ovirt.engine.core.bll.GetUserProfileQuery] (default task-59) [] Exception: org.springframework.jd</div><div class="gmail_extra">bc.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.</div><div class="gmail_extra"> at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99) [spring-jdbc.jar:4.2.4.RELEASE]</div><div class="gmail_extra"> at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) [spring-jdbc.jar:4.2.4.RELEASE]</div><div class="gmail_extra"> </div><div><br></div><div>Take in mind that I was in 3.6.5 when I upgraded to 4.0.</div><div>Find full engine.log starting beginning of day of update here:</div><div><a href="https://drive.google.com/file/d/0BwoPbcrMv8mvVy02b3FpZHRCNUE/view?usp=sharing">https://drive.google.com/file/d/0BwoPbcrMv8mvVy02b3FpZHRCNUE/view?usp=sharing</a><br></div><div><br></div><div>and log of engine-setup here:</div><div><a href="https://drive.google.com/file/d/0BwoPbcrMv8mvcnNEZzRralR1ZTA/view?usp=sharing">https://drive.google.com/file/d/0BwoPbcrMv8mvcnNEZzRralR1ZTA/view?usp=sharing</a><br></div><div><br></div><div>HIH debugging</div><div><br></div><div>Gianluca</div></div></div>