Once the database became accessable today, I started entering log data for 27 Jan 2018. It appears that all the entries I made from 22 Jan thru 26 Jan, which were successfully entered previously, have now disappeared based on the my total chaser point and unique summit totals which reverted back to 21 Jan status.
I’d expect anything entered after 0600z - Jan 24th onwards and before 0812Z Jan 28th to be missing. I don’t know what stuff I have in backups I have here that can be extracted yet. I’ve take the outage as a chance to update/reinstall/reconfigure loads of things.
What does perplex me Rich is that you have missing data from a day or two before the problems. I have good, hard, kosher backups of everything for each day in January taken between 400Z & 420Z every morning. I still have a few more things to do but if you PM or email me in a day or so I can see what extra I may have to recover.
Same thing here Rich. Yesterday it was fine, showing 49,920 chaser points. Today I lost the January 24,25,26, and 27th. Lost 153 points. Should I try putting them back in or wait for some correction? de Scotty KG3W
Hmm, very strange - I tried a cache refresh Ctrl+F5 and shift+reload and no page arrived.
If you are seeing it, it could be a DNS issue I guess, but as you know, I could see the page on the new server earlier today!
73 Ed.
Very Odd - probably my ISP - I can Ping the URL fine:
C:\Windows\system32>ping sotadata.org.uk
Pinging sotadata.org.uk [185.43.79.38] with 32 bytes of data:
Reply from 185.43.79.38: bytes=32 time=48ms TTL=118
Reply from 185.43.79.38: bytes=32 time=49ms TTL=118
Reply from 185.43.79.38: bytes=32 time=48ms TTL=118
Reply from 185.43.79.38: bytes=32 time=50ms TTL=118
Ping statistics for 185.43.79.38:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 48ms, Maximum = 50ms, Average = 48ms
C:\Windows\system32>
Just not get access to the webpage through my browser:
even using the IP address no go:
OK, presume it’s a Deutsche Telekom DNS issue for now… In any case I wont be entering any log entries until you give the go ahead.
The DB that is running is good and running on new hardware, new DB engine a new OS. Once the dust has settled, I can mount a local copy of the DB and see what logs exist in it after the troubles started and extract them. But it’s only been up for 14hrs and there’s still a few niggles to resolve. Mail or PM in a day or so when I’ve had a chance to look.
Same thing here: Error 404
But i did read Andy’s advice and all my Sota qso’s including all the details are logged in my general log so it’s a good thing to have a personal backup. They will be transfered to Sotadata when the word is given out that everything is OK.
I can access the net through several providers. Here’s how long it took for the DNS update to propagate
US access in LA, 1hr30
ISP in Scotland, 4hr30
UK Mobile ISP, 5hr
VPN provider in Austria 15hrs.
It’s possible that the update has yet to arrive at your ISP.
On top of this, some browsers and Windows, tend to have very sticky caches. I have a Linux PC and Win7 PC here on the desk. I could see the DNS change via my Linux PC, but despite telling my Win7 machine to flush and get new data, it knew better. I can’t remember how many times I had to issue the command before it did something. Then it took several attempts to make Firefox use the new data. I’d like to think I know how to do these things and it was painful for me. I sympathise if you just use a PC as a tool and don’t ever delve into the guts.
Restarting my DSL Router helped to aquired the DNS update.
Thanks for the repair and system improvements done to the db server.
@MM0FMF: Summits on the Air gives an error. Looks like the db connections needs to be reconfigured? Or the webserver for this domain has also DNS update problems?