Changes between Initial Version and Version 1 of redact_info_in

Timestamp:

Jan 3, 2011, 4:33:45 PM (15 years ago)

Author:

Jamie McClelland

Comment:

--

redact_info_in

@@ +1 @@
+= How do I redact a password or other sensitive info from a ticket? =
+
+Note: this process will change after upgrading to Postgres (see ticket #3716).
+
+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
+}}}