Blofeld
Member
- Joined
- Jun 23, 2019
- Messages
- 39
- Reaction score
- 30
- Country
Don't hope so! I have some spare time this weekend and wanted to do some research for Guns and Infanty only scenarios... ?Seems like a weekend thing....
Don't hope so! I have some spare time this weekend and wanted to do some research for Guns and Infanty only scenarios... ?Seems like a weekend thing....
Still down at 0815 MST 12 DecAppears to be down at 9:30pm MST on 11 Dec 2019....
Warning: mysqli_connect(): (08004/1040): Too many connections in /var/www/asl/top.php on line 57
Notice: Trying to get property 'connect_errno' of non-object in /var/www/asl/top.php on line 58
Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /var/www/asl/top.php on line 72
Notice: Trying to get property 'error' of non-object in /var/www/asl/top.php on line 72
Failed Query 123: Select * from users where is_bot=0 and (lower(login)='michael dorosh' or lower(email)='michael dorosh') and (enc_password='c3f2a47cd6bc5a64393f72ee770741bf766' or enc_password=sha1('c3f2a47cd6bc5a64393f72ee770741bf766'))
Ended
Same here. But it is up now.I get this:
Code:Warning: mysqli_connect(): (08004/1040): Too many connections in /var/www/asl/top.php on line 57 Notice: Trying to get property 'connect_errno' of non-object in /var/www/asl/top.php on line 58 Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in /var/www/asl/top.php on line 72 Notice: Trying to get property 'error' of non-object in /var/www/asl/top.php on line 72 Failed Query 123: Select * from users where is_bot=0 and (lower(login)='michael dorosh' or lower(email)='michael dorosh') and (enc_password='c3f2a47cd6bc5a64393f72ee770741bf766' or enc_password=sha1('c3f2a47cd6bc5a64393f72ee770741bf766')) Ended
I used it last week with no problems. They just underwent a site redesign so it seems unlikely it would be abandoned. The feller who does the Illuminating Round youtube channel maintains it.Seems like this website is up and down a lot. Is it still being maintained as of July 2020?
Well damn, Dave. What kinda service do people GET for their money, anyway?The problem is sometimes I'm sleeping
You have to rate-limit requests. I've dealt with these assholes before, and they can be tenacious :-/ But as a quick fix, banning IP's and/or user agents might be enough. If you send me the logs, I can write you a quick script to extract that information.Every now and again (usually every couple of days) a bot hits the site and requests thousands of advanced searches.
Your site is fantastic, by the way. Big massive, gi-normous thumbs up. ???Hey guys,
Just to explain.. Every now and again (usually every couple of days) a bot hits the site and requests thousands of advanced searches. The database connections are recycled and are closed correctly, but there are a finite number of connections, and if you open a request faster than a slow(ish) advanced (25-200ms) search runs you eat into the connections available. At a certain point the database just gives up and seems to die. Now - that shouldn't happen - but I think what goes on is that if a connection is recycled every few minutes, and at that point the bot has queued up a few thousand more requests, no matter how many connections are recycled, the site can't recover because each time a new connection is available the request has been lined up ready to request another search.
Have you tried to restrict its access via a robots.txt file?Hey guys,
Just to explain.. Every now and again (usually every couple of days) a bot hits the site and requests thousands of advanced searches.
Yep - see my post above.Have you tried to restrict its access via a robots.txt file?
Rate-limiting from my initial investigation wasn't quite right as that seemed to do things on a bandwidth level, the search results page isn't very resource intensive from a bandwidth perspective, I need limit the actual number of requests per minute from any given source (to somewhere around 30-60 I'd think). I think mod_evasive does this, and that's the next step, if it continues.You have to rate-limit requests.