----- Original Message ----- > From: "Gianluca Cecchi" <gianluca.cec...@gmail.com> > To: "users" <users@ovirt.org> > Sent: Sunday, February 2, 2014 3:56:25 PM > Subject: [Users] How to scratch previous versions reports and dwh > installation? > > Hello, > I have some problems, I think they are also due to PosgreSQL access > rules changes from f18 to f19. > In particular if one has passed from fedora 18 to Fedora 19 and form > 3.2 to 3.3 as I did; see > https://bugzilla.redhat.com/show_bug.cgi?id=1009335 > > Right now I have a problem with my AIO installation where trying to > upgrade from 3.3.2 to 3.3.3 I got many problems related to RDBMS.
Is this related to dwh/reports? > > Is there a way to completely get rid of prevous installtion and > reinstall cleanly in 3.3.3 as I did on another system without getting > problems. So you want to delete dwh/reports only or also the engine? > > I tried removing packages: > yum remove ovirt-engine-dwh ovirt-engine-reports > > and deleting related databases: > > drop database ovirt_engine_history; > drop database ovirtenginereports; This might not be enough. Sadly there is currently no cleanup tool for dwh/reports, similar to engine-cleanup for the engine. For things to delete look at /etc/ovirt*dwh* /etc/ovirt-*reports* /etc/ovirt-engine/*dwh* /etc/ovirt-engine/*reports* /var/lib/ovirt-engine/deployments/*reports* > > But then trying to install again packages and runnign setup I get this in > log: > > 2014-01-30 00:37:30::DEBUG::common_utils::446::root:: running sql > query on host: localhost, port: 5432, db: ovirt_engine_history, user: > engine, query: 'select 1 from history_configuration;'. > 2014-01-30 00:37:30::DEBUG::common_utils::907::root:: Executing > command --> '/usr/bin/psql --pset=tuples_only=on --set ON_ERROR_STOP=1 > --dbname ovirt_engine_history --host localhost --port 5432 --username > engine -w -c select 1 from history_configuration;' in working > directory '/root' > 2014-01-30 00:37:30::DEBUG::common_utils::962::root:: output = > 2014-01-30 00:37:30::DEBUG::common_utils::963::root:: stderr = ERROR: > relation "history_configuration" does not exist > LINE 1: select 1 from history_configuration; This in itself is not necessarily a problem, unless of course setup failed immediately after that. Which versions of relevant packages? Can you please post full logs? > > > Can anyone tell if I have to run any other purge operation, suche as > any users or table on engine db itself? IIRC nothing in the engine db itself. Didn't check that, though. > And also what would be the expected configuration of > /var/lib/pgsql/data/pg_hba.conf Manually-edited? On a remote database server? Or local, letting the setup programs edit it for you? Please post it if you have a specific problem that you think might be related. > and eventually > /var/lib/pgsql/data/postgresql.conf Only max_connections is edited by setup, to be 150. For a remote database you want to change listen_addresses. > for a fedora 19 system so that a setup for reports and dwh could complete? In general, on a clean system, with a local database, the setup programs should do what's needed and no manual fixes are needed. Do note that, as Yaniv mentioned earlier, 3.3.3 should be used when released. 3.3.3-beta might probably be good enough if you can't wait. Regards, -- Didi _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users