Version 2 (modified by 13 years ago) ( diff ) | ,
---|
How do I redact a password or other sensitive info from a ticket?
Note: this process will change after upgrading support.mayfirst.org to Postgres.
The trac installation is on moses.mayfirst.org.
Begin by logging into moses:
ssh root@moses.mayfirst.org
Then, open the database:
sqlite3 /srv/trac/support/db/trac.db
The SQL statement to execute depends on whether the string you want to redact is in the original ticket or in a comment. In both cases below, replace THING_TO_REPLACE with the actual private string to redact and replace TICKET_NUMBER with the number of the ticket.
If you are redacting the body of an initial ticket, try:
UPDATE ticket SET description = REPLACE(description,'THING_TO_REPLACE','xxxxxx') where id = TICKET_NUMBER;
If you are redacting an ticket comment try:
UPDATE ticket_change SET newvalue = REPLACE(newvalue,'THING_TO_REPLACE','xxxxxxxx') where ticket = TICKET_NUMBER;
When you are done type:
.quit
Note:
See TracWiki
for help on using the wiki.