Re: trac: lost all accounts, apology
Hello James, James Cameron qu...@laptop.org writes: [...] However, I have not loaded these dumps into the production database, because I don't see a need, and most of the data is spam; roughly 5500 accounts, with no easy way to validate. Thanks to the people who have re-registered. For those that had specific permissions, I've added back the permissions you had. Thanks for working on recovery. If I re-register, will the bugs I reported or am CC'ed on still be associated with my (recreated) account? If there's additional work required on your side to restore the above associations: Would you prefer me to re-register or is it easier to just restore my account from the backup? Sascha pgprbbUHQJo8i.pgp Description: PGP signature ___ Devel mailing list Devel@lists.laptop.org http://lists.laptop.org/listinfo/devel
Re: trac: lost all accounts, apology
On Tue, Mar 04, 2014 at 09:13:45AM +0100, Sascha Silbe wrote: Hello James, James Cameron qu...@laptop.org writes: [...] However, I have not loaded these dumps into the production database, because I don't see a need, and most of the data is spam; roughly 5500 accounts, with no easy way to validate. Thanks to the people who have re-registered. For those that had specific permissions, I've added back the permissions you had. Thanks for working on recovery. If I re-register, will the bugs I reported or am CC'ed on still be associated with my (recreated) account? Yes. The reporter and cc fields were unaffected, and are plain text, not database object identifiers. Feel free to test by adding a comment to a bug, I'm happy to delete it afterwards if you want. -- James Cameron http://quozl.linux.org.au/ ___ Devel mailing list Devel@lists.laptop.org http://lists.laptop.org/listinfo/devel
trac: lost all accounts, apology
G'day, There was a spam attack on our trac instance again, four tickets were created, and many invalid accounts were found. In trying to remove the extra accounts every account was removed instead. Apologies for my mistake. If you still need to use trac, please register [1] your account again. A special question has been added to the register form to try to reduce the attacks from the automatic robots. The answer to the special question is XO in uppercase or lowercase. I wasn't able to find valid backups for trac. The only backups we have were made with the PostgreSQL database server running; the documentation says this is not a usable backup. So I'll look into another method. References: 1. https://dev.laptop.org/register 2. http://www.postgresql.org/docs/8.2/static/backup-file.html -- James Cameron http://quozl.linux.org.au/ ___ Devel mailing list Devel@lists.laptop.org http://lists.laptop.org/listinfo/devel
Re: trac: lost all accounts, apology
On Mon, Mar 03, 2014 at 07:19:25PM +1100, James Cameron wrote: I wasn't able to find valid backups for trac. The only backups we have were made with the PostgreSQL database server running; the documentation says this is not a usable backup. So I'll look into another method. With advice from Chris Ball and #postgresql, it proved possible to use the filesystem backup, start up another instance of the database, and dump the permission, session, and session_attribute tables. However, I have not loaded these dumps into the production database, because I don't see a need, and most of the data is spam; roughly 5500 accounts, with no easy way to validate. Thanks to the people who have re-registered. For those that had specific permissions, I've added back the permissions you had. -- James Cameron http://quozl.linux.org.au/ ___ Devel mailing list Devel@lists.laptop.org http://lists.laptop.org/listinfo/devel
Re: trac: lost all accounts, apology
Thanks James for working on this. Gonzalo On Tue, Mar 4, 2014 at 1:18 AM, James Cameron qu...@laptop.org wrote: On Mon, Mar 03, 2014 at 07:19:25PM +1100, James Cameron wrote: I wasn't able to find valid backups for trac. The only backups we have were made with the PostgreSQL database server running; the documentation says this is not a usable backup. So I'll look into another method. With advice from Chris Ball and #postgresql, it proved possible to use the filesystem backup, start up another instance of the database, and dump the permission, session, and session_attribute tables. However, I have not loaded these dumps into the production database, because I don't see a need, and most of the data is spam; roughly 5500 accounts, with no easy way to validate. Thanks to the people who have re-registered. For those that had specific permissions, I've added back the permissions you had. -- James Cameron http://quozl.linux.org.au/ ___ Devel mailing list Devel@lists.laptop.org http://lists.laptop.org/listinfo/devel -- Gonzalo Odiard SugarLabs - Learning Software for children ___ Devel mailing list Devel@lists.laptop.org http://lists.laptop.org/listinfo/devel