Advertisement:

Author Topic: httpBL  (Read 473800 times)

Offline Shades.

  • Jr. Member
  • **
  • Posts: 380
  • Gender: Male
  • BikerHound.com
    • bikerhound on Facebook
    • @bikerhoundcom on Twitter
    • Bikerhound.com
Re: httpBL
« Reply #1360 on: December 31, 2020, 03:07:18 PM »
Congrats, and I'm so sorry at the same time :P
eh well simple enough to disable ipv6 on my computer  ;D 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.  :o 8)

BikerHound.com
Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,390
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: httpBL
« Reply #1361 on: December 31, 2020, 03:11:37 PM »
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.
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.0 installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Online shadav

  • Support Team Apprentice
  • Sr. Member
  • ****
  • Posts: 856
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: httpBL
« Reply #1362 on: December 31, 2020, 03:24:57 PM »
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)

Offline SugarD-x

  • Jr. Member
  • **
  • Posts: 398
  • Gender: Male
  • SMF and PHPBB Fan
    • SugarDx on Facebook
    • SugarD-x on GitHub
    • sugardx on LinkedIn
    • @SugarDx on Twitter
    • Clan Xperience
Re: httpBL
« Reply #1363 on: January 03, 2021, 10:34:32 AM »
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. :(