Jump to content
  • 0

rescue mediawiki db from TImeshift backup


Question

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.

Screenshot from 2020-03-02 12-52-56.png

Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   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.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.