Re: [MediaWiki-l] Trying to access array offset on value of type bool in Setup.php:563

2021-03-30 Thread Jeffrey Walton
On Tue, Mar 30, 2021 at 10:37 AM Jeffrey Walton wrote: > > Hi Everyone, > > This caught my eye when running one of my maintenance scripts. The > Setup.php:563 warning is new. > > The warning was not present on the old CentOS machine. The new machine > is Ubuntu 20, PHP 7.4, MySQL 8, Mediawiki

Re: [MediaWiki-l] Configuration

2021-03-30 Thread Benjamin Lees
Bonjour/hi, you can leave the database prefix blank, if I understand your question correctly. On Mon, Mar 29, 2021, 11:17 AM mailou wrote: > Bonjour, > Je ne comprends pas le système de configuration personnellement j'ai: > > Nom d'utilisateur, Nom de la base, Adresse du serveur, au lieu de: >

Re: [MediaWiki-l] MediaWiki cannot access database after upgrade

2021-03-30 Thread John
Also I would have upgraded in steps. I never recommend doing more than one LTS worth of jumps at a time. When you Start jumping too many versions weird things can start happening. On Tue, Mar 30, 2021 at 4:38 PM Jeffrey Walton wrote: > On Tue, Mar 30, 2021 at 4:30 PM Bart Everson wrote: > > >

Re: [MediaWiki-l] MediaWiki cannot access database after upgrade

2021-03-30 Thread Jeffrey Walton
On Tue, Mar 30, 2021 at 4:30 PM Bart Everson wrote: > > Happy to report that I fixed the problem described in my previous query. I > did it by making a fresh install in a new database, which generated a proper > LocalSettings.php file. Edited this to point to the old database and voila > --

Re: [MediaWiki-l] MediaWiki cannot access database after upgrade

2021-03-30 Thread Bart Everson
Happy to report that I fixed the problem described in my previous query. I did it by making a fresh install in a new database, which generated a proper LocalSettings.php file. Edited this to point to the old database and voila -- everything fixed. So, it would seem the upgrade process may have

[MediaWiki-l] MediaWiki cannot access database after upgrade

2021-03-30 Thread Bart Everson
Greetings. I've been using MediaWiki in a couple different installations for over a decade, but I've just run into a problem that has me stumped. It came after upgrading from 1.29.2 to 1.35.1. The process seemed to go smoothly, though I had to set the $wgServer variable which wasn't in my

Re: [MediaWiki-l] Problem granting privileges to mediawiki user

2021-03-30 Thread Jeffrey Walton
On Tue, Mar 30, 2021 at 10:23 AM Elias Holzmann wrote: > > Looks like this syntax was removed in MySQL 8.0: > > "The following features related to account management have been removed: > - ... > - IDENTIFIED BY PASSWORD 'hash_string' syntax for CREATE USER and GRANT. > Instead, use IDENTIFIED

[MediaWiki-l] Trying to access array offset on value of type bool in Setup.php:563

2021-03-30 Thread Jeffrey Walton
Hi Everyone, This caught my eye when running one of my maintenance scripts. The Setup.php:563 warning is new. The warning was not present on the old CentOS machine. The new machine is Ubuntu 20, PHP 7.4, MySQL 8, Mediawiki 1.35.1. # php /var/www/html/w/maintenance/generateSitemap.php ... PHP

Re: [MediaWiki-l] Problem granting privileges to mediawiki user

2021-03-30 Thread Elias Holzmann via MediaWiki-l
Looks like this syntax was removed in MySQL 8.0: "The following features related to account management have been removed: - ... - IDENTIFIED BY PASSWORD 'hash_string' syntax for CREATE USER and GRANT. Instead, use IDENTIFIED WITH auth_plugin AS 'hash_string' for CREATE USER and ALTER USER, where

Re: [MediaWiki-l] Problem granting privileges to mediawiki user

2021-03-30 Thread Dave Humphrey
That command looks fine and works for me so not sure what the exact problem might be. A few suggestions to consider: - You have a ' or other special character in 'password' that needs to be escaped. - You are using an old version of MySQL with a different command format. - Your mysql root account

[MediaWiki-l] Problem granting privileges to mediawiki user

2021-03-30 Thread Jeffrey Walton
Hi Everyone, We switched VPS providers. I am restoring a wiki database via a MySQL dump. The import/source was successful, but it did not include the users. The dump only had the wiki database. The new machine uses: # mysql --version mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64