Troubleshooting: exporting the configuration/provisioning database

QUESTION:

How do I export the configuration/provisioning database?

Occasionally, to troubleshoot an issue, the provisioning or configuration database may be required to be reviewed.

SOLUTION:

Please post attachments to an existing support ticket or open a new support ticket.

Please note - <TRAVERSE_HOME> refers to the Traverse installation directory
                  - replace YYYYMMDD as appropriate with the year, month and date

Additionally, the audit.log from the BVE (<TRAVERSE_HOME>\logs\webapp) will be required to be reviewed.

 This process does not require any components to be shut down. 

 

On Windows:

cd <TRAVERSE_HOME>\apps\poet\bin
ptxml -export -file provdb-YYYYMMDD.xml -server localhost -base provisioning > provdb-YYYYMMDD.txt 2>&1

The above command creates the provdb backup in <TRAVERSE_HOME>\apps\poet\bin.

To redact the password, please follow the additional instructions below.

Then please zip together and attach

* provdb-YYYYMMDD.xml
* provdb-YYYYMMDD.txt
* <TRAVERSE_HOME>\logs\webapp\audit.log
* <TRAVERSE_HOME>\database\backup\backup_provisioning.xml

to the appropriate support ticket for analysis.

 

On linux (please note the backtick ` are to be typed in as is for the export LD_LIBRARY_PATH command below):

su 
cd TRAVERSE_HOME/apps/poet/lib # Replace TRAVERSE_HOME with your actual Traverse install folder
export LD_LIBRARY_PATH=`pwd`
cd ../bin
./ptxml -export -file /tmp/provdb-YYYYMMDD.xml -server localhost -base provisioning > /tmp/provdb-YYYYMMDD.log 2>&1
cd /tmp
zip provdb-YYYYMMDD.zip provdb-YYYYMMDD.xml provdb-YYYYMMDD.log

To redact the password, please follow the additional instructions below.

Then please tar/compress together and attach

* the provdb-YYYYMMDD.xml
* the provdb-YYYYMMDD.log
* <TRAVERSE_HOME>/logs/webapp/audit.log
* <TRAVERSE_HOME>/database/backup/backup_provisioning.xml 

to the appropriate support ticket for analysis.

For version 9.5.187, credentials removal is no longer required as the passwords are now masked in the provisioning database.

Credentials removal:

For security reasons, we recommend after the steps outlined above, to download the attachment and run the following instructions:

  • Unzip the attachment under <traverse_home>\utils\ (same folder in Linux)
  • Run in a command line window (shell in Linux):
    • <traverse_home>\utils\remove_passwords.pl provdb-YYYYMMDD.xml
  • Note for Linux make this script executable with 'chmod +x remove_passwords.pl'
  • The output that would be provdb-YYYYMMDD.xml.tmp file with all the passwords altered with the word "redacted"
  • Repeat this process with TRAVERSE_HOME>/database/backup/backup_provisioning.xml
  • Kindly zip this file with the rest of the files outlined above (<TRAVERSE_HOME>/logs/webapp/audit.log and the redacted <TRAVERSE_HOME>/database/backup/backup_provisioning.xml)

 RELATED TO:
TRAVERSE: HOW TO SAFELY IMPORT (RESTORE) A CUSTOMER PROVISIONING DATABASE

ATTACHMENT:

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Contact us