2 Replies Latest reply on Feb 27, 2020 3:44 AM by Raul Calderon de la Barca

    TSVM 3.1 Application Installation fail

    Raul Calderon de la Barca
      Share This:

      Hello,

       

      I'm trying to install TSVM 3.1 Application component and I have this error:

       

      [INFO] check_tablespace_permission : create command execution result '{'Output': 'psql: could not connect to server: Host is unreachable\n\tIs the server running on host "192.168.0.112" and accepting\n\tTCP/IP connections on port 5432?\n', 'ExitCode': 2}'

      [ERROR] check_tablespace_permission : Execution failed with exit code: 2, data: psql: could not connect to server: Host is unreachable

              Is the server running on host "192.168.0.112" and accepting

              TCP/IP connections on port 5432?

       

       

      The installation parameters are:

       

      Do you agree to the terms of the License Agreement? If you do not accept the terms of the License Agreement, installation program will exit. ([y]es/[n]o)y

      [INFO] You have accepted the terms of License Agreement. Starting the installation process...

      Enter installation directory(default: /opt/bmc/truesight):

      Enter inputs file path. Press enter to skip (Inputs will be prompted at the time of installation)(default:  ):

      [INFO] Execution started

      [INFO] Performing pre-installation checks...

      [INFO] Extracting zip file in temp location..

      [INFO] Starting installation for deployment 'application'

      Enter the hostname for Docker registry. Port number can be appended with ':' (default: 127.0.0.1:5000):

      Enter the Docker network subnet prefix : 192

      Enter the port to be used by Application UI(default: 8443):

      Enter the port to be used by internal components of the application(default: 9443):

      Enter the name of the Vulnerability Management database (default: tsvm_database):

      Enter the fully-qualified domain name or IP address of the PostgreSQL server : 192.168.0.112

      Enter the port number of the PostgreSQL server (default: 5432):

      Enter the PostgreSQL Admin user name (default: postgres):

      Enter the password for the PostgreSQL Admin user,'postgres':

      Re-enter the password for the PostgreSQL Admin user,'postgres':

      Enter the new user name for database , 'tsvm_database' (default: tsvm_database_user):

      Enter the password for the,'tsvm_database_user':

      Re-enter the password for the,'tsvm_database_user':

      Enter the directory path of the existing application tablespaces on PostgreSQL server.

      Minimum required free disk space is 20 GB (default: /opt/bmc/truesight/tsvm_tablespace):

      Do you have 'Write' privileges on /opt/bmc/truesight/tsvm_tablespace for the 'postgres' user?  ([y]es/[n]o)y

      [INFO] New application tablespace location '/opt/bmc/truesight/tsvm_tablespace'

      [INFO] New application tablespace directory '/opt/bmc/truesight/tsvm_tablespace'

      Enter the fully-qualified domain name or IP address and HTTP port number of the host where Elasticsearch is installed in the following format: <hostA>:<portNumber>, <hostB>:<portNumber> (HTTP port number can be found in the <ES_INSTALL_DIR>/elasticsearch/infra-ext/es/DCAIndexService/config/elasticsearch.yml file on the Elasticsearch host): 192.168.0.112:9200

      Site Type:

      1. Server Automation
      2. Network Automation
      3. Microsoft SCCM

      Select Site Type : 1

      Enter the host name of the site: 192.168.0.128

      Enter the port number of the site (default: 9843):

      Enter the protocol of the site (https|http)(default: https):

      Enter the admin role name of the site(default: BLAdmins):

      Do you want to enter information for another site? ([y]es/[n]o)n

      Do you want to proceed with the entered information? ([y]es/[n]o)y

      Specified inputs are saved in the /opt/bmc/truesight/inputs_file.yml file.

      [INFO] Checking Docker Registry 127.0.0.1:5000 for required docker images...

      [INFO] Installing component 'configurator' , path: /opt/bmc/truesight/application/config/configurator

      [INFO] Loading module 'component_ext' from directory '/opt/bmc/truesight/application/config/configurator'

      [INFO] Performing custom pre-installation for 'configurator'...

      [INFO] Loading module 'component_ext' from directory '/opt/bmc/truesight/application/config/configurator'

      [INFO] Starting service 'configurator'

      [INFO] Start tablespace directory check

      [INFO] Retrieved db_info

      [INFO] check_tablespace_permision : create cmd

      [INFO] check_tablespace_permission : create command execution result '{'Output': 'psql: could not connect to server: Host is unreachable\n\tIs the server running on host "192.168.0.112" and accepting\n\tTCP/IP connections on port 5432?\n', 'ExitCode': 2}'

      [ERROR] check_tablespace_permission : Execution failed with exit code: 2, data: psql: could not connect to server: Host is unreachable

              Is the server running on host "192.168.0.112" and accepting

              TCP/IP connections on port 5432?

       

      [ERROR] User postgres does not have write access on database location /opt/bmc/truesight/tsvm_tablespace

      [INFO] Database tablespace directory permission check failed.

      [INFO] Stopping the installation of deployment 'application'

      [INFO] Stopping service 'configurator'

      [INFO] --------------------------------------------------

      [INFO] Execution completed in 155.13 secs

      [INFO] --------------------------------------------------

      [root@vs-lce-269 truesight-sm]#

       

      If I check the database:

       

      [root@vs-lce-269 truesight-sm]# python truesight-sm.py status --deployment database

      /usr/lib/python2.7/site-packages/requests/__init__.py:91: RequestsDependencyWarning: urllib3 (1.25.8) or chardet (2.2.1) doesn't match a supported version!

        RequestsDependencyWarning)

      [INFO] **************************************************

      [INFO] TrueSight Stack Manager V3.1.00.1565

      [INFO] **************************************************

      [INFO] Initialization completed.

      [INFO] Execution started

      [INFO] Getting status of components for deployment 'database': all

      [INFO] Install All products from the inventory file

      [INFO] Getting status of component 'postgres'

      [INFO] Status:

      Component  Version    Status

       

      # TYPE  DATABASE        USER            ADDRESS                 METHOD

       

      The pg_hba.conf file is (I don't know what I have to change in this file):

      vi /opt/bmc/truesight/tsvm_tablespace/data/pg_hba.conf

      # "local" is for Unix domain socket connections only

      local   all             all                                     trust

      # IPv4 local connections:

      host    all             all             127.0.0.1/32            trust

      # IPv6 local connections:

      host    all             all             ::1/128                 trust

      # Allow replication connections from localhost, by a user with the

      # replication privilege.

      local   replication     all                                     trust

      host    replication     all             127.0.0.1/32            trust

      host    replication     all             ::1/128                 trust

      host  all  all  0.0.0.0/0  md5

      host  all  all  ::/0  md5

       

      Thank you very much.

       

      Raúl

        • 1. Re: TSVM 3.1 Application Installation fail
          Kunal Panigrahi

          Hi Raul,

           

          Can you elaborate on the toppology? Are all the components of TSVM getting installed on the same host?

          What is the OS details of the hosts?

          Are you using a preexisting PostgreSQL DB?

           

          The below entries from pg_hba.conf is good.

          host all all 0.0.0.0/0 md5

          host all all ::/0 md5

          Other thing to check on the database configuration is the postgresql.conf to see the below entries:

          listen_addresses = '*'

          port = 5432

           

          If you are using BMC installer then you dont have to change any of the settings on the pg_hba.conf or postgresql.conf.

           

          What is the entries you have in daemon.json file?

           

          ~Kunal

          • 2. Re: TSVM 3.1 Application Installation fail
            Raul Calderon de la Barca

            Hi Kunal,

             

            Finally , yesterday I installed the TSVM correctly with the great help of Madhu from support.

             

            The problem was that I installed the DB with the firewall active.

             

            I had stop the firewall, then to flush the iptables and restart docker. With this I could install the APP fine.

             

            Now TSVM is working and connected to TSSA.

             

            Thank you very much for your help.

             

            BR.

             

            Raúl

            1 of 1 people found this helpful