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

On Fri, Jul 8, 2016 at 4:46 PM, Gianluca Cecchi <gianluca.cecchi(a)gmail.com > wrote: > > > On Fri, Jul 8, 2016 at 12:56 PM, Michal Skrivanek < > michal.skrivanek(a)redhat.com&gt; wrote: > >> >> > 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 >> >> >> > > It seems not... > > engine=# \d user_profiles > Table "public.user_profiles" > Column | Type | Modifiers > -------------------+------+----------- > profile_id | uuid | not null > user_id | uuid | not null > ssh_public_key | text | > ssh_public_key_id | uuid | > Indexes: > "pk_profile_id" PRIMARY KEY, btree (profile_id) > "idx_user_profiles_user_id" btree (user_id) > Foreign-key constraints: > "fk_user_id" FOREIGN KEY (user_id) REFERENCES users(user_id) ON > DELETE CASCADE > > > > engine=# select count(*) from user_profiles; > count > ------- > 1 > (1 row) > > Any upgrade log file to cross-check what has caused problems in upgrading > the table's structure? > > > BTW: how to run the script validatedb.sh in /usr/share/ovirt-engine/setup/dbutils ?