KoratFart.com - Korat Forum / Isaan Forum for Art, News & Culture

News and Info Forums => Korat & Isaan Forums Support Desk => Topic started by: Johnnie F. on May 31, 2011, 09:48:22 AM

Title: Recent Downtime
Post by: Johnnie F. on May 31, 2011, 09:48:22 AM
Hi folks,

we did have a few hours downtime due to a database problem not caused by Russian hackers from Romania paid by a Korat usual suspect. Was my own clumsiness in dealing with a new web account admin panel. I think we lost a few posts from yesterday. They should all be on a backup on the server I made before "attacking" the database. Only getting that backup restored didn't work out like I expected. After I restored things as far as this now I don't want to risk loosing it all again by another attempt to get the newest backup restored over the already working forum. When I get time I might try to restore it on another database and copy the missed posts into the forum manually. But for the moment I need to relax.

Sorry for the inconvenience! :-[

In any case I learned something new, made a new experience. :-[

Johnny F.
Title: Re: Recent Downtime
Post by: sicho on May 31, 2011, 10:01:43 AM
Good to see you back!
Title: Re: Recent Downtime
Post by: Johnnie F. on May 31, 2011, 10:52:16 AM
Thanks! :)

Every time the forum tries unsuccessfully to connect to the database I get an email: "There has been a problem with the database! This is a notice email to let you know that SMF could not connect to the database, contact your host if this continues."

From the huge number of those emails (a couple hundred I guess) in my mailbox I can imagine how many people did miss this forum. Thanks to all for caring. :)
Title: Re: Recent Downtime
Post by: Toddy on May 31, 2011, 11:28:41 AM
I did wonder whether there was a problem, perhaps like the other forum. Glad to see that all is well!
Title: Re: Recent Downtime
Post by: Baby Farts on May 31, 2011, 01:17:55 PM
We already spoke about this on the phone. :)  Good to see the forum back and running again :)
Title: Re: Recent Downtime
Post by: dirtydog on May 31, 2011, 02:15:53 PM
It was a server problem not a koratfart problem, all sites on this ip went down.
Title: Re: Recent Downtime
Post by: Johnnie F. on May 31, 2011, 03:49:56 PM
That's true, I know of about a dozen. A couple more of mine, too. By now I understand the problem better: About half a year ago they moved a lot of web accounts to a new server. On the new server they changed the system of naming the databases, for example a db installed before the move was automatically named "usr_web999_1". If you backed it up on the server you can restore it again to an existent database "usr_web999_1", if its name is still intact. If by some mishap the database names get damaged, and not only their contents, there is the problem of the name. If you simply delete that damaged database and install a new one it will be named automatically "web999_db1". But the backup function cannot recognize it again, and your backup is fairly useless, unless you had downloaded it before your restoration attempt and get it now reconstructed manually. Once moved to the restoration folder it can't be downloaded anymore for direct insertion in phpMyAdmin apart from this database being already far too big for direct uploading via phpMyAdmin.

At the webhost they didn't understand that either. After I explained them they wrote me how sorry they are for the inconvenience caused by not having thought that over at the move.

We only lost a few posts and got everything running smoothly again. So no reason for complaining too much about the boys at the webhost. They're trying to do their best.

As to the other websites I lost, mai pen rai, that gives me opportunity to redo a few things I wasn't too happy with anyway. Life goes on! :)