Re: Wine Wiki needs your help!

2013-01-24 Thread Kyle Auble
On Wed, Jan 16, 2013 at 12:19 AM, Juan Lang wrote: > Could the password hashes be excluded from the regular tarball? E.g. using > --exclude in the tar command? Sorry I didn't reply sooner, been a little busy the past week. I don't have a copy of the Wine Wiki data in front of me, but if I remembe

Re: Wine Wiki needs your help!

2013-01-15 Thread Juan Lang
Hi Kyle, On Tue, Jan 15, 2013 at 8:10 AM, Kyle Auble wrote: > The one thing that would probably help a lot is if there was a regularly > updated tarball of the wiki content either at WineHQ or Lattica's FTP > again. I > haven't messed with cron itself much, but my archive.cron script should > pa

Re: Wine Wiki needs your help!

2013-01-15 Thread Dimi Paun
Hi folks, Thanks for all the help and hits -- much appreciated. I ended up writing a few scripts myself that cleaned up both the pages and users. It should do for now. Please let me know if you see any problems with the wiki, I hope I wasn't over-eager when cleaning up spam :))) Cheers, Dimi.

Re: Wine Wiki needs your help!

2013-01-15 Thread Kyle Auble
On Tue, Jan 15, 2013 at 1:06 PM, Dimi Paun wrote: > Thanks everyone for your help! > I'll take down the Pages spreadsheet. > Now, what about the users? Those are files (not directories) so we don't > face > the same low limit (32k), but it would be nice if we could, somehow, cleanup > those files

Re: Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
On 13-01-14 11:11 PM, Dmitry Timoshkov wrote: Hi Dimi, Dimi Paun wrote: I've cleanup the deleted pages, were down to about 740 pages, mostly good stuff: https://docs.google.com/a/lattica.com/spreadsheet/ccc?key=0AmY-Kp_Ihu3idFNEOUt0UkVGUko4elhkOHVoaWx2OWc#gid=5 Please check it out, lemme kn

Re: Wine Wiki needs your help!

2013-01-14 Thread Dmitry Timoshkov
Hi Dimi, Dimi Paun wrote: > I've cleanup the deleted pages, were down to about 740 pages, > mostly good stuff: > > https://docs.google.com/a/lattica.com/spreadsheet/ccc?key=0AmY-Kp_Ihu3idFNEOUt0UkVGUko4elhkOHVoaWx2OWc#gid=5 > > Please check it out, lemme know if any spam is still left standing

Re: Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
Hi guys, I've cleanup the deleted pages, were down to about 740 pages, mostly good stuff: https://docs.google.com/a/lattica.com/spreadsheet/ccc?key=0AmY-Kp_Ihu3idFNEOUt0UkVGUko4elhkOHVoaWx2OWc#gid=5 Please check it out, lemme know if any spam is still left standing. Any ideas on how we can att

Re: Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
Yes it is done. Ill update the spreadsheet bit later... André Hentschel wrote: >Am 14.01.2013 21:40, schrieb Andrew Eikum: >> On Mon, Jan 14, 2013 at 03:32:40PM -0500, Dimi Paun wrote: >>> OK, we might be onto something. I've wrote a script >>> to determine the deleted pages: 20162. >>> >>> Shou

Re: Wine Wiki needs your help!

2013-01-14 Thread André Hentschel
Am 14.01.2013 21:40, schrieb Andrew Eikum: > On Mon, Jan 14, 2013 at 03:32:40PM -0500, Dimi Paun wrote: >> OK, we might be onto something. I've wrote a script >> to determine the deleted pages: 20162. >> >> Should I just go ahead and nuke those? >> > > Probably, yes. > > One common way for spamme

Re: Wine Wiki needs your help!

2013-01-14 Thread Andrew Eikum
On Mon, Jan 14, 2013 at 03:32:40PM -0500, Dimi Paun wrote: > OK, we might be onto something. I've wrote a script > to determine the deleted pages: 20162. > > Should I just go ahead and nuke those? > Probably, yes. One common way for spammers to abuse wikis is to intentionally get the pages dele

Re: Wine Wiki needs your help!

2013-01-14 Thread André Hentschel
Am 14.01.2013 20:00, schrieb Dimi Paun: > Hm, it doesn't seem to be so simple. > Each page maintains an edit-log file with all the changes. > > grep-ing for -i spam in the edit-log yields less than 400 hits. > > Maybe we should look for deleted pages? > Simple idea: Make a backup of the current

Re: Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
OK, we might be onto something. I've wrote a script to determine the deleted pages: 20162. Should I just go ahead and nuke those? Dimi. On 01/14/2013 01:35 PM, Francois Gouget wrote: On Mon, 14 Jan 2013, Dimi Paun wrote: MoinMoin creates a dir for every page. I simply got the list by listing

Re: Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
Hm, it doesn't seem to be so simple. Each page maintains an edit-log file with all the changes. grep-ing for -i spam in the edit-log yields less than 400 hits. Maybe we should look for deleted pages? Dimi. On 01/14/2013 01:35 PM, Francois Gouget wrote: On Mon, 14 Jan 2013, Dimi Paun wrote:

Re: Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
OK, that's a fair point. Lemme quickly go through that and I'll report back. Dimi. On 01/14/2013 01:35 PM, Francois Gouget wrote: On Mon, 14 Jan 2013, Dimi Paun wrote: MoinMoin creates a dir for every page. I simply got the list by listing these directories. (This is the problem -- there is a

Re: Wine Wiki needs your help!

2013-01-14 Thread Francois Gouget
On Mon, 14 Jan 2013, Dimi Paun wrote: > MoinMoin creates a dir for every page. I simply got the list > by listing these directories. (This is the problem -- there is a > limit of 2^15 subdirectories, and this is what we were hitting > a few days ago). > > Does that answer the question? It feels

Re: Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
MoinMoin creates a dir for every page. I simply got the list by listing these directories. (This is the problem -- there is a limit of 2^15 subdirectories, and this is what we were hitting a few days ago). Does that answer the question? Dimi. On 01/14/2013 12:51 PM, Francois Gouget wrote: On M

Re: Wine Wiki needs your help!

2013-01-14 Thread Francois Gouget
On Mon, 14 Jan 2013, Dimi Paun wrote: [...] > https://docs.google.com/a/lattica.com/spreadsheet/ccc?key=0AmY-Kp_Ihu3idFNEOUt0UkVGUko4elhkOHVoaWx2OWc#gid=5 I'm not clear on how this is supposed to work. For instance I see a ton of pages containing 'joyal' or 'crusher' in their Page Name. For insta

Re: Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
On 01/14/2013 11:43 AM, Erich E. Hoover wrote: On Mon, Jan 14, 2013 at 9:38 AM, Dimi Paun wrote: ... Please let me know if we can do this any simpler or if there are any problems. Do you want us to move marked items up to the top of the spreadsheet or will you do that for us? I don't think we

Re: Wine Wiki needs your help!

2013-01-14 Thread Erich E. Hoover
On Mon, Jan 14, 2013 at 9:38 AM, Dimi Paun wrote: > ... > Please let me know if we can do this any simpler or if there are > any problems. Do you want us to move marked items up to the top of the spreadsheet or will you do that for us? Erich

Wine Wiki needs your help!

2013-01-14 Thread Dimi Paun
Folks, As we all know, through the years spam has been an ongoing problem. We dealt with it OK, as we valued the openness of our wiki. That's good. However, all this churn has accumulated a lot of garbage on the system, as orphaned pages and dummy users. These have accumulated to such an extent