Occaisional 'Unable to Connect' errors

What's happening at the Club. You can post your suggestions and ideas here, along with reports of any problems using the site.

Moderators: IMOC Moderators, IMOC Committee Members

BenF
Premium Member
Posts: 10764
Joined: Mon Dec 13, 2004 4:04 pm
Location: Ipswich
Contact:

Occaisional 'Unable to Connect' errors

Post by BenF »

Folks,

Just been doing some work on the database to correct the occasional 'unable to connect' errors you may have seen in the last couple of weeks.

If you find a page takes longer than 10 seconds to be generated, or you get a connection error message please post below the date, time and then the page generation time statistics from the bottom of the page in the format as below :

21:42, 13/5/09 : Page generation time: 0.7223s (PHP: 24% - SQL: 76%) - SQL queries: 31
21:42, 13/5/09 : Server Error : unable to connect to database

Cheers,

Ben
tonigmr2
IMOC Committee
Posts: 18054
Joined: Wed Dec 15, 2004 2:30 pm
Location: Here

Re: Occaisional 'Unable to Connect' errors

Post by tonigmr2 »

14/5/09 15.35 Critical error unable to connect.

T
BenF
Premium Member
Posts: 10764
Joined: Mon Dec 13, 2004 4:04 pm
Location: Ipswich
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by BenF »

Ta. Been doing some digging and although the server is fine ( only 8 out of 1.5 million requests since last night took longer than 10 seconds to complete ) it maybe be due to someone attempting to guess the passwords to login to the backend database [-X
User avatar
Scott Barton
IMOC Committee
Posts: 11170
Joined: Sun Mar 13, 2005 10:14 pm
Location: Wateringbury, Kent

Re: Occaisional 'Unable to Connect' errors

Post by Scott Barton »

BenF wrote:Ta. Been doing some digging and although the server is fine ( only 8 out of 1.5 million requests since last night took longer than 10 seconds to complete ) it maybe be due to someone attempting to guess the passwords to login to the backend database [-X


:shock:
IMOC - winners of JAE best overall club stand 2010, 2013, 2014 & 2017!
1994 GT-S T-Bar 397bhp with NOS *sold*
2016 Porsche Cayman 981GTS 347bhp Flat Six
jmachling
Posts: 3949
Joined: Wed Oct 26, 2005 8:49 pm
Location: Where the cider apples grow.

Re: Occaisional 'Unable to Connect' errors

Post by jmachling »

Hacker scum :evil: In the words of Jeff Goldblum:

"I hope all your kids have small dicks...and that includes the girls!" :lol:

I think they'll be guessing for a while - Ben's password kung fu is strong.
tonigmr2
IMOC Committee
Posts: 18054
Joined: Wed Dec 15, 2004 2:30 pm
Location: Here

Re: Occaisional 'Unable to Connect' errors

Post by tonigmr2 »

Another critical error at 9.36 today for me. :(

...and another at 11.30am.

...and another at 16.04.
T
BenF
Premium Member
Posts: 10764
Joined: Mon Dec 13, 2004 4:04 pm
Location: Ipswich
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by BenF »

tonigmr2 wrote:Another critical error at 9.36 today for me. :(

...and another at 11.30am.

...and another at 16.04.
T


Toni - did it also say 'Could not connect to the database' or similar ?
BenF
Premium Member
Posts: 10764
Joined: Mon Dec 13, 2004 4:04 pm
Location: Ipswich
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by BenF »

OK, have made some further short term adjustments.

There are also going to be a few further changes that I will make on Monday / Tuesday night next week.
tonigmr2
IMOC Committee
Posts: 18054
Joined: Wed Dec 15, 2004 2:30 pm
Location: Here

Re: Occaisional 'Unable to Connect' errors

Post by tonigmr2 »

phpBB : Critical Error

Could not connect to the database

at 13.33 today. :(
BenF
Premium Member
Posts: 10764
Joined: Mon Dec 13, 2004 4:04 pm
Location: Ipswich
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by BenF »

Yep, I've seen one as well today. I've just rebooted the server after some patches were installed - lets see if that helps.

The 'tweaks' I've planned will happen later in the week, and not tonight as originally planned. When I implement them I can do that without needing to take the website down.

Failing that, we will be moving servers in the next few weeks...
cantfindausername
Posts: 9202
Joined: Tue Dec 14, 2004 12:15 pm
Location: Crawley, West Sussex
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by cantfindausername »

I'm getting the phpBB : Critical Error. Had it about twice today and twice yesterday.

Haven't made notes of time as just found this post.

Will keep a track if it happens again.

I normally just go back and the resubmit request. Thankfully Firefox holds on to the post you've just entered! :clap:
Image
***RIP Car13 ***
*** Now in an Evo ***
cantfindausername
Posts: 9202
Joined: Tue Dec 14, 2004 12:15 pm
Location: Crawley, West Sussex
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by cantfindausername »

phpBB : Critical Error

Could not connect to the database

URL: http://www.imoc.co.uk/forums/posting.php
Occured at: 16:05
Image
***RIP Car13 ***
*** Now in an Evo ***
tonigmr2
IMOC Committee
Posts: 18054
Joined: Wed Dec 15, 2004 2:30 pm
Location: Here

Re: Occaisional 'Unable to Connect' errors

Post by tonigmr2 »

Same again at 8.38am this morning.
Flat Pack
Posts: 142
Joined: Thu Feb 15, 2007 11:50 pm
Location: Warrington
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by Flat Pack »

12:15, 20/5/09 : Server Error : unable to connect to database
Rhiannan
Posts: 6067
Joined: Mon Aug 13, 2007 4:42 pm
Location: Aberdeenshire
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by Rhiannan »

I've had quite a few critical errors today :?
BenF
Premium Member
Posts: 10764
Joined: Mon Dec 13, 2004 4:04 pm
Location: Ipswich
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by BenF »

Yep, looks like even after the work last night things aren't improving.

I've made some further changes this evening, lets see how things go tomorrow.

Given we're just about to receive our new dedicated server for the next year, and the first thing I'm going to do is to move the database across to it this weekend to see if that helps.

If nothing else, its a more powerful box so we should see a further small improvement in page generation times.
RST
Posts: 2891
Joined: Fri Dec 29, 2006 1:02 pm
Location: Inverness, Scotland

Re: Occaisional 'Unable to Connect' errors

Post by RST »

phpBB : Critical Error

Could not connect to the database
...2 of these in the last 2 minutes. But I've been getting these messages fairly regularly for probably about a year now. I just thought it was something to do with my connection.
Speedy
Posts: 8413
Joined: Thu Dec 16, 2004 10:38 am
Location: Leamington Spa
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by Speedy »

Doing some behind the scenes stuff now on the database to see whassup..
Speedy
Posts: 8413
Joined: Thu Dec 16, 2004 10:38 am
Location: Leamington Spa
Contact:

Re: Occaisional 'Unable to Connect' errors

Post by Speedy »

Ok, keep on posting if you think it's faster / slower, or you've got a connection refused problem.
tonigmr2
IMOC Committee
Posts: 18054
Joined: Wed Dec 15, 2004 2:30 pm
Location: Here

Re: Occaisional 'Unable to Connect' errors

Post by tonigmr2 »

Got a connection refused at 9.10am today.
T
Post Reply

Return to “Club News and Announcements”