'phpbb_sessions' full errors

Anything and everything that's related to OGRE or the wider graphics field that doesn't fit into the other forums.
Post Reply
User avatar
sinbad
OGRE Retired Team Member
OGRE Retired Team Member
Posts: 19269
Joined: Sun Oct 06, 2002 11:19 pm
Location: Guernsey, Channel Islands
x 66
Contact:

'phpbb_sessions' full errors

Post by sinbad »

For info, we're getting this because some guest is repeatedly hammering the server with temporary sessions. Unfortunately phpBB2 does not have automatic protection from this in the stable version yet.

I have the IP of the source that's causing this and will be investigating.
User avatar
sinbad
OGRE Retired Team Member
OGRE Retired Team Member
Posts: 19269
Joined: Sun Oct 06, 2002 11:19 pm
Location: Guernsey, Channel Islands
x 66
Contact:

Post by sinbad »

Single IPs are now limited to 50 sessions at a time. This should resolve the problems we've been encountering. It does mean that there can only be 50 users online at a time from behind a single corporate firewall, but I think we can live with that :)
User avatar
sinbad
OGRE Retired Team Member
OGRE Retired Team Member
Posts: 19269
Joined: Sun Oct 06, 2002 11:19 pm
Location: Guernsey, Channel Islands
x 66
Contact:

Post by sinbad »

And for info, the IP/domain responsible for the recent problems is dsic.upv.es.

I'm ready to ban the IP responsible unless anyone from that domain can give me a damn good reason why I shouldn't. :evil:
Poldi
Gnoblar
Posts: 10
Joined: Tue Jun 01, 2004 11:55 pm

Post by Poldi »

I had this error once 1-2 weeks ago :oops: but I am not from that domain you mentioned.

It happens if you use Opera or Konqueror in the mode where it reopens the last opened windows and many of them are (your favourite) ogre forum threads. You can do this up to maybe 10 threads and then get/cause this error. I closed many thread tabs and did not get this error again.
User avatar
leedgitar
OGRE Community Helper
OGRE Community Helper
Posts: 61
Joined: Wed Jan 22, 2003 1:58 am
Location: Baltimore, MD
Contact:

Post by leedgitar »

FWIW, last night I encountered a real strange problem after posting a reply to a message here. IE started going crazy and spawning new windows left and right, which halted after I ended the iexplore.exe task. I've only seen that happen once, and am at a loss to explain what would cause that to happen (the Ogre forums was the only IE window I had open at the time).
User avatar
sinbad
OGRE Retired Team Member
OGRE Retired Team Member
Posts: 19269
Joined: Sun Oct 06, 2002 11:19 pm
Location: Guernsey, Channel Islands
x 66
Contact:

Post by sinbad »

@Poldi: I doubt it was your fault :) While watching this IP in action I've seen it create 28 session in 5 seconds, and 900 in a couple of minutes. Seems to be sporadic since there's none of them on right now, but when they do come on they flood the system. 10 sessions wouldn't do it - we can have 2500+ of them if need be.

Looking at their access patterns today, they seem to be browsing developer profiles rather than forum threads. That makes me pretty sure this is an email address harvester, perhaps being run by someone at that university. We should be insulated against it now, but if I see it again and it's the same access pattern, I'll ban it, and anyone wanting to access these forums from that uni will just have to find the b*stard who's been doing this themselves and give them a well deserved kicking.

@leedgitar: I've never seen this happen, but then I rarely use IE. Get a decent browser mate :)
User avatar
Ctaesis
Gnoblar
Posts: 14
Joined: Thu Apr 01, 2004 12:53 am

Post by Ctaesis »

IE started going crazy and spawning new windows left and right, which halted after I ended the iexplore.exe task.
The solution to your problem is here.
User avatar
Antiarc
Greenskin
Posts: 120
Joined: Thu Jan 23, 2003 8:40 am
Contact:

Post by Antiarc »

sinbad wrote:Looking at their access patterns today, they seem to be browsing developer profiles rather than forum threads. That makes me pretty sure this is an email address harvester, perhaps being run by someone at that university. We should be insulated against it now, but if I see it again and it's the same access pattern, I'll ban it, and anyone wanting to access these forums from that uni will just have to find the b*stard who's been doing this themselves and give them a well deserved kicking.
If you'd like, I can write you a script that can be used to intercept requests from that IP, and which will just read garbage from /dev/random and pipe it to his browser ;)
User avatar
PeterNewman
Greenskin
Posts: 128
Joined: Mon Jun 21, 2004 2:34 am
Location: Victoria, Australia
Contact:

Post by PeterNewman »

@leedgitar: Not to hijack the thread, but that sounds like a virus/work thats going around. It infects unsecure IIS servers (often add banner servers) then uses a vulnerability in IE to spread to more IIS servers.
Although if OGRE forums was the only place you had open, it shouldn't have been that, but who knows with IE? :roll:
User avatar
Snugglebear
Gnoblar
Posts: 22
Joined: Wed Oct 01, 2003 7:38 am
Location: California

Post by Snugglebear »

leedgitar wrote:FWIW, last night I encountered a real strange problem after posting a reply to a message here. IE started going crazy and spawning new windows left and right, which halted after I ended the iexplore.exe task. I've only seen that happen once, and am at a loss to explain what would cause that to happen (the Ogre forums was the only IE window I had open at the time).
Hunt for spyware. IE is that drunk high school cheerleader at the fraternity party. You would not believe how much is going around and how long it takes to dislodge it once you contract something.
User avatar
Antiarc
Greenskin
Posts: 120
Joined: Thu Jan 23, 2003 8:40 am
Contact:

Post by Antiarc »

Snugglebear wrote:
leedgitar wrote:FWIW, last night I encountered a real strange problem after posting a reply to a message here. IE started going crazy and spawning new windows left and right, which halted after I ended the iexplore.exe task. I've only seen that happen once, and am at a loss to explain what would cause that to happen (the Ogre forums was the only IE window I had open at the time).
Hunt for spyware. IE is that drunk high school cheerleader at the fraternity party. You would not believe how much is going around and how long it takes to dislodge it once you contract something.
Not to mention that you can now catch a certain keylogger just by pulling up carefully-crafted images.
User avatar
leedgitar
OGRE Community Helper
OGRE Community Helper
Posts: 61
Joined: Wed Jan 22, 2003 1:58 am
Location: Baltimore, MD
Contact:

Post by leedgitar »

Ctaesis wrote:
IE started going crazy and spawning new windows left and right, which halted after I ended the iexplore.exe task.
The solution to your problem is here.
Bwahaha. I was actually going to post a smart ass response to that, but instead I downloaded it and I'm hooked :D
dermont
Bugbear
Posts: 812
Joined: Thu Dec 09, 2004 2:51 am
x 42

Post by dermont »

I just received the following error trying to access the forum:

Code: Select all

phpBB : Critical Error Error creating new session DEBUG MODE
SQL Error : 1114 The table 'phpbb_sessions' is ful
User avatar
temas
OGRE Retired Team Member
OGRE Retired Team Member
Posts: 390
Joined: Sun Oct 06, 2002 11:19 pm
Location: The Woodlands, TX
Contact:

Post by temas »

Thanks, I'll look into it, and turn off debug mode ;)
Post Reply