VisibleThread Help Center

    How to configure VT Docs on RHEL to connect to an external database

    Follow

    Create the VT Docs user and database

     

    Download the sql file from here:

    https://docs.visiblethread.com/download/VTDocsDbBootstrap/createDB.sql

     On a system that has access to the Postgresql database run the file 'createDB.sql' as the postgres user:

     

    # psql -h <postgresql server name> -U postgres

    postgres=> \i createDB.sql

    postgres=> \q

     

    This will create the VisibleThread user in PostgreSQL and the VisibleThread database

     

     

    Bootstrap the VisibleThread Docs database with the required table structure and data

     

    Download the sql file from here:

    https://docs.visiblethread.com/download/VTDocsDbBootstrap/createTables.sql

     

    Run the attached file 'createTables.sql' as the visiblethread user (the password is 'password'):

     

    #psql -h <postgresql server name> -U visiblethread 

    postgres=> \i createTables.sql

    postgres=> \q

     

     

    Modify the VT Docs application config to point to your Database server

     

    1. On the RHEL server that is running VT Docs, navigate to the ‘/opt/visiblethread/tomcat/conf’ folder
    2. Open the ‘server.xml’ file for editing
    3. Replace the line that contains “url="jdbc:postgresql://127.0.0.1:5432/visiblethread"”  with “url="jdbc:postgresql://<db server address>:5432/visiblethread"
    4. Open the ‘context.xml’ fie for editing
    5. Replace the line that contains “url="jdbc:postgresql://127.0.0.1:5432/visiblethread"”  with “url="jdbc:postgresql://<db server address>:5432/visiblethread"
    6. Restart the VT Docs services:
      1. sudo service visiblethread-docs restart
    7. The application should startup and be connected to the external database.

     

     

     

     

     

     

    Was this article helpful?
    0 out of 0 found this helpful

    Comments