HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

PostgreSQL: Database access

 
martyatpb
Occasional Visitor

PostgreSQL: Database access

I have installed HPSIM version 5 on HP-UX using the PostgreSQL database (default installation) I would like to pull info from the PostgreSQL database into another product we have which gathers info from many sources.

What is the default password for hpsmdb id?
Is anyone else doing this?

Thanks
Marty
1 REPLY
Lars Nilsson_1
Trusted Contributor

Re: PostgreSQL: Database access

I'm not at all familiar with HP-UX but we are running our HPSIM CMS on a SUSE Linux server with the PostgreSQL db. We are pulling information from the pgsqldb through a ODBC connection to HPOV Service Desk.

The HPSIM dbuser is "mxadmin" and has no default password. To find it out I run:
/opt/mx/bin/mxpassword -l
The HPSIM database is named "insight_v1_0".

(Of course it is preferable to create a new dbuser with limited rights).

Then you have to edit two configuration files to allow external access to the db:
/var/lib/pgsql/data/postgresql.conf and
/var/lib/pgsql/data/pg_hba.conf

This is how it works on SUSE Linux and as I said, I don't know anything about HP-UX...

I hope you can find something of this useful. Also look in the HPSIM documentation and visit http://www.postgresql.org