What is msg_hdr_ip?

[redhair]

Just a small question related to my hunt for banning a spammer.

[Nibbler]

The IP address of the comment poster.

[Joachim Müller]

Regular support question. Belongs into support board. Moving accordingly.

[redhair]

ok .. the ip, but I also spot (many different) IP's at msg_raw_ip.
Whats the difference between both?

[Nibbler]

What do you mean?

[redhair]

I see in mysql two rows related to IP's.
One beeing msg_raw_ip and the other msg_hdr_ip.
I am beeing honoured by a spammer that likes to leave comments on my photography.
The field 'msg_raw_ip' is always different, while msg_hdr_ip continous to be the same (of that same user).
So I was wondering..
I guess my spammer found a way to have different msg_hdr_ip's, but cannot escape from msg_raw_ip.

[Nibbler]

raw ip is from $_SERVER['REMOTE_ADDR']
header ip is from $_SERVER['HTTP_X_FORWARDED_FOR'] if available.

[redhair]

Thank's!

Is there a mod that will hang the spammer by it's balls? (not a serious question).

It's very frustrating to have my pictures commented with the kind of comments he leave...

[Joachim Müller]

As suggested various times, there are 4 options to fight the spam problem:
1) Disable anonymous comments
2) Apply the captcha plugin or mod
3) Apply the Akismet mod
4) If you're adventurous and not afraid of alpha-stage software, check out the devel branch of the SVN and use the comment approval feature there (keep in mind that the devel version goes completely, utterly unsupported)

[redhair]

Yeah! thanks for that as well.
I had some oxygen, and feel a lot better now.
I'm gonne have a look at these solutions later on.

[Joachim Müller]

Another suggestion: don't even bother to ban spammers by IP, they spoof it anyway and will return later with another set of IP addresses.