Re: [ovirt-users] serial console problem in 4.0

> On 05 Jul 2016, at 11:05, Gianluca Cecchi <gianluca.cecchi(a)gmail.com&gt; wrote: > > Hello, > I have problems configuring and testing serial console in 4.0 > > 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): > > > 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. > 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. 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. But anyway, can you check your db if it has that user_portal_vm_auto_login column in user_profiles table at all? Thanks, michal