Author Topic: Latest Issue with website  (Read 7737 times)

0 Members and 1 Guest are viewing this topic.

AD

  • Administrator
  • Hero Member
  • *****
  • Posts: 1991
  • Karma: 223
  • Gender: Male
  • Extra Class Ham Radio Op / VE, CERT
Latest Issue with website
« on: October 25, 2018, 06:50:47 PM »
well I am sure most of you have noticed we have been off of the air for about 3 weeks.

I had a database connection error that popped up on the hosting site(Go Daddy)

Dont know how it happened but it crashed us hard.

Thanks or Mhar from GD tech support share hosting, he went about and beyond and got it running again.
The only dumb question is the one that did not get asked!!

DragoSapien

  • Global Moderator
  • Full Member
  • *****
  • Posts: 315
  • Karma: 28
  • Gender: Male
Re: Latest Issue with website
« Reply #1 on: October 25, 2018, 08:10:23 PM »
Wondered what had happen.

spacecase0

  • Hero Member
  • *****
  • Posts: 790
  • Karma: 34
    • my spiritual forum
Re: Latest Issue with website
« Reply #2 on: October 26, 2018, 11:02:19 PM »
I have run a few websites in the past
my issues were running a top 100 website that was politically polarized
one of the few things that I have never have found on the web is how to run a website with that much traffic
talked to the sysadmin of dig.com one day about the topic...
I agreed with him on what we had learned
turns out that you can learn a huge amount in a 30 second elevator ride
and also, thank you dig.com for the computer monitor I am using at the moment.
ok, fine, it was not learning, it was verification
so my comment here is that if you don't have physical control of your server, you are trusting someone else to do a good job.
and it is kind of sad how often they seem to mess up.

I hope you keep a backup of this site
I have seen others loose hundreds of websites all at once...
I feel sorry for them, what a way to loose your job.

BTPost

  • Old Fart Ham
  • Prepper
  • Full Member
  • *
  • Posts: 361
  • Karma: 29
  • Gender: Male
    • Bruce's Trading Post
Re: Latest Issue with website
« Reply #3 on: October 27, 2018, 01:54:24 AM »
Welcome back to the world of TCPIP.... Happy for your reserection....
Bruce in alaska AL7AQ

Tevin

  • Prepper
  • Full Member
  • *
  • Posts: 455
  • Karma: 29
  • Rhymes with heaven.
Re: Latest Issue with website
« Reply #4 on: October 27, 2018, 06:22:49 AM »
I absolutely did notice the outage and I'm glad you are back. I wanted to contact you through Survival Monkey to see what's going on but you're not over there much and I didn't think you'd get the message.

I also had my blog go down last weekend. It was out for three days and might have been restored sooner but I was out of town and did not have any of my log in and account information. Once I contacted Go Daddy they were able to fix in in a few minutes with a few tweaks. They had to "kill PHP process". I don't know what that is, but once it was dead everything came back.



XJP5

  • Global Moderator
  • Full Member
  • *****
  • Posts: 179
  • Karma: 11
  • Gender: Male
  • Extra Class Operator
Re: Latest Issue with website
« Reply #5 on: October 27, 2018, 12:22:01 PM »
well I am sure most of you have noticed we have been off of the air for about 3 weeks.

I had a database connection error that popped up on the hosting site(Go Daddy)

Dont know how it happened but it crashed us hard...

AD, database maintenance is a specialty. It really is. Everywhere I worked in the technology field over the past 17 years, we've had dedicated DBAs to maintain these relational databases. I know very little about them, with the exception of how vulnerabilities occur from the Cybersecurity perspective. Doesn't GoDaddy offer any services or assistance in a situation like this? I probably know the answer already, and that's why I would gouge their eyeballs out for my services, if they ever requested them.

AD

  • Administrator
  • Hero Member
  • *****
  • Posts: 1991
  • Karma: 223
  • Gender: Male
  • Extra Class Ham Radio Op / VE, CERT
Re: Latest Issue with website
« Reply #6 on: October 30, 2018, 09:02:28 AM »
Guys what I dont understand is that with little traffic causing the database to be added to amd NO ONE messing with the back end on the server side, how does the database get corrupted?

For years PH ran without issues until I upgraded the server to host multiple website.

Now I have the blog posts on www.preparedham.com not connecting to the articles.

I am not smart enough on the server side to correct this issue.
The only dumb question is the one that did not get asked!!

spacecase0

  • Hero Member
  • *****
  • Posts: 790
  • Karma: 34
    • my spiritual forum
Re: Latest Issue with website
« Reply #7 on: November 01, 2018, 12:52:04 AM »
running separate databases for each site ?

ever run the command ?
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

AD

  • Administrator
  • Hero Member
  • *****
  • Posts: 1991
  • Karma: 223
  • Gender: Male
  • Extra Class Ham Radio Op / VE, CERT
Re: Latest Issue with website
« Reply #8 on: November 05, 2018, 10:00:59 PM »
Nope.  I dont know anything about it.
The only dumb question is the one that did not get asked!!

spacecase0

  • Hero Member
  • *****
  • Posts: 790
  • Karma: 34
    • my spiritual forum
Re: Latest Issue with website
« Reply #9 on: November 05, 2018, 10:58:41 PM »
Nope.  I dont know anything about it.
if you can run that command, then do it when the site database is messed up
if you can't run it, then whoever runs your site is not maintaining things well enough

XJP5

  • Global Moderator
  • Full Member
  • *****
  • Posts: 179
  • Karma: 11
  • Gender: Male
  • Extra Class Operator
Re: Latest Issue with website
« Reply #10 on: November 25, 2018, 06:16:12 PM »
Nope.  I dont know anything about it.

AD, this site may have some helpful information:  http://www.mysqltutorial.org/mysql-database-table-maintenance-statements.aspx

XJP5

Tevin

  • Prepper
  • Full Member
  • *
  • Posts: 455
  • Karma: 29
  • Rhymes with heaven.
Re: Latest Issue with website
« Reply #11 on: November 27, 2018, 07:27:38 AM »
I once considered adding a message board/forum component to my own blog. I decided against it because it's a lot harder than it looks and there are already a bajillion forums out there anyway. I'm not sure I can add anything new.

I am grateful to those who run forums as I do enjoy participating.

AD

  • Administrator
  • Hero Member
  • *****
  • Posts: 1991
  • Karma: 223
  • Gender: Male
  • Extra Class Ham Radio Op / VE, CERT
Re: Latest Issue with website
« Reply #12 on: November 28, 2018, 10:47:23 AM »
idial1911 who set up the sight, went in and corrected some things so the blog is now working again.
The only dumb question is the one that did not get asked!!

ghrit

  • Prepper
  • Full Member
  • *
  • Posts: 279
  • Karma: 22
Re: Latest Issue with website
« Reply #13 on: November 30, 2018, 05:57:01 PM »
just checking to see if the lights still work.  They do ---
There are two kinds of ships.  Submarines and targets.
KB3ZMF        FN21dy
Amateur Extra Class,  VE
www.survivalmonkey.com