At the moment, the OpenID connect extension seems to be incompatible with PostgreSQL because the database schema updates use MySQL syntax:
server ~/mediawiki-extensions-OpenIDConnect # cat AddIssuer.sql AddSubject.sql ALTER TABLE /*_*/user ADD issuer TINYBLOB; ALTER TABLE /*_*/user ADD subject TINYBLOB;
These columns therefor aren't added to the table in PostgreSQL. For some strange reason, I can't find any error messages about this... I had expected update.php to try to apply this ALTER TABLE anyway and fail, but it doesn't print any error message and I also don't see anything in the debug log while running MediaWiki. I also can't find any mention of a syntax error in my postgresql-9.6-main.log, but I do get an error in that log when I run the SQL commands manually in psql:
server ~ # tail -n2 /var/log/postgresql/postgresql-9.6-main.log 2018-01-20 19:33:03 GMT ERROR: syntax error at or near "user" at character 18 2018-01-20 19:33:03 GMT STATEMENT: ALTER TABLE user ADD issuer TINYBLOB;
I was able to work around the issue by manually adding the needed columns:
mediawiki=# ALTER TABLE mediawiki.mwuser ADD issuer TEXT; ALTER TABLE mediawiki=# ALTER TABLE mediawiki.mwuser ADD subject TEXT; ALTER TABLE
Note that you need to specify the schema ($wgDBmwschema, defaults to mediawiki) and that the table is called mwuser instead of user:
www-data@4292bfd9f33b:~/html/maintenance/postgres$ grep -m1 mwuser tables.sql CREATE TABLE mwuser ( -- replace reserved word 'user'