Page 1 of 2 12>
Topic Options
#183782 - 2007-12-17 04:07 PM KForg Problem ... Paging Rod or Shawn
Jochen Administrator Offline
KiX Supporter
*****

Registered: 2000-03-17
Posts: 6380
Loc: Stuttgart, Germany
I get a phpbb_session table is full trying to login \:\(
_________________________



Top
#183794 - 2007-12-17 08:50 PM Re: KForg Problem ... Paging Rod or Shawn [Re: Jochen]
NTDOC Administrator Offline
Administrator
*****

Registered: 2000-07-28
Posts: 11625
Loc: CA
Confirmed from here as well.

 Quote:
phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1114 The table 'phpbb_sessions' is full

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('hex stuff here', -1, 1197920985, 1197920985, 'hex stuff here', 0, 0, 0)

Line : 187
File : sessions.php

Top
#183813 - 2007-12-18 02:31 AM Re: KForg Problem ... Paging Rod or Shawn [Re: NTDOC]
Shawn Administrator Offline
Administrator
*****

Registered: 1999-08-13
Posts: 8611
I pinged Rod a few hours ago. You know those Brits though eh, prolly singing in some pub somewhere drinking Guiness.
Top
#183829 - 2007-12-18 10:59 AM Re: KForg Problem ... Paging Rod or Shawn [Re: Shawn]
Mart Moderator Offline
KiX Supporter
*****

Registered: 2002-03-27
Posts: 4673
Loc: The Netherlands
 Originally Posted By: Shawn

....
You know those Brits though eh, prolly singing in some pub somewhere drinking Guiness.


Aren’t it the Irish that do that? \:\)
_________________________
Mart

- Chuck Norris once sold ebay to ebay on ebay.

Top
#183842 - 2007-12-18 12:46 PM Re: KForg Problem ... Paging Rod or Shawn [Re: Mart]
Arend_ Moderator Offline
MM club member
*****

Registered: 2005-01-17
Posts: 1896
Loc: Hilversum, The Netherlands
Guinness is what the Irish drink, Brits mostly drink only Lager types of beer \:\)
Top
#183858 - 2007-12-18 02:31 PM Re: KForg Problem ... Paging Rod or Shawn [Re: Arend_]
Les Offline
KiX Master
*****

Registered: 2001-06-11
Posts: 12734
Loc: fortfrances.on.ca
Brits drink dark brown stout served at room temperature.
_________________________
Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.

Top
#183919 - 2007-12-19 10:03 AM Re: KForg Problem ... Paging Rod or Shawn [Re: Les]
Mart Moderator Offline
KiX Supporter
*****

Registered: 2002-03-27
Posts: 4673
Loc: The Netherlands
I think he is suffering a hangover or something cause kforg is still down \:\(
_________________________
Mart

- Chuck Norris once sold ebay to ebay on ebay.

Top
#184022 - 2007-12-20 02:56 PM Re: KForg Problem ... Paging Rod or Shawn [Re: Mart]
rclarke Offline
Starting to like KiXtart
*****

Registered: 2001-06-08
Posts: 178
Loc: Oxfordshire, United Kingdom.
Don't worry ... I am on the case

Rod.


Edited by rclarke (2007-12-20 03:05 PM)

Top
#184025 - 2007-12-20 03:05 PM Re: KForg Problem ... Paging Rod or Shawn [Re: rclarke]
rclarke Offline
Starting to like KiXtart
*****

Registered: 2001-06-08
Posts: 178
Loc: Oxfordshire, United Kingdom.
All is fixed now \:\)
Top
#184052 - 2007-12-20 08:59 PM Re: KForg Problem ... Paging Rod or Shawn [Re: rclarke]
NTDOC Administrator Offline
Administrator
*****

Registered: 2000-07-28
Posts: 11625
Loc: CA
Thanks Rod... so how was that all night bender at the Pub ;\)
Top
#184431 - 2008-01-06 11:14 AM Re: KForg Problem ... Paging Rod or Shawn [Re: NTDOC]
Mart Moderator Offline
KiX Supporter
*****

Registered: 2002-03-27
Posts: 4673
Loc: The Netherlands
And it's back. Maybe it's an idea to setup a DB job that clears the phpbb_sessions table of records that are x days old and schedule it every x days?

 Quote:

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1114 The table 'phpbb_sessions' is full

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('1c45e455cfe909bd1256ad5735abc6a3', 526, 1199614192, 1199614192, '525d41ef', 0, 1, 0)

Line : 187
File : sessions.php


Edited by Mart (2008-01-06 11:14 AM)
_________________________
Mart

- Chuck Norris once sold ebay to ebay on ebay.

Top
#184432 - 2008-01-06 11:25 AM Re: KForg Problem ... Paging Rod or Shawn [Re: Mart]
Jochen Administrator Offline
KiX Supporter
*****

Registered: 2000-03-17
Posts: 6380
Loc: Stuttgart, Germany
Wonder how long it takes this time, before Rod either gets out of the Pub or back from his fireworks activities \:\)
_________________________



Top
#184433 - 2008-01-06 11:27 AM Re: KForg Problem ... Paging Rod or Shawn [Re: Jochen]
Mart Moderator Offline
KiX Supporter
*****

Registered: 2002-03-27
Posts: 4673
Loc: The Netherlands
_________________________
Mart

- Chuck Norris once sold ebay to ebay on ebay.

Top
#184435 - 2008-01-06 01:53 PM Re: KForg Problem ... Paging Rod or Shawn [Re: Mart]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
this has happened before and rod blamed it on some bots...
in such case, cleaning of session records should be way quick and that would disable all normal user activity.

there should be a more clever approach or simply only allow new sessions 1 per 10s or so.

or just increase the table size.
_________________________
!

download KiXnet

Top
#184436 - 2008-01-06 02:32 PM Re: KForg Problem ... Paging Rod or Shawn [Re: Lonkero]
Jochen Administrator Offline
KiX Supporter
*****

Registered: 2000-03-17
Posts: 6380
Loc: Stuttgart, Germany
atm, kforg is reachable \:\)
_________________________



Top
#184437 - 2008-01-06 02:33 PM Re: KForg Problem ... Paging Rod or Shawn [Re: Lonkero]
rclarke Offline
Starting to like KiXtart
*****

Registered: 2001-06-08
Posts: 178
Loc: Oxfordshire, United Kingdom.
Problem cleared ... there is a new bot out there which is evidently so badly implemented that it effectively causes a DoS. Their IP range has now been banned so that should solve the issue in the short term. There is still a fundamental issue with the sessions table in phpBB 2.x which is resolved in version 3 which was finally released just before Christmas. When I get some free time I will upgrade the KiXforms Bulletin Board, however a lot of other things will change as well so it is not something I want to do a rush job on.

Rod.


Edited by rclarke (2008-01-06 02:34 PM)

Top
#184438 - 2008-01-06 02:38 PM Re: KForg Problem ... Paging Rod or Shawn [Re: rclarke]
Jochen Administrator Offline
KiX Supporter
*****

Registered: 2000-03-17
Posts: 6380
Loc: Stuttgart, Germany
A Bot that causes DoS ... hmmm ... isn't this called either terrorism or is it only a lazy coder on the other side ??
_________________________



Top
#184439 - 2008-01-06 02:40 PM Re: KForg Problem ... Paging Rod or Shawn [Re: rclarke]
Glenn Barnas Administrator Offline
KiX Supporter
*****

Registered: 2003-01-28
Posts: 4401
Loc: New Jersey
Would you mind sharing their IP range and identity?

Glenn
_________________________
Actually I am a Rocket Scientist! \:D

Top
#184440 - 2008-01-06 02:42 PM Re: KForg Problem ... Paging Rod or Shawn [Re: Glenn Barnas]
rclarke Offline
Starting to like KiXtart
*****

Registered: 2001-06-08
Posts: 178
Loc: Oxfordshire, United Kingdom.
Sure ... take a look at http://www.cuill.com/ ... it causes havoc with phpBB and has been loitering on KFO for literally days now.

Rod.


Edited by rclarke (2008-01-06 02:43 PM)

Top
#184442 - 2008-01-06 03:02 PM Re: KForg Problem ... Paging Rod or Shawn [Re: rclarke]
Glenn Barnas Administrator Offline
KiX Supporter
*****

Registered: 2003-01-28
Posts: 4401
Loc: New Jersey
Thanks!

Glenn
_________________________
Actually I am a Rocket Scientist! \:D

Top
Page 1 of 2 12>


Moderator:  Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 1574 anonymous users online.
Newest Members
BeeEm, min_seow, Audio, Hoschi, Comet
17882 Registered Users

Generated in 0.094 seconds in which 0.043 seconds were spent on a total of 14 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org