Opened 13 years ago
Closed 13 years ago
#733 closed task (fixed)
Spammed Gallery.osgeo.org
| Reported by: | tmitchell | Owned by: | tmitchell |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | SysAdmin | Keywords: | spam, gallery |
| Cc: | crschmidt |
Description
Not sure if anyone is overseeing the gallery.osgeo.org site - but I've had a few reports of spammed links on there. I'm tempted to shut it down unless someone is able to have a peek.
Change History (9)
comment:1 by , 13 years ago
| Keywords: | spam gallery added |
|---|
comment:2 by , 13 years ago
| Cc: | added |
|---|
Thanks for offering to help Hamish. Unfortunately I can't find a way to access the admin side of the application. It is a django app and I can't find where it is hosted. It looks like it's hosted on the "webextra vm" but I don't see any signs that it is running there - eg. the database there is old.
cc:ing Chris, as he's noted here: http://wiki.osgeo.org/wiki/WebExtraVM#gallery.osgeo.org
Chris, Have some pointers for getting someone to be able to moderate it? It looks like an abandoned app.
comment:3 by , 13 years ago
A ping shows the DNS still points to a telescience server. My suspicion is there were plans to move it but that never finished.
comment:4 by , 13 years ago
I tried to remove the spam today. The gallery is hosted webextra.osgeo.osuosl.org in /osgeo/gallery-site. The content is in a sqlite DB in that directory.
I have installed sqlitebrowser on that machine, the DB opens. Only, I don't understand in which table to find the content (in order to remove the spam rows).
comment:5 by , 13 years ago
I don't see any files there that have been updated in 2011 - I thought the service was on a telascience blade. I'm ready to pull the DNS until someone is able to fix this.
comment:6 by , 13 years ago
Correct the DNS points to 198.202.74.219 which is Telascience. There might be a copy on webextra - maybe someone intended to move/upgrade it there but it does not appear to be live on the machine.
comment:7 by , 13 years ago
bump - anyone got access to this telascience blade and can help clean up the spam? Ready to pull the plug in DNS now otherwise.
comment:8 by , 13 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:9 by , 13 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Set up /var/www/gallery on webextra, create a basic "offline" page. Redirected DNS to 140.211.15.68. Let's see how it goes.
it is <30, and so not impossible to clean up by hand.
currently it just requires to pass the captcha? what if an osgeo account was needed as well? (it would not stop it, but at least a higher barrier to entry, so maybe they go elsewhere, or would allow to delete by user name of submitter)
is there an admin version where besides (edit) (permalink) you get a (delete) button? if so that would make it pretty fast/efficient to clean up, and I'd be happy to do it. I notice that for some they have reused our graphics with their links.
Hamish