2 Replies Latest reply on Jun 27, 2017 3:16 PM by merouane agar

    Truesight Presentation Server :Postgres DB Related Query

    Abhay Bhagat

      Dear Experts ,

       

      Few queries related postgres DB of Presentation Server :-

      1. Which Configuration file contains the password of the PostgresDB of Presentation Server
      2. Any way to reset the presentation server password.
      3. Any BMC documentation or steps to login on Postgres DB .
      4. Any other documents suggesting the action which we may take on postgres DB .

       

      Regards

      Abhay

        • 1. Re: Truesight Presentation Server :Postgres DB Related Query
          Deepak Kamath

          Hi Abhay Bhagat

           

          You need to use pgAdmin3.exe utility.

           

          Location TrueSightPServer\truesightpserver\modules\pgsql\bin

           

          You need to add connection and connect DB.

           

          These things are not documented by BMC , but refer to these link. I had used this earlier

           

          Using pgAdmin III — pgAdmin III 1.22.2 documentation

           

          Regards

          Deepak Kamath

          1 of 1 people found this helpful
          • 2. Re: Truesight Presentation Server :Postgres DB Related Query
            merouane agar

            Hello,

             

            The database user name and password are stored in  $TRUESIGHTPSERVER_HOME/truesightpserver/conf/secure/dbvault.ks

            The username is not encrypted. The password in encrypted using a proprietary hashing algorithm.

             

            ###############################################################

            cat $TRUESIGHTPSERVER_HOME/truesightpserver/conf/secure/dbvault.ks

            #Wed Mar 29 14:19:25 CEST 2017

            secret=f39/f39/f39/fwAAAAhwM5ReBtBsOAAAABB+5FsdKYFeDs6Jebjg06mqAAAAFJEEvyV71Zm99x+RLrIUPZa3T9QO

            identity=<user>

            port=<port>

            host=localhost

            ###############################################################

             

            To connect to the database on localhost :

             

            export PATH=$PATH:$TRUESIGHTPSERVER_HOME/truesightpserver/modules/pgsql/bin

            psql --dbname=truesight --port=<port> --username=<user>

             

             

             

            To connect to the database in remote with pgAdmin3.exe

             

            It will be necessary to allow access to the database in the file $TRUESIGHTPSERVER_HOME/truesightpserver/data/pgsql/pg_hba.conf

            Eg :

            host  all  all  0.0.0.0/0  md5

             

             

            Regards

            Merouane AGAR

            1 of 1 people found this helpful