Server Installation question

[jagdeep]

Hi, I am installing the evaluation version of the JON server. From the browser window, I used the default settings, and clicked on the 'INstall JON Server' option. It seems to install fine and I am led to a username / password screen.
Which username / password is this? I don't recall setting any except for the prosgres DB user. I tried some that I found under the rhq_subject and rhq_system_config tables, but they don't work. The conf file also does not seem to have any.
Do let me know.

[aamonten]

rhqadmin/rhqadmin should do it

[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?

[ips]

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

[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?

[aamonten]

"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?

[aamonten]

"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

[ips]

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.

[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.

[akostadinov]

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.