What happened!

[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.

[shineydave]

yup, what it means is the server has rolled over and poor Phil is too tired from BabyPhilT feeding duties to reset it

[GardinerG]

Auto reset or reboot if required?

Just a thought.

[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.

[MarkB]

I might be able to help if you email me details of what you need to do...

[bobbler]

Anything others can do to help keep the site up and running at all?
Webspace or donations or anything?

[mikeyquattro]

I was getting myself in a right pickle!!

Cant be dealing with cold turkey

[QuantumJohn]

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

[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

[Jarv]

Good work Phil.

[neily]

Yeah Phil, defintiely good work....

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

[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

[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?

[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

[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.