Unable to create MediaWiki on Azure Web App

I have been trying to create a MediaWiki on an Azure Web app. I don't think it can be done. I've exhausted all possibilities.

Using the MediaWiki installer the choices for databases are MySQL, MariaDB, PostgreSQL and SQLite.

I start with a Linux Web App using PHP 7.4. I unpack MediaWiki-1.35.1.tar.gz in wwwroot. I then connect to MediaWiki-1.35.1\mw-config\index.php.

There are 3 choices for database: MySQL/MariaDB, PostgreSQL and SQLite. All three fail with different issues.

The SQLite install fails with database locked. This is apparently because the web app is using an internet file system which cannot be byte locked by SQLite.

I create MySQL for Azure and MariaDB for Azure to test that possibility. These both fail because the Azure databases do not support MyISAM tables. The MediaWiki install uses InnoDB by default, but apparently some part of the install uses MyISAM.

Finally I created a PostgreSQL for Azure database. That installation failed with

Error 42501: ERROR: permission denied to set role "db_admin@myserver"  

Apparently the connection requires user@server syntax but the actual role is "user" and so set role to "user@server" fails.

Is there anyway to do what I am trying to do?

https://stackoverflow.com/questions/66502581/unable-to-create-mediawiki-on-azure-web-app March 06, 2021 at 01:03PM