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)

ATTACHMENT:

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

Attachments

Browse this section