[Solved] How about deleting spammers account?

The place for discussions and decisions about the forum
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

[Solved] How about deleting spammers account?

Post by Hagar Delest »

Hi All,

We talked about that a while ago but it hasn't been implemented before Terry left.

I propose to delete the users who have the clear profile of the spammer: no or only 1 post + advertising link in signature. We easily see the 1 post spammers but not all who don't post but are still listed in the members list (and there are some recently, that's why this topic).

Either we ask someone from the ASF to get a query in the database to spot the profile mentioned above, or we trust the admins who will do that manually by browsing the members list.

Note that removing the spammers account will show a more representative count of the "real" members in the forum statistics (bottom of main index page).
Last edited by Hagar Delest on Fri Nov 16, 2012 11:19 am, edited 1 time in total.
Reason: tagged [Solved].
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
RGB
Posts: 1456
Joined: Mon Oct 08, 2007 1:34 am

Re: How about deleting spammers account?

Post by RGB »

+1 for removing the accounts. If someone else do it for us, then it will be easier... ;) but I have no problem on doing this manually.
There are two types of people: those who believe that there are two types of people and those who do not.

openSUSE Leap with KDE Plasma / LibreOffice
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: How about deleting spammers account?

Post by floris v »

+1, if they don't post at all. If they do, not deleting it might make life harder for them - they'd have to register with a new mail address and you can only have a finite number of them, I suppose.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
thomasjk
Volunteer
Posts: 4451
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: How about deleting spammers account?

Post by thomasjk »

+1 Delete the spammers accounts.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
mriosv
Volunteer
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: How about deleting spammers account?

Post by mriosv »

Why not agree a rule for this situations?
Inform the ppmc, waiting a while for their comments, if there is no problem, fix an apply the rule.
This lets all admins and mods can know what to do.
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How about deleting spammers account?

Post by RoryOF »

mriosv wrote:Why not agree a rule for this situations?
Inform the ppmc, waiting a while for their comments, if there is no problem, fix an apply the rule.
This lets all admins and mods can know what to do.
The usual time for an Apache "lazy consensus" is 72 hours. I'm not suggesting we actually invoke their "lazy consensus" mechanism, but if we act after 72 hours who can fault us?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How about deleting spammers account?

Post by Hagar Delest »

I'm ok with a rule but not with listing all the accounts to be banned. It's rather easy to browse the members list and spot the spammers. But making the list to be given in a mail for PPMC is not feasible (except if it can be automated with a query directly to the database).

If the agreement is only about the deletion based on the sole judgment of the admin, no problem.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
mriosv
Volunteer
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: How about deleting spammers account?

Post by mriosv »

Hi Hogar, I am only talking about to set the rule.
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: How about deleting spammers account?

Post by kingfisher »

I doubt the PPMC has any interest in the matter. AFAIK, the PPMC does not intervene in such a fashion in the mailing lists.

I say if someone is clearly registered only to post spam, remove the account.
Apache OpenOffice 4.1.9 on Linux
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How about deleting spammers account?

Post by Villeroy »

kingfisher wrote:I say if someone is clearly registered only to post spam, remove the account.
Merry Xmas! Amen!
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How about deleting spammers account?

Post by Hagar Delest »

kingfisher wrote:I doubt the PPMC has any interest in the matter. AFAIK, the PPMC does not intervene in such a fashion in the mailing lists.
According to the discussions before the move to ASF servers, they were rather touchy about the way the forum is managed, especially when it comes to admin tasks.

Will do a mail to the mailing list in few days to get a lazy consensus.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: How about deleting spammers account?

Post by RoryOF »

I'd just get on and do it (they class this as JFDI - Just F***ing Do It). Don't trouble them unnecessarily :-) And don't wake up anyone who is asleep on their lists!
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: How about deleting spammers account?

Post by kingfisher »

There was some discussion on the dev list recently about spam from a subscriber to the users' mailing list. They seem to discuss anything and everything there. I don't know how any of them ever get anything done. The dev list is not the PPMC.
Apache OpenOffice 4.1.9 on Linux
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How about deleting spammers account?

Post by Hagar Delest »

OK, so I proceeded. Have deleted about 1550 users who had been banned.
Plus another 180 with following pattern:
- No post
- Link to a commercial site
- Last active time within few minutes after registration time.
Haven't finished yet with these ones, to be continued...
 Edit: Have reviewed all the accounts with a link to a website and removed in total 231 users (the former figure was 180). So now the count is about real users only (almost 44800). 
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
rudolfo
Volunteer
Posts: 1488
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany

Re: How about deleting spammers account?

Post by rudolfo »

Just a few minutes ago I came across a thread in the General Discussion forum. Thread number is t=46485, but it is invalid now, because it was obviously deleted as spam. I was thinking about reporting it, but did not find a profile of the user. No data except for then name on the right where I usually see the number of posts and the day when he or she joined the forum:
Post without user profile
Post without user profile
no-profile-data.png (9.32 KiB) Viewed 20287 times
The profile name is not a link and I don't find the post amongst the Deleted topics. So is this maybe related with weeding out the obvious spammers through adminstrative tools or direct database operations? And I just hit the wrong second?
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How about deleting spammers account?

Post by Villeroy »

I was the one who deleted the obvious spam. In fact it would be interesting to know how the invalidated user could post this.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How about deleting spammers account?

Post by Hagar Delest »

Black usernames means that the account has been deleted. Hence no link to any profile.
I think that we could delete them right away since the spam is obvious. I don't think they will bother to check if the account is still alive or not. Let's see how it goes when deleting the profile.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
rudolfo
Volunteer
Posts: 1488
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany

Re: How about deleting spammers account?

Post by rudolfo »

So that would mean that the account of the user was deleted before I have seen his post. But most probably after he has posted the spam content. Do we really need to do both: Delete the account AND delete the posts. I would have thought if an admin deletes an account all the post of this accounts will be distinguished, as well.
This is maybe not desired by default, but in case of spam it would make sense.

Or could it be that the user easyreminders was logged in while he was deleted. And account deletion doesn't affect current sessions? Don't really need answers on this (as I am not an administrator) ... it is just that I started thinking.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How about deleting spammers account?

Post by Hagar Delest »

You're absolutely right to ask such questions.

When deleting an account, admins/mods can decide if the posts are retained or not. So posts should be kept of course and moved to the Quarantine forum as usual (that's why you can see for example all the posts from the accounts I've deleted in the Quarantine forum (or in the Deleted forum also).

For the users you're talking about, the topic has been deleted in fact (I've checked the moderator log). I urge the mods to move the posts as agreed in the past to the Quarantine forum. Even if an account is deleted for obvious spam, we need to be very transparent about that and allow the Volunteers to check the content of the posts.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How about deleting spammers account?

Post by Villeroy »

Our friend "easyreminders" reminds us that one can recreate the same account once the banned one has been deleted.
http://user.services.openoffice.org/en/ ... 73&t=46507
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: How about deleting spammers account?

Post by floris v »

Villeroy wrote:Our friend "easyreminders" reminds us that one can recreate the same account once the banned one has been deleted.
http://user.services.openoffice.org/en/ ... 73&t=46507
Exactly the reason why I have some worries about deleting accounts. Unless it's possible to block a mail address that has been used to register a spam account, deleting that account makes it possible for a spammer to use the same mail address for a new account.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How about deleting spammers account?

Post by Hagar Delest »

Indeed. But I think that very few of them will bother to register again. Well, it seems that easyreminders does...
Let's wait a bit and see at the end of next quarter...
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] How about deleting spammers account?

Post by Hagar Delest »

Back on this old topic. I think that the situation has completely changed from last year. We had before a moderate spam activity. Now that there are still between 3 and 5 spammers per day, it seems that deleting the accounts would only allow them to register again after a short while. We are bound to keep these banned accounts then.

For the record, I found an interesting topic on the Ubuntu forum: Why can't I edit my profile? The <25 post restriction:
Q: If an account holder has not posted at all, it is near-impossible for an ordinary forum member to find the profile page, let alone view it. Why, then, is profile spam a problem?

A: Search engine spiders such as google-bot can find the profile page easily and they index any links they find. Profile spam is an example of black hat SEO (search-engine optimisation) or spamdexing. Let us be clear: the use of the forum for posting links whether visible by humans or not is theft - theft of server resources and bandwidth, theft of the facilities paid for by Canonical. This is an international, very busy forum and is a magnet for spammers. It is more valuable for them to post their links on this forum than many other smaller ones. Indeed, it is possible that much ordinary post spam is now intended for spamdexing rather than in the hope that people will click through and purchase the (dubious) goods on offer.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: [Solved] How about deleting spammers account?

Post by acknak »

It might be nice to have a restriction on modifying profiles, but if we continue moderating the new posts, the profile limit could be as low as one or two posts, since even one bona fide posting that passes moderation should identify the user as a non-spammer.

I'm surprised that the spammers have not defeated the moderation by simply copying verbatim some other successful post (or maybe they have?). I know I don't bother to run a search before approving a new post. I hope that's more time and effort than they're willing to put into it.
AOO4/LO5 • Linux • Fedora 23
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: [Solved] How about deleting spammers account?

Post by kingfisher »

I may have missed the point but can't you let the account remain without any signature containing a link? In other words, can you remove the spam part of the signature and NOT delete the account?
Apache OpenOffice 4.1.9 on Linux
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: [Solved] How about deleting spammers account?

Post by floris v »

Only admins can edit a user's signature and profile information. So that would put quite a load on the admins' shoulders.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] How about deleting spammers account?

Post by Hagar Delest »

In fact, I already remove the spam links in both website field and signature for each new spam account...
And, yes, that's quite some load.
So to sum up: spammers are banned by mods, I remove the spam links and add them to the Banned user group so that they can be easily counted in the statistics and to avoid checking them several times (hence the black color for user names).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: [Solved] How about deleting spammers account?

Post by acknak »

I can help to remove the spam links but I don't know how to find the spammer profiles.
AOO4/LO5 • Linux • Fedora 23
User avatar
floris v
Volunteer
Posts: 4422
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: [Solved] How about deleting spammers account?

Post by floris v »

In the ACP, select manage user, then in the Manage user screen, select Signature from the Select form list box in the top right hand corner.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] How about deleting spammers account?

Post by Hagar Delest »

What I do is sort the member list by last joined and check all the new accounts that are 0 post. If there is one with a spam signature, I click the Administrate user link to access his profile right away, to ban him first them add him to Banned user group (and set that group as default to make them appear in black) and then remove the spam. Same if there is a spam link in website field.

I also perform a second sort of members by Last active date to spot the 0 post users who wait several days before coming back to change their signature (those are tricky ones). With Firefox, I've set shortcuts in the smart bar that call those searches to save some clicks.

I also check the moderator log to see what users have been banned by mods to add them to the Banned group (and to make sure there is no spam in the signature).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Post Reply