How to delete an entry from 'tssh properties'?
The instructions are geared toward a Linux TSPS, however the overall concepts apply to Windows too.
Assume that the bad entry in the TSPS properties is named "badentry"
Get the username for the TSPS DB:
grep -A 1 database_username TrueSightPServerInstalledConfiguration.xml
The above command looks for the string "database_username" in the file TrueSightPServerInstalledConfiguration.xml, and then also grabs the line after that.
In this case, our TSPS DB username is tspsuser
./psql -d truesight -U tspsuser
(You will be presented with this prompt: truesight=#)
truesight=# delete from sitelocalconfiguration where key like 'badentry';
If the command worked, you will see:
The "badentry" bad entry should be gone now.