Page 1 of 3

What happened!

Posted: Sun Jul 01, 2007 10:12 am
by Philws4
Is this what other people get when the site goes 'belly up' or is it just me?
Seemed to be down for most of yesterday afternoon and evening.

Problem in Database Connection



This Website is powered by PostNuke


Although this site is running the PostNuke software
it has no other connection to the PostNuke Developers.
Please refrain from sending messages about this site or its content
to the PostNuke team, the end will result in an ignored e-mail.

RE: What happened!

Posted: Sun Jul 01, 2007 10:14 am
by shineydave
yup, what it means is the server has rolled over and poor Phil is too tired from BabyPhilT feeding duties to reset it :D

RE: What happened!

Posted: Sun Jul 01, 2007 3:57 pm
by GardinerG
Auto reset or reboot if required?

Just a thought.

RE: What happened!

Posted: Mon Jul 02, 2007 11:43 am
by PhilT
The reality is that the site is begging for the new server to be put in place - But time is limited. I have considered an auto reboot, but need help with a cron script that does a wget and then a reboot based on what is returned.

RE: What happened!

Posted: Mon Jul 02, 2007 12:08 pm
by MarkB
I might be able to help if you email me details of what you need to do...

RE: What happened!

Posted: Thu Jul 05, 2007 5:36 pm
by bobbler
Anything others can do to help keep the site up and running at all?
Webspace or donations or anything?

RE: What happened!

Posted: Thu Jul 05, 2007 5:39 pm
by mikeyquattro
I was getting myself in a right pickle!!

Cant be dealing with cold turkey :notworthy: :drink: :kissmyrings: :thumbs:

Re: RE: What happened!

Posted: Fri Jul 06, 2007 9:10 am
by QuantumJohn
bobbler wrote:Anything others can do to help keep the site up and running at all?
Webspace or donations or anything?
Phil,
I second this. Am happy to send a donation if it is going to help. I could buy more rs246.com stickers if you want but the car might look a bit odd with so many on it!

John

RE: Re: RE: What happened!

Posted: Fri Jul 06, 2007 1:16 pm
by PhilT
Seems to be getting more frequent, and I think there are two solutions:

- Auto reboot when it dies - Investigating
- Get the new server in place - In progress

Posted: Fri Jul 06, 2007 1:57 pm
by Jarv
Good work Phil.

Posted: Fri Jul 06, 2007 2:41 pm
by neily
Yeah Phil, defintiely good work....

More than happy to donate a few pennies if it helps keep the forum up and running !!!

Posted: Mon Jul 09, 2007 9:41 am
by oliew
Phil
u could do a cron job every sunday to do an init 6 as Su - root
or even easier try a "service apache restart" every week..
could do with seeing why it falls over resources issue?
i have an auto reboot running every week on a server just so the resources dont get used up by the JSP applets running on it.
Oli

Posted: Mon Jul 09, 2007 2:01 pm
by PhilT
Thanks Oli & Mark. I was thinking along the lines of:

- Run a cron job every hour to wget http://www.rs246.com/
- grep the output and if the string "Problem in Database Connection" exists, then reboot.

My first problem is that I did a bare install of Redhat on this box and did not include wget, so I have been trying to find an rpm as I don't have make either..... Being a security guy, I wanted to reduce the installed components and therefore potential threats.

Any ideas?

Posted: Mon Jul 09, 2007 3:17 pm
by oliew
phil what redhat u running
im sure u could get the source and do a "configure then "make" etc..

doin wget on a script that would init 6 the server sounds like a good idea, but id be interested to see why the connection breaks in the first place. ?
is it mysql fallin over.
Oli

Posted: Mon Jul 09, 2007 7:10 pm
by PhilT
The OS is (out of date!!): Linux 2.4.20-30.9smp #1 SMP Wed Feb 4 20:36:46 EST 2004 i686 i686 i386 GNU/Linux

Make is not available, hence the search for the wget rpm.

Not sure of the cause of the crash - Will need to investigate the next time it happens.