Jump to content

Mistakes were Made


JRWR
 Share

Recommended Posts

Last night Andy and Another PHP Dev were trying to get Invision Powerboard to authenticate to the MediaWiki User Database, They called me when the PHP Dev where having issues with the way that PCGamingWiki is setup

We discovered that the bridge they were trying to use, was the wrong type, it was to use PowerBoard’s user database for auth and not mediawiki, So we uninstalled and left it like that.

 

We got a report the next morning that all auth groups had been wiped from the database, I still do not really know how this happened, but I suspect the Auth Bridge was to blame, All page permissions where gone as well, and I saw no way of fixing it, but a database rollback

 

That’s where things went south, I got a backup off our Backup Server from the 25th, and exported the current wiki as XML, but I found out that the database backup copy was bad, really bad, like eat your goat and piss on your oatmeal bad, it crashed mysql HARD, After some “science†(Hex Editor, and some luck) and was able to get Mysql to mount the InnoDB store

It segfaulted (crashed) midway into the raw SQL dump, Fuck

After some more “Science†and some really good luck, I got a Full Database dump. And deleted all the old data, or so I thougth…. That was a incomplete dump, I forgot to push the binlogs to current….

So after some more “science†and some 4 hours later, we now have a working database that is 2 days old and with the current content of PCGamingWiki, Sorry TruePCGamer, Hope you had some old backups for the last two days

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Found PCGamingWiki useful? Please consider making a Donation or visiting our Patreon.
  • Who's Online   2 Members, 0 Anonymous, 247 Guests (See full list)

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Forum Statistics

    1.6k
    Total Topics
    8.6k
    Total Posts
×
×
  • Create New...