When trying to install Wikibase using the docker image, the installation fails when doing the initial installation of Mediawiki. The installation was run using the github commit [[ https://github.com/wmde/wikibase-docker/commit/d2ac34d2a4bcd8c60d0faee74d40b240af061c48 | d2ac34d ]].
The installation was done on Debian 9 with 8 GB of RAM.
Below is the installation log of the docker instance:
> root@server:~# docker logs wikibasedocker_wikibase_1
> wait-for-it.sh: waiting 60 seconds for mysql.svc:3306
> wait-for-it.sh: mysql.svc:3306 is available after 1 seconds
> wait-for-it.sh: waiting 60 seconds for mysql.svc:3306
> wait-for-it.sh: mysql.svc:3306 is available after 0 seconds
> PHP 7.1.11 is installed.
> Found ImageMagick: /usr/bin/convert.
> Image thumbnailing will be enabled if you enable uploads.
> Found the Git version control software: /usr/bin/git.
> Warning: No --scriptpath specified, using default: /wiki.
> Using server URL "/wiki".
> /usr/bin/locale: Cannot set LC_CTYPE to default locale: No such file or directory
> Warning: Your default directory for uploads (/var/www/html/images/) is not checked for vulnerability
> to arbitrary script execution during the CLI install.
> Using the intl PECL extension for Unicode normalization.
> The environment has been checked.
> You can install MediaWiki.
> Setting up database
> done
> Creating tables
> Warning: MediaWiki tables seem to already exist.
> Skipping creation.
> done
> Creating database user
> done
> Populating default interwiki table
> [d6e590f4cc749c703abf6ddc] [no req] Wikimedia\Rdbms\DBQueryError from line 1075 of /var/www/html/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
> Query: INSERT INTO `interwiki` (iw_prefix,iw_url,iw_local,iw_api,iw_wikiid) VALUES ('acronym','http://www.acronymfinder.com/~/search/af.aspx?string=exact&Acronym=$1','0','',''),('advogato','http://www.advogato.org/$1','0','',''),('arxiv','http://www.arxiv.org/abs/$1','0','',''),('c2find','http://c2.com/cgi/wiki?FindPage&value=$1','0','',''),('cache','http://www.google.com/search?q=cache:$1','0','',''),('commons','https://commons.wikimedia.org/wiki/$1','0','https://commons.wikimedia.org/w/api.php',''),('dictionary','http://www.dict.org/bin/Dict?Database=*&Form=Dict1&Strategy=*&Query=$1','0','',''),('doi','http://dx.doi.org/$1','0','',''),('drumcorpswiki','http://www.drumcorpswiki.com/$1','0','http://drumcorpswiki.com/api.php',''),('dwjwiki','http://www.suberic.net/cgi-bin/dwj/wiki.cgi?$1','0','',''),('elibre','http://enciclopedia.us.es/index.php/$1','0','http://enciclopedia.us.es/api.php',''),('emacswiki','http://www.emacswiki.org/cgi-bin/wiki.pl?$1','0','',''),('foldoc','http://foldoc.org/?$1','0','',''),('foxwiki','http://fox.wikis.com/wc.dll?Wiki~$1','0','',''),('freebsdman','http://www.FreeBSD.org/cgi/man.cgi?apropos=1&query=$1','0','',''),('gentoo-wiki','http://gentoo-wiki.com/$1','0','',''),('google','http://www.google.com/search?q=$1','0','',''),('googlegroups','http://groups.google.com/groups?q=$1','0','',''),('hammondwiki','http://www.dairiki.org/HammondWiki/$1','0','',''),('hrwiki','http://www.hrwiki.org/wiki/$1','0','http://www.hrwiki.org/w/api.php',''),('imdb','http://www.imdb.com/find?q=$1&tt=on','0','',''),('kmwiki','http://kmwiki.wikispaces.com/$1','0','',''),('linuxwiki','http://linuxwiki.de/$1','0','',''),('lojban','http://mw.lojban.org/papri/$1','0','',''),('lqwiki','http://wiki.linuxquestions.org/wiki/$1','0','',''),('meatball','http://www.usemod.com/cgi-bin/mb.pl?$1','0','',''),('mediawikiwiki','https://www.mediawiki.org/wiki/$1','0','https://www.mediawiki.org/w/api.php',''),('memoryalpha','http://en.memory-alpha.org/wiki/$1','0','http://en.memory-alpha.org/api.php',''),('metawiki','http://sunir.org/apps/meta.pl?$1','0','',''),('metawikimedia','https://meta.wikimedia.org/wiki/$1','0','https://meta.wikimedia.org/w/api.php',''),('mozillawiki','http://wiki.mozilla.org/$1','0','https://wiki.mozilla.org/api.php',''),('mw','https://www.mediawiki.org/wiki/$1','0','https://www.mediawiki.org/w/api.php',''),('oeis','http://oeis.org/$1','0','',''),('openwiki','http://openwiki.com/ow.asp?$1','0','',''),('pmid','https://www.ncbi.nlm.nih.gov/pubmed/$1?dopt=Abstract','0','',''),('pythoninfo','http://wiki.python.org/moin/$1','0','',''),('rfc','https://tools.ietf.org/html/rfc$1','0','',''),('s23wiki','http://s23.org/wiki/$1','0','http://s23.org/w/api.php',''),('seattlewireless','http://seattlewireless.net/$1','0','',''),('senseislibrary','http://senseis.xmp.net/?$1','0','',''),('shoutwiki','http://www.shoutwiki.com/wiki/$1','0','http://www.shoutwiki.com/w/api.php',''),('squeak','http://wiki.squeak.org/squeak/$1','0','',''),('tmbw','http://www.tmbw.net/wiki/$1','0','http://tmbw.net/wiki/api.php',''),('tmnet','http://www.technomanifestos.net/?$1','0','',''),('theopedia','http://www.theopedia.com/$1','0','',''),('twiki','http://twiki.org/cgi-bin/view/$1','0','',''),('uncyclopedia','http://en.uncyclopedia.co/wiki/$1','0','http://en.uncyclopedia.co/w/api.php',''),('unreal','http://wiki.beyondunreal.com/$1','0','http://wiki.beyondunreal.com/w/api.php',''),('usemod','http://www.usemod.com/cgi-bin/wiki.pl?$1','0','',''),('wiki','http://c2.com/cgi/wiki?$1','0','',''),('wikia','http://www.wikia.com/wiki/$1','0','',''),('wikibooks','https://en.wikibooks.org/wiki/$1','0','https://en.wikibooks.org/w/api.php',''),('wikidata','https://www.wikidata.org/wiki/$1','0','https://www.wikidata.org/w/api.php',''),('wikif1','http://www.wikif1.org/$1','0','',''),('wikihow','http://www.wikihow.com/$1','0','http://www.wikihow.com/api.php',''),('wikinfo','http://wikinfo.co/English/index.php/$1','0','',''),('wikimedia','https://wikimediafoundation.org/wiki/$1','0','https://wikimediafoundation.org/w/api.php',''),('wikinews','https://en.wikinews.org/wiki/$1','0','https://en.wikinews.org/w/api.php',''),('wikipedia','https://en.wikipedia.org/wiki/$1','0','https://en.wikipedia.org/w/api.php',''),('wikiquote','https://en.wikiquote.org/wiki/$1','0','https://en.wikiquote.org/w/api.php',''),('wikisource','https://wikisource.org/wiki/$1','0','https://wikisource.org/w/api.php',''),('wikispecies','https://species.wikimedia.org/wiki/$1','0','https://species.wikimedia.org/w/api.php',''),('wikiversity','https://en.wikiversity.org/wiki/$1','0','https://en.wikiversity.org/w/api.php',''),('wikivoyage','https://en.wikivoyage.org/wiki/$1','0','https://en.wikivoyage.org/w/api.php',''),('wikt','https://en.wiktionary.org/wiki/$1','0','https://en.wiktionary.org/w/api.php',''),('wiktionary','https://en.wiktionary.org/wiki/$1','0','https://en.wiktionary.org/w/api.php','')
> Function: DatabaseInstaller::populateInterwikiTable
> Error: 1054 Unknown column 'iw_api' in 'field list' (mysql.svc:3306)
>
> Backtrace:
> #0 /var/www/html/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
> #1 /var/www/html/includes/libs/rdbms/database/Database.php(1515): Wikimedia\Rdbms\Database->query(string, string)
> #2 /var/www/html/includes/installer/DatabaseInstaller.php(725): Wikimedia\Rdbms\Database->insert(string, array, string)
> #3 /var/www/html/includes/installer/Installer.php(1519): DatabaseInstaller->populateInterwikiTable(MysqlInstaller)
> #4 /var/www/html/includes/installer/CliInstaller.php(135): Installer->performInstallation(array, array)
> #5 /var/www/html/maintenance/install.php(142): CliInstaller->execute()
> #6 /var/www/html/maintenance/doMaintenance.php(111): CommandLineInstaller->execute()
> #7 /var/www/html/maintenance/install.php(156): require_once(string)
> #8 {main}
> MediaWiki 1.29.1 Updater
>
> Your composer.lock file is up to date with current dependencies!
> Going to run database updates for my_wiki
> Depending on the size of your database this may take a while!
> Set $wgShowExceptionDetails = true; and $wgShowDBErrorBacktrace = true; at the bottom of LocalSettings.php to show detailed debugging information
> AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.4. Set the 'ServerName' directive globally to suppress this message
> AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.4. Set the 'ServerName' directive globally to suppress this message
> [Thu Nov 09 12:53:43.190391 2017] [mpm_prefork:notice] [pid 58] AH00163: Apache/2.4.10 (Debian) PHP/7.1.11 configured -- resuming normal operations
> [Thu Nov 09 12:53:43.190483 2017] [core:notice] [pid 58] AH00094: Command line: 'apache2 -D FOREGROUND'
As an alternative we tried the installation using the git tag [[https://github.com/wmde/wikibase-docker/tree/birthday5|birthday5]] but there we got an different error during the docker-compose pull
> root@server:~/wikibase-docker# docker-compose pull
> Pulling wdqs (wikibase/wdqs:latest)...
> latest: Pulling from wikibase/wdqs
> b56ae66c2937: Pull complete
> 81cebc5bcaf8: Pull complete
> 9f7678525069: Pull complete
> a2dedba7814e: Pull complete
> 74bf7659683a: Pull complete
> c2cf51a59552: Pull complete
> 813f2383b347: Pull complete
> 7cefe7979b8b: Pull complete
> f8d794e5c73a: Pull complete
> 1c9d2a304966: Pull complete
> c65e12d11b59: Pull complete
> 86efe38ca3ad: Pull complete
> fd7b6cb6bf36: Pull complete
> Digest: sha256:d911d3befbad2d677b33a534afb980959ab04d97eba1692c3208d918f01ac68d
> Status: Downloaded newer image for wikibase/wdqs:latest
> Pulling mysql (mariadb:latest)...
> latest: Pulling from library/mariadb
> 85b1f47fba49: Pull complete
> 5671503d4f93: Pull complete
> 3b43b3b913cb: Pull complete
> 4fbb803665d0: Pull complete
> f70c53a1be24: Pull complete
> ab247c7432b9: Pull complete
> 5437523d0396: Pull complete
> 02185372c549: Pull complete
> ee8416aab538: Pull complete
> 10247ed22fa3: Pull complete
> 0e0e5b5aa0b7: Pull complete
> Digest: sha256:c25fb0ada1733c736e13994d210e77b93562fdf61abdd8cb9d32e9f1489a9fbb
> Status: Downloaded newer image for mariadb:latest
> Pulling wikibase (wikibase/wikibase:latest)...
> latest: Pulling from wikibase/wikibase
> 85b1f47fba49: Already exists
> d8204bc92725: Pull complete
> 92fc16bb18e4: Pull complete
> 31098e61b2ae: Pull complete
> f6ae64bfd33d: Pull complete
> 003c1818b354: Pull complete
> a6fd4aeb32ad: Pull complete
> a094df7cedc1: Pull complete
> af0f77e732e0: Pull complete
> 1513b36e0001: Pull complete
> f0e4a4e2be44: Pull complete
> b050de8f5d3e: Pull complete
> f595ab2f751a: Pull complete
> 2dce73e1bc87: Pull complete
> df938cc423fe: Pull complete
> c42dc8ba828a: Pull complete
> 693b6f6e87c1: Pull complete
> 6f7dfc36e2e8: Pull complete
> c53c75aa3d9b: Pull complete
> ee10e7de10f1: Pull complete
> c68487f31516: Pull complete
> 32342374145d: Pull complete
> 5f2d3a5297d5: Pull complete
> bab0fcafefad: Pull complete
> 8f86513b8e9f: Pull complete
> be18bfe36de2: Pull complete
> 9c08a1065f7b: Pull complete
> 2a732b4d2243: Pull complete
> Digest: sha256:8703b87eb8bf4840b528d42de045f286a40bd55a3fc1af95d5ad0a1ecb870e0b
> Status: Downloaded newer image for wikibase/wikibase:latest
> Pulling wdqs-updater (wikibase/wdqs-updater:latest)...
> ERROR: manifest for wikibase/wdqs-updater:latest not found