View Single Post
  #3468  
Old 11 Dec 2017, 20:03
postcd postcd is offline
 
Join Date: Feb 2012
Skip this message, my problem. Solved

Hello, i am getting following error many times, and i am getting it only regarding this vB module, and from multiple vB forums hosted on same server of mine:

Invalid SQL:
INSERT INTO glowhostspamomatic_log(`date`, `ip`, `email`, `username`, `message`, `is_blocked`, `user_hash`) VALUES (now(), "85.174.*.*", "*@yandex.ru", "*", "Spam-O-Matic Tagged email - *@yandex.ru Unable to connect to StopForumSpam.com. This is probably due to some temporary problems on their website: Unable to check. User passed to vBulletin registration system per your settings at \'StopForumSpam: Query Connection Errors\'", "0", "**long*string*here");;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, December 11th 2017 @ 10:41:15 AM
Error Date : Monday, December 11th 2017 @ 10:42:26 AM
Script : http://mysitehere.com/register.php?do=addmember
Referrer : https://mysitehere.com/register.php?do=addmember
IP Address : 85.174.*.*
Username : *usernamehere*
Classname : vB_Database
MySQL Version :
MySQL server also gone away everytime i try to report spammer using this vB module (Glowhost spam-o-matic)

It do not appear like stopforumspam banned my server IP:
curl http://api.stopforumspam.org/api?username=spammer&json^C
[1]+ Done curl http://api.stopforumspam.org/api?username=spammer
root@host1 [/]# curl "http://api.stopforumspam.org/api?username=spammer&json"
{"success":1,"username":{"frequency":0,"appears":0}}r
I can login my SFS account, no problem.
UPDATE: i found these timeouts happening only from time to time. And during one timeout i tried to run this command on my hosting server: wget -O /dev/null stopforumspam.com and it timeout and shown SFS IPs and i searched logs for these IPs and also firewall and found these SFS IPs was banned on my firewall because somehow ended up in abuseipdb and stopforum spam blocklist, it could be also my fault.

Skip this message, my problem. Solved

Last edited by postcd; 30 Dec 2017 at 10:35.
Reply With Quote