Welcome to WebmasterWorld Guest from 54.167.213.22

Forum Moderators: rogerd

Message Too Old, No Replies

phpBB forum crashing the server

its only a baby one

     
8:47 am on Aug 22, 2006 (gmt 0)

10+ Year Member



I have recently installed phpBB on a dedicated server with a bunch of other sites.

The forum has around 4-500 members and about 20,000 posts, its been running for about six weeks and is quite active now.

It seems that this forum is responsible for overloading mySQL and shutting the server down quite frequently.

Does anyone have any experience of how to troubleshoot something like this so I can get it running again without losing the server every few days? I have tried scripts to clear the sessions table but it appears this wasnt the cause of the shutdowns.

9:29 am on Aug 22, 2006 (gmt 0)

WebmasterWorld Senior Member trillianjedi is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Don't use Session ID's - set it to use cookies only.

TJ

10:25 am on Aug 22, 2006 (gmt 0)

10+ Year Member



How do I turn sessions off?

I've set this one to enabled:

Cookie secure
If your server is running via SSL, set this to enabled, else leave as disabled

Is that what you meant? Still don't want to turn the damn thing back on yet!

10:45 am on Aug 22, 2006 (gmt 0)

WebmasterWorld Senior Member trillianjedi is a WebmasterWorld Top Contributor of All Time 10+ Year Member



I can't remember now, but I'm sure there's something in the admin panel for it. Switch off session ID's and use cookies only.

You may well have various bots getting caught in a loop on the SID's thereby causing the problem.

It's one of a few things to check. The other is to ensure that your copy of phpBB(2?) is patched up to date.

You shouldn't be having this problem - phpBB is fairly light on MySQL. My guess is you've got sesion ID's in your URL's and something is crawling you heavily.

Did you notice a large volume of "guests" viewing the forum?

TJ

6:14 am on Aug 23, 2006 (gmt 0)

10+ Year Member



The server is completely down now despite the fact that I disabled the forum yesterday.

The Admin for the box is also blaming this domain and saying it makes no difference if the domain is still active, I need to move it to another server.

Yes, there are probably quite a few guests, bandwidth is about 25 gig per month.

Couldnt find where to disable SIDs thou.

9:10 am on Aug 23, 2006 (gmt 0)

WebmasterWorld Senior Member trillianjedi is a WebmasterWorld Top Contributor of All Time 10+ Year Member



The server is completely down now despite the fact that I disabled the forum yesterday.

It's clearly not the forum then - time to look at other possibilities.

Couldnt find where to disable SIDs thou.

Oh well, if there's nothing in the docs then I guess they changed it since I last worked with it.

TJ

10:06 am on Aug 23, 2006 (gmt 0)

10+ Year Member



Thanks for bearing with me on this one, determined to get to the bottom of it.

Server Admin has disabled the domain so I have transfered it.

Now I'm having problems importing the database on the new server as the new system prefixes a "domain_" to the DB and usernames. So when I import it it gives me a "no permission" error as the old DB and usernames were without the prefix.

Any ideas? using phpMyAdmin and the DB is a phpBB on about 12Mb.

10:15 am on Aug 23, 2006 (gmt 0)

WebmasterWorld Senior Member trillianjedi is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Do a full MySQL export of the entire database and include "create tables".

Information on how to do that at the command line is in the MySQL docs - search for "mysqldump".

Or do that via phpMyAdmin. Never heard of anything prefixing table names - that sounds very annoying. Computers should do what you tell them to do.

TJ

10:59 am on Aug 23, 2006 (gmt 0)

WebmasterWorld Senior Member trillianjedi is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Additional:-

Ah, just realised, I guess you're on a shared host? Sounds like this prefix thing is the system the host is using to separate user databases.

I would find a provider that gives you full root access - a proper VPS rather than shared hosting.

TJ

8:37 am on Aug 24, 2006 (gmt 0)

10+ Year Member



Just spent the last 4 hours rebuilding all the phpBB tables and DB manually.

Changed the config.php file to match the new names but now just get this:

phpBB : Critical Error

Could not connect to the database

No explanation so don't know where to start looking. Help! I know the hosting company is a nightmare but its all we can afford at the moment. I suspect the connection issues are DB user related as in phpMyAdmin it says domain@localhost is the user and "no privileges".

9:41 am on Aug 24, 2006 (gmt 0)

WebmasterWorld Senior Member trillianjedi is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Could not connect to the database

That's the explanation.

Yes, likely to be a user/password/priviledges issue.

There should be some guidance in the hosting providers literature....

TJ

5:48 am on Aug 25, 2006 (gmt 0)

10+ Year Member



Its working now, the host fixed the priviliges issue, a little data loss but it seems to be functioning as usual.

Would still like to learn how to disable SIDs incase it occurs again ... though I'm inclined to think it was a DoS attack.

6:14 am on Aug 25, 2006 (gmt 0)

WebmasterWorld Administrator martinibuster is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



though I'm inclined to think it was a DoS attack.

It was likely someone else who was sharing the server with you. I had a similar experience. For one, there are lots of scraper bots out there stressing servers. So the server could have been pooping out on you because of that, or just too many cpu intensive apps running on it.

I disabled gzip, which provided some minimal relief. But ultimately I moved the whole thing to a dedicated server and haven't had a single problem, not one. So it was definitely not the software, it was the shared host.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month