-
1. Re: Server Installation question
aamonten Jul 30, 2008 3:04 PM (in response to jagdeep)rhqadmin/rhqadmin should do it
-
2. Re: Server Installation question
jagdeep Jul 30, 2008 3:42 PM (in response to jagdeep)I tried, did not work. Any other suggestions? A quick look at the logs also does not tell me anything. Where can I look for this username/password? is it somewhere in the DB?
-
3. Re: Server Installation question
ips Jul 30, 2008 3:51 PM (in response to jagdeep)Yeah, it's in the RHQ_PRINCIPAL table, though the password column is encrypted. After a fresh install, my RHQ_PRINCIPAL table looks as follows:
ID PRINCIPAL PASSWORD
----------------------------------------------------------
2 rhqadmin x1XwrxKuPvYUILiOnOZTLg==
-Ian -
4. Re: Server Installation question
jagdeep Jul 30, 2008 4:18 PM (in response to jagdeep)I see....my bad...in all my trial and errors to get this thing going, I changed it to a simple password.....any way out? or do I need to reinstall postgres?
-
5. Re: Server Installation question
aamonten Jul 30, 2008 4:30 PM (in response to jagdeep)"ips" wrote:
Yeah, it's in the RHQ_PRINCIPAL table, though the password column is encrypted. After a fresh install, my RHQ_PRINCIPAL table looks as follows:
ID PRINCIPAL PASSWORD
----------------------------------------------------------
2 rhqadmin x1XwrxKuPvYUILiOnOZTLg==
-Ian
Mine is also the same values.. can you not switch to these values in the table? -
6. Re: Server Installation question
aamonten Jul 30, 2008 4:34 PM (in response to jagdeep)"jagdeep" wrote:
I see....my bad...in all my trial and errors to get this thing going, I changed it to a simple password.....any way out? or do I need to reinstall postgres?
what do you mean by simple password? not encrypted? If then two options:
1) that the encryption is hard coded.. then you have no other option than reinstall
2) that the encryption is by config.. then you can switch it.. I will check out and let you know -
7. Re: Server Installation question
ips Jul 30, 2008 4:35 PM (in response to jagdeep)I would just use direct SQL and update the value of the password column for the "rhqadmin" row to "x1XwrxKuPvYUILiOnOZTLg==", which should be "rhqadmin" in encrypted form.
-
8. Re: Server Installation question
jagdeep Jul 30, 2008 5:06 PM (in response to jagdeep)thanks ips and aamonten,
I used an update query to set the password back to the encrypted string provided, and finally I can log in to the ops network portal with rhqadmin/rhqadmin.
thanks. -
9. Re: Server Installation question
akostadinov Dec 19, 2011 3:49 PM (in response to aamonten)Thanks, this seems to be a good way to reset a lost rhqadmin password. Perhaps this can be mentioned in documentation? It was *really* a pain to find this thread.