rescue mediawiki db from TImeshift backup

[Fletcher]

A few days ago my laptop took a dump and some files became corrupted, disallowing me to do very much.  

I had previously backed up my linux mint 18.3 and my entire home and most of the system.

I was running MediaWiki 1.31.1, php5 (I am pretty sure).

After the crash I asked for advice on saving files to prevent loss of the two wikis I had running locally and unfortunately, didn't ask the right questions.

I rebuilt the machine, reconnected my /home directories and everything seemed fine.  Until I decided to do some work on the wiki and realized I was not only missing parts (including the mysql stuff, and php, but apache etc).

Since then I have done the following:

1) Found the original files saved before the crash by time shift in an "on demand directory" which I can browse, copy, etc

2) Copied them to my /var/www/html/ directory.

3) Reinstalled php (version 7.3 I believe), Apache, and had to switch to mariadb-server, as I could NOT get the other drivers working at all.  (I kept getting errors from media wiki when trying to install a new version)

4) reinstalled and got working mediawiki 1.34 with a new, clean, empty db.

 

My problem is how to get all the proper files back where they belong and get the old wiki databases working.  (There are two, both are different things I work on and are similar so if I can get one recovered then I can do the other one).

I have tried several things already, including copying the files all over from /var/lib/php (back to the active machine) and copying the original files over to /var/www/html/ under their original directories.

I get an error when I browse to /var/www/html/wiki (one of my original wikis) of:

 

[5419c05ae3eff79d17914645] 2020-03-02 16:39:58: Fatal exception of type Wikimedia\Rdbms\DBQueryError

 

on the other one, I get simply the entry point pho file:

 

<?php
/**
 * This is the main web entry point for MediaWiki.
 *
 * If you are reading this in your web browser, your server is probably
 * not configured correctly to run PHP applications!
 *
 * See the README, INSTALL, and UPGRADE files for basic setup instructions
 * and pointers to the online documentation.
 *
 * https://www.mediawiki.org/wiki/Special:MyLanguage/MediaWiki
 *
 * ----------
 

etc....

A search on the first error says to run php update.php

 

THAT is a mess.  it appears I'm missing extensions... I get a hundred lines of errors, and am not sure where to start on that or why it's doing it.

 

I'll copy that information here:

root@estrellita:/var/www/html/wiki# php update.php
PHP Warning:  Failed loading Zend extension 'opcache.so' (tried: ./opcache.so (./opcache.so: cannot open shared object file: No such file or directory), ./opcache.so.so (./opcache.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'bz2' (tried: ./bz2 (./bz2: cannot open shared object file: No such file or directory), ./bz2.so (./bz2.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'curl' (tried: ./curl (./curl: cannot open shared object file: No such file or directory), ./curl.so (./curl.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'mysqli' (tried: ./mysqli (./mysqli: cannot open shared object file: No such file or directory), ./mysqli.so (./mysqli.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_mysql' (tried: ./pdo_mysql (./pdo_mysql: cannot open shared object file: No such file or directory), ./pdo_mysql.so (./pdo_mysql.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'mysqlnd.so' (tried: ./mysqlnd.so (./mysqlnd.so: cannot open shared object file: No such file or directory), ./mysqlnd.so.so (./mysqlnd.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo.so' (tried: ./pdo.so (./pdo.so: cannot open shared object file: No such file or directory), ./pdo.so.so (./pdo.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'xml.so' (tried: ./xml.so (./xml.so: cannot open shared object file: No such file or directory), ./xml.so.so (./xml.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'bcmath.so' (tried: ./bcmath.so (./bcmath.so: cannot open shared object file: No such file or directory), ./bcmath.so.so (./bcmath.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'calendar.so' (tried: ./calendar.so (./calendar.so: cannot open shared object file: No such file or directory), ./calendar.so.so (./calendar.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'ctype.so' (tried: ./ctype.so (./ctype.so: cannot open shared object file: No such file or directory), ./ctype.so.so (./ctype.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'curl.so' (tried: ./curl.so (./curl.so: cannot open shared object file: No such file or directory), ./curl.so.so (./curl.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'dom.so' (tried: ./dom.so (./dom.so: cannot open shared object file: No such file or directory), ./dom.so.so (./dom.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'exif.so' (tried: ./exif.so (./exif.so: cannot open shared object file: No such file or directory), ./exif.so.so (./exif.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'fileinfo.so' (tried: ./fileinfo.so (./fileinfo.so: cannot open shared object file: No such file or directory), ./fileinfo.so.so (./fileinfo.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'ftp.so' (tried: ./ftp.so (./ftp.so: cannot open shared object file: No such file or directory), ./ftp.so.so (./ftp.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'gd.so' (tried: ./gd.so (./gd.so: cannot open shared object file: No such file or directory), ./gd.so.so (./gd.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'gettext.so' (tried: ./gettext.so (./gettext.so: cannot open shared object file: No such file or directory), ./gettext.so.so (./gettext.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'iconv.so' (tried: ./iconv.so (./iconv.so: cannot open shared object file: No such file or directory), ./iconv.so.so (./iconv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'json.so' (tried: ./json.so (./json.so: cannot open shared object file: No such file or directory), ./json.so.so (./json.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'mbstring.so' (tried: ./mbstring.so (./mbstring.so: cannot open shared object file: No such file or directory), ./mbstring.so.so (./mbstring.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'mysqli.so' (tried: ./mysqli.so (./mysqli.so: cannot open shared object file: No such file or directory), ./mysqli.so.so (./mysqli.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_mysql.so' (tried: ./pdo_mysql.so (./pdo_mysql.so: cannot open shared object file: No such file or directory), ./pdo_mysql.so.so (./pdo_mysql.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'phar.so' (tried: ./phar.so (./phar.so: cannot open shared object file: No such file or directory), ./phar.so.so (./phar.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'posix.so' (tried: ./posix.so (./posix.so: cannot open shared object file: No such file or directory), ./posix.so.so (./posix.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'readline.so' (tried: ./readline.so (./readline.so: cannot open shared object file: No such file or directory), ./readline.so.so (./readline.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'shmop.so' (tried: ./shmop.so (./shmop.so: cannot open shared object file: No such file or directory), ./shmop.so.so (./shmop.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'simplexml.so' (tried: ./simplexml.so (./simplexml.so: cannot open shared object file: No such file or directory), ./simplexml.so.so (./simplexml.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'sockets.so' (tried: ./sockets.so (./sockets.so: cannot open shared object file: No such file or directory), ./sockets.so.so (./sockets.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'sysvmsg.so' (tried: ./sysvmsg.so (./sysvmsg.so: cannot open shared object file: No such file or directory), ./sysvmsg.so.so (./sysvmsg.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'sysvsem.so' (tried: ./sysvsem.so (./sysvsem.so: cannot open shared object file: No such file or directory), ./sysvsem.so.so (./sysvsem.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'sysvshm.so' (tried: ./sysvshm.so (./sysvshm.so: cannot open shared object file: No such file or directory), ./sysvshm.so.so (./sysvshm.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'tokenizer.so' (tried: ./tokenizer.so (./tokenizer.so: cannot open shared object file: No such file or directory), ./tokenizer.so.so (./tokenizer.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'wddx.so' (tried: ./wddx.so (./wddx.so: cannot open shared object file: No such file or directory), ./wddx.so.so (./wddx.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'xmlreader.so' (tried: ./xmlreader.so (./xmlreader.so: cannot open shared object file: No such file or directory), ./xmlreader.so.so (./xmlreader.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'xmlwriter.so' (tried: ./xmlwriter.so (./xmlwriter.so: cannot open shared object file: No such file or directory), ./xmlwriter.so.so (./xmlwriter.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'xsl.so' (tried: ./xsl.so (./xsl.so: cannot open shared object file: No such file or directory), ./xsl.so.so (./xsl.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'zip.so' (tried: ./zip.so (./zip.so: cannot open shared object file: No such file or directory), ./zip.so.so (./zip.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
Could not open input file: update.php
 

I am currently attempting to update and upgrade the software but when I test to versions it says I have the most recent already. (on most things).

I did do an update.  No changes in the above.  I ran a php script to look at my system and this shows the zend info for opcache:

I'm at a complete loss as to where to go next or fix the errors above.