HPSIM on Linux

[Chammond]

When HPSIM is installed under Linux and the Database is created using PostgreSQL, what is used for the password for the Database connection? I found everything I need to connect to the Database except the password and I have tried all the passwords that have been set on this box since it was created.

Thanks

[David Claypool]

A very long random string is generated and used for the password. You can use mxpassword to retrieve it.

[Chammond]

Thanks David, that is what I have been working with trying to figure it out. However, an mxpassword -l only shows the MxSshKeyPassword and nothing else. Is this something that has to be done from the mxpassword GUI?

[Lars Nilsson_1 · Accepted solution]

According to my experience you could retrieve the mxdbuserpassword in earlier versions of HPSIM(4.x) with mxpassword -l. In recent version you can't.

If you want to make a database connection you have to set a new password.

To change the password, at the HP SIM command line enter the following:
/opt/mx/bin/mxpassword -m -x MxDBUserPassword=newpassword

[Chammond]

Thanks to both of you for your replies. I did finally find the command mention in the second reply but I managed to dork it up somehow and killed access to the database. So I just reinstalled a fresh copy of 5.0.2 and rediscovered. It is still a pre-production device and lots of playing is being done so nothing was lost.

Thanks again

Chris

[Chammond]

After a slow response from the system, I am close out this thread. It took forever just to assign points.