exxos's Atari, Amiga & retro forum

Apologies for the downtime I really don't know what happened :(

All I did was create a new SQL user in phpmyadmin, then I got booted out. I tried to log back in nope.. Could not even login as root anymore..

After battling away, I managed to restore root access to the SQL server.. When I got in, the entire user list had totally vanished :shock: :shock:

So I'm having to create new accounts and change loads of passwords and such to get it all back up and running again. :roll:

Currently I am getting my emails functional again.. But I think the forum, web store and website is currently fine. No data was lost as far as I can tell during all this escapade.

Thanks for playing Ubuntu servers!

:cheers: :fire: :fire: :shite: :hide: :shite: :fire:

Glad it's back up again, great effort getting it working again.

Hats off to you.. I know all too well how they can be a nightmare!

Rob

What does your backup solution look like? ;)

troed wrote: 21 Dec 2023 21:05 What does your backup solution look like? ;)

I have full backups of the database every hour, but it does not really help when you cannot log into the thing to restore them :roll:

rmahlert wrote: 21 Dec 2023 21:03 Hats off to you.. I know all too well how they can be a nightmare!

Thanks, yes I think you suffered a much worse fate than me though...

Glad that you managed to recover. What a pain.

stephen_usher wrote: 21 Dec 2023 21:49 Glad that you managed to recover. What a pain.

Yep. It certainly poses a bit of a backup and restore conundrum which I had not previously envisioned :roll: Though I have wrote everything down step by step on how to recover the user database manually should I need to do it again!

Ultimately the worst-case would likely be we could lose the last few posts on the forum during a full disk restore and restoring the SQL and HTML backups afterwards. It is a pretty much a "solve all" solution. Though if I did that, it would have taken ages anyway. But I would not have known what had gone wrong unless I investigated it. I have no idea how the user list got trashed but at least I have solutions for that problem should it occur again now. Ironically I have been creating users exactly the same way and nothing has happened this time around. Baffling!

I’d like to take this opportunity to once again say “it wasn’t me.”

Thanks for all the hard work you do keeping this site going dude, it really is appreciated, and Merry Chrismas fella 8-)