Author Topic: Diner Down 6/30/13  (Read 1235 times)

Surly1

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: Diner Down 6/30/13
« Reply #30 on: July 02, 2013, 08:03:16 pm »
The fact that repair_settings.php brings back details of smiley and avatar locations means that the "settings_repair.php" page is able to connect to the DB - it tells you when it cannot and does not give details of file locations - the pointers are stored internally in the DB and I can see those pointers. 

So the hosting service are suspending a new user connection with only one connection against that user.  Either they are counting all user against all databases towards a maximum of "10" or there is somethign untoward going on with the hosting service.

What could that be?
It is recommended that our mutual client optimize his database or upgrade from shared to a VPS if he has outgrown shared hosting.

The databases were optimized as soon as I got in and backed them up.  So this appears to be a push for more money.

I've also tried to connect to a copy on an external server, but they appear to have port 3306 blocked.


Also for everyone else...GOOD NEWZ! Haniel has booted the DB on his server in a Temp location and it WORKS!

The Diner will be BACK.

RE
Traffic increased from 25GB to 75GB in two months.  Impressive but it may have the hosting service rubbing their hands together in glee.

I don't see any problems beyond a highly restrictive number of connections to the database, imposed by the hosting service.

They recommended:

The 75,000 query limit is per database log in. A quick way to see if a database log in is suspended is to try to access phpMyadmin. If you get prompted for a password, create another user and try to log in to the same database. If it works, then the user is probably suspended.

So I create another user (more than once) and change the forum -> DB connection string to use the "new user" - and even that one cannot connect to the database.

The fact that repair_settings.php brings back details of smiley and avatar locations means that the "settings_repair.php" page is able to connect to the DB - it tells you when it cannot and does not give details of file locations - the pointers are stored internally in the DB and I can see those pointers. 

So the hosting service are suspending a new user connection with only one connection against that user.  Either they are counting all user against all databases towards a maximum of "10" or there is somethign untoward going on with the hosting service.

What could that be?
It is recommended that our mutual client optimize his database or upgrade from shared to a VPS if he has outgrown shared hosting.

The databases were optimized as soon as I got in and backed them up.  So this appears to be a push for more money.

I've also tried to connect to a copy on an external server, but they appear to have port 3306 blocked.

one of the two AC's have failed in our server room and the temperature is climbing, so if there's no update for a few hours, we're scrambling to make sure our servers stay cool in the 109* heat.

Have you dropped any of this info on the Ticket?

Also for everyone else...GOOD NEWZ! Haniel has booted the DB on his server in a Temp location and it WORKS!

The Diner will be BACK.

RE

Excellent news.

Haniel is money.

I still don't understand the 75,000 query per DB log in, but then I don't have to.

Does this mean we can eliminate the wp/admin issue as a symptom/issue?

Also, I don't understand the 400+ hits from my NSA bunker in SE Virginia. Seems excessive, unless it's lifetime...

agelbert

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Diner Down 6/30/13
« Reply #31 on: July 02, 2013, 08:44:17 pm »
Surly said,
Quote
Also, I don't understand the 400+ hits from my NSA bunker in SE Virginia. Seems excessive, unless it's lifetime...

That is STRANGE. I thought of those sneak uses of computers to "borrow" processing power from people that don't know their computer is being used by the bitcoiners. Could it be that some admin's computer (possibly yours) has a virus to loop db access that generates a lot of hits?

I don't know. I'm just thinking out loud.

Another question: Who was logged on to the diner (admins and members) when it went down? Is there a dump of that?

I know I went to the forum and got the connection outage message, tried it a few times and wondered why the site was UP but the forum was DOWN. After all, the really hot articles are blogged on the blog, right? The forum gets pretty exciting at times but if you wanted to "send a message" that the boyz didn't approve of the content, the top priority target would be the blog, not the forum. ???

I think, as Haniel said, somebody is looking for more money. I don't think there was an attack, per se.

RE, the diner seems to be the victim of its own success. We are headed for the big time. LOL!

Reverse Engineer

  • Administrator
  • Newbie
  • *****
  • Posts: 28
    • View Profile
Re: Diner Down 6/30/13
« Reply #32 on: July 02, 2013, 10:40:56 pm »
Haniel has a Mirror of the Diner Forum now UP on his server.  Your original Login Information will work on that DB also.  You will be linked to it clicking the Forum Button on the Blog, or you can go there directly with this link:


RE