Topic: httpBL

[Shades.]

Congrats, and I'm so sorry at the same time

eh well simple enough to disable ipv6 on my computer  and I'm back up and running again...

hm, but this could be a problem for my users...hm.....well about that....may still need to remove this mod anyways if others who use ipv6 can't access the site, that's gonna be an issue

I just tested my connection at testmyipv6.com and it says Im on this ipv6. I'm also using this mod on several of my sites and have had no issues myself. I hope this wont be a problem. 

[Aleksi "Lex" Kilpinen]

Could also be a different version of the mod, or something else differing - but based on the error I saw, the DB field for IP in shadav's install couldn't hold an IPv6 address because of it's length.

[shadav]

here's where Lex is talking about

after a day of my site being down...I thought it was my host at first but then turns out it wasn't....for me I was seeing database error message but for everoyne else the site was fine....
after checking error logs httpbl was the one giving issues...which again is strange as it hadn't ever popped up before

https://www.simplemachines.org/community/index.php?topic=576208.0

after fixing the default to null, the last error that showed up was

Database Error: Data too long for column 'ip' at row 1<br /><br /><br />         INSERT INTO smf_log_httpBL(`logTime`, `ip`, `threat`, `last_activity`, `suspicious`, `harvester`, `comment`, `url`, `user_agent`, `errorNumber`, `username`, `raw`, `stopped`)<br />         VALUES<br />            (1609402130, '2601:805:8204:1430:7415:e9a:1fa1:68ab', 0, 0, 0, 0, 0, '/index.php?action=enotify', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36', 200, 'Guest', 'unknown', 2)

[SugarD-x]

Database Error: Data too long for column 'ip' at row 1<br /><br /><br />         INSERT INTO smf_log_httpBL(`logTime`, `ip`, `threat`, `last_activity`, `suspicious`, `harvester`, `comment`, `url`, `user_agent`, `errorNumber`, `username`, `raw`, `stopped`)<br />         VALUES<br />            (1609402130, '2601:805:8204:1430:7415:e9a:1fa1:68ab', 0, 0, 0, 0, 0, '/index.php?action=enotify', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36', 200, 'Guest', 'unknown', 2)

That's likely because SMF 2.0.x is designed to store IPv4 addresses only, which are a specific length. IPv6 support was officially added in SMF 2.1.x, however this mod sadly has not been updated to support those versions yet.

[spiros]

I just upgraded  to smf 2.0.18 and php 7.4  and I get multiple errors in error log:

Code: [Select]

8: Trying to access array offset on value of type null
 /home/translat/public_html/forum/Sources/httpBL_Subs.php
Line 674
$values['raw'] = $txt['httpBL_unknown'];
Line: 672
$values['username'] = $user_info['is_guest'] ? $txt['guest'] : $user_info['username'];

[Kolya]

I'm also on smf 2.0.18. I don't get any errors, possibly because I disabled all the translation stuff long ago.
But the mod is clearly not working either. HttpBL's spammers log just lists a lot of IPv6 addresses, without any further information besides "Guest" in the User column.
I've disabled this mod for now.

[spiros]

Yes, I had to disable it until a fix is provided -:)
Pity, because it is a good mod.
Nice theme in your site by the way, which one is it?

[SugarD-x]

Your issue is probably because of the same problem others are having:

That's likely because SMF 2.0.x is designed to store IPv4 addresses only, which are a specific length. IPv6 support was officially added in SMF 2.1.x, however this mod sadly has not been updated to support those versions yet.

[Kolya]

Nice theme in your site by the way, which one is it?

Thanks, it is self-created. Worked on it for some 15 years and became a frontend-dev over that.

[riou]

I just upgraded  to smf 2.0.18 and php 7.4  and I get multiple errors in error log:

Code: [Select]

8: Trying to access array offset on value of type null
 /home/translat/public_html/forum/Sources/httpBL_Subs.php
Line 674
$values['raw'] = $txt['httpBL_unknown'];
Line: 672
$values['username'] = $user_info['is_guest'] ? $txt['guest'] : $user_info['username'];

it seems the problem is that it doesn't find values for those $txt things if you replace $txt['guest'] with "guest" and $txt['httpBL_unknown'] with "unknown" (what they match in the english mod language file) it will make it stop erroring, not sure why it isn't picking it up from the language files anymore, not sure if more of the $txt's will have to do this too or not for now

[Shades.]

I have this installed and working fine on several 2.0.17 sites but on one site I try to install it and get the following:

Code: [Select]

Table 'mysite_xxxx.bh_log_httpBL' doesn't exist
File: /home2/mysite/public_html/xxxx/Packages/temp/install_2.php
Line: 68
Do i need to create that table and if so how or what is the query?

Just installed it on a fresh 2.0.18 install and it works fine but still cant get it to install on the site in quotes because the table doesnt exist. Any help on this please?