https://community.hpe.com/t5/server-management-systems/postgresql-database-access/m-p/3760607#M19372 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.<BR /><BR />The HPSIM dbuser is "mxadmin" and has no default password. To find it out I run:<BR />/opt/mx/bin/mxpassword -l<BR />The HPSIM database is named "insight_v1_0".<BR /><BR />(Of course it is preferable to create a new dbuser with limited rights). <BR /><BR />Then you have to edit two configuration files to allow external access to the db:<BR />/var/lib/pgsql/data/postgresql.conf and<BR />/var/lib/pgsql/data/pg_hba.conf<BR /><BR />This is how it works on SUSE Linux and as I said, I don't know anything about HP-UX...<BR /><BR />I hope you can find something of this useful. Also look in the HPSIM documentation and visit <A href="http://www.postgresql.org" target="_blank">http://www.postgresql.org</A> Wed, 29 Mar 2006 04:07:05 GMT Lars Nilsson_1 2006-03-29T04:07:05Z https://community.hpe.com/t5/server-management-systems/postgresql-database-access/m-p/3760606#M19371 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. <BR /><BR />What is the default password for hpsmdb id? <BR />Is anyone else doing this?<BR /><BR />Thanks<BR />Marty Tue, 28 Mar 2006 11:36:20 GMT https://community.hpe.com/t5/server-management-systems/postgresql-database-access/m-p/3760606#M19371 martyatpb 2006-03-28T11:36:20Z https://community.hpe.com/t5/server-management-systems/postgresql-database-access/m-p/3760607#M19372 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.<BR /><BR />The HPSIM dbuser is "mxadmin" and has no default password. To find it out I run:<BR />/opt/mx/bin/mxpassword -l<BR />The HPSIM database is named "insight_v1_0".<BR /><BR />(Of course it is preferable to create a new dbuser with limited rights). <BR /><BR />Then you have to edit two configuration files to allow external access to the db:<BR />/var/lib/pgsql/data/postgresql.conf and<BR />/var/lib/pgsql/data/pg_hba.conf<BR /><BR />This is how it works on SUSE Linux and as I said, I don't know anything about HP-UX...<BR /><BR />I hope you can find something of this useful. Also look in the HPSIM documentation and visit <A href="http://www.postgresql.org" target="_blank">http://www.postgresql.org</A> Wed, 29 Mar 2006 04:07:05 GMT https://community.hpe.com/t5/server-management-systems/postgresql-database-access/m-p/3760607#M19372 Lars Nilsson_1 2006-03-29T04:07:05Z