serendipity_spamblocklog

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
david@mediacopy
Regular
Posts: 56
Joined: Sun May 18, 2008 5:50 pm

serendipity_spamblocklog

Post by david@mediacopy »

Hi,

Is it safe to delete records in this table ?

Mine is currently at 45Mb (!) after only a few weeks.

We seem to be getting lots of hits on the site trying to spam us seemingly from automated bots.

I've turned 'up' the moderation and that's stopped them making any posts but the load on the server must be big.

Is there anything I can do to reduce this - I see a post regarding something with the HTaccess file - is there more clarification on this ?

Other than the Spam issue I'm really pleased with Serendipity :-)

Cheers & Thanks

David
tpost
Regular
Posts: 77
Joined: Fri Sep 21, 2007 1:45 am

Post by tpost »

Hi David,

We used to keep our spamblock log as well.
Ours hit more than 200 MB!

We use the Akismet API in Spamblock combined with the ReCaptcha plugin as a one-two punch against blog spam.

We disabled the log over here because Akismet is pretty decent at catching 99% of the spam... sometimes though the occassional trackback ping spam occurs, and sometimes some comments are incorrectly marked as spam, but i think that is a small price to pay!
david@mediacopy
Regular
Posts: 56
Joined: Sun May 18, 2008 5:50 pm

Post by david@mediacopy »

Cheers. We're not getting much actual spam through so not loggin is cool with me.

How did you disable the log ?

(I can't log into admin at the moment due to other problems :cry: )
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

You can turn it off by configuring the anti-spam plugin through the admin interface.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
david@mediacopy
Regular
Posts: 56
Joined: Sun May 18, 2008 5:50 pm

Post by david@mediacopy »

I've switch the setting to a log file for now.

Is it safe to delete the contents of serendipity_spamblocklog using phpmyadmin ?

And when the log file is too big is it sage to delete it out using my ftp client ?

thanks for your help (should be my last question !)

Best

David
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Yes, the file is purely for your own information, it is not evaluated by s9y itself. You can delete if if you don't need it any longer.

Same applies to the file via FTP.

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
david@mediacopy
Regular
Posts: 56
Joined: Sun May 18, 2008 5:50 pm

Post by david@mediacopy »

8)
Post Reply