Red Hat Bugzilla – Bug 599733
installer doesn't tell me the db schema exists
Last modified: 2011-02-17 12:47:24 EST
Description of problem:
Upgrading from a previous version, and pointing the installer to the default DB settings, the installer didn't tell me that the db schema exists (and thus doesn't give me the drop down menu to pick if I want to overwrite or keep nor the drop down menu to say if this is a new server or an existing registered server. The only way for me to get them is to explicitly click the Test Connection button.
Install an old version of the server, get it running (I used the default postgres settings that come out of box - postgres on localhost, rhq database name and rhqadmin/rhqadmin as the credentials). Then shut it down, and install the new version. Go to the installer and see that you aren't told that the schema already exists nor can you tell you if you want this to be a new server or register it as one of the alerady existing ones. Then click the Test Connection button (without touching anything else) and see you get the drop down menus.
So what changed from 2.3.1? This would only have ever work for databases using the default username and password correct? Perhaps we just need an extra line in the UI saying "Please hit the Test Connection button to determine if you already an existing db schema at this location". The key thing to avoid is allowing people to overwrite existing schemas unwittingly.
this might not be a problem - I need to go back and check. Its possible that I wasn't connected to the database with the correct password and thus wasn't able to see the DB schema.
yeah, ok, this isn't a problem. At the most, we could do charles' suggestion, "an extra line in the UI saying "Please hit the Test Connection button to determine if you already an existing db schema at this location". lowering priority since this appears to be a minor annoyance.