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: cd /opt/bmc/TrueSightPServer grep -A 1 database_username TrueSightPServerInstalledConfiguration.xml <name>TrueSight_database_username</name> <value>tspsuser</value> 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 cd /opt/bmc/TrueSightPServer/truesightpserver/modules/pgsql/bin ./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: DELETE 1 Then quit: truesight=#\q The "badentry" bad entry should be gone now. |