Recent Posts

Pages: 1 2 [3] 4 5 ... 7
21
General Discussion / Re: Diner Down 6/30/13
« Last post by Reverse Engineer 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
22
General Discussion / Re: Diner Down 6/30/13
« Last post by agelbert 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!
23
General Discussion / Re: Diner Down 6/30/13
« Last post by Surly1 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...
24
General Discussion / Re: Diner Down 6/30/13
« Last post by Reverse Engineer on July 02, 2013, 05:38:46 pm »
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
25
General Discussion / Re: Diner Down 6/30/13
« Last post by haniel on July 02, 2013, 03:49:39 pm »
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.




26
General Discussion / Re: Diner Down 6/30/13
« Last post by Reverse Engineer on July 02, 2013, 02:41:49 pm »
Quote
4914 Total hits from a cox communications subscriber, probably in a hole he dug in Virginia

That's a bunker, BTW... ;D

Langley.  CIA or NSA for sure.

RE
27
General Discussion / Re: Diner Down 6/30/13
« Last post by Reverse Engineer on July 02, 2013, 02:40:01 pm »
There are only 5 people with Admin priviledges on WP, me, Peter, Surly, WHD & Monsta.  I closed all my open window before I left the cabin, but since my connection is through my cell phone, once I leave that computer is not connected to the net anymore.

The multimedia is not hosted on our server at all, we just link to it.  All the Podcasts are on Soundcloud, all the videos are on You Tube.  This should not affect our bandwidth usage at all, other than the fact these things draw more visitors and page hits.

I haven't checked yet but nothing yesterday from the Paid Support help, just from the regular support team.  Haniel has also dropped in on the ticket, pointing out that our DB doesn't show anything like 75,000 queries/hour.

Far as being on the same server as Peter, possible but not likely.  I bought my account long after Peter bought his, I just handed him the password so he could do the setup.  Besides that, after the last outage, I had to upgrade to a server with fewer websites on it, I don't think Peter has had to do that with the Ocean Falls sites.  I don't have any other sites active.

RE
28
General Discussion / Re: Diner Down 6/30/13
« Last post by haniel on July 02, 2013, 01:45:46 pm »
No, the bandwidth should be manageable, we have to figure out the excessive connections issue. 

The site -> forum should only take up on connection.  Problem is, none are available when the site tries. 

I'll talk with my hosting experts.


29
General Discussion / Re: Diner Down 6/30/13
« Last post by agelbert on July 02, 2013, 01:41:35 pm »
Haniel,
Does that mean we will have to post less video so the bandwidth remains manageable?

I'll stop posting videos if that helps stabilize the site.
30
General Discussion / Re: Diner Down 6/30/13
« Last post by agelbert on July 02, 2013, 01:37:41 pm »
Monsta told me once he was able to log into the admin accidentally. I have never been able to do so.

Haniel,
You might send Monsta an e-mail. Maybe the fact that he is in England is multiplying the hit count somehow.
Pages: 1 2 [3] 4 5 ... 7