Mailing List Archive: MediaWiki backup failures due to mysqldump

MediaWiki backup failures due to mysqldump

Mar 30, 2023, 8:01 PM

Post #1 of 3 (166 views)

Hi Everyone,

A quick heads up for others in this situation... We attempted to
migrate to MW 1.38.6 tonight. Our first step is a manual backup.

We found our manual backup (and backups for the last couple of months)
have been failing (yuk!):

# /sbin/mw-backup
Repair wiki database ok
mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need
(at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this
operation (1227)
Failed to dump wiki database

It appears this is a known issue on Ubuntu:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/2003866

In our case, workarounds like adding RELOAD or FLUSH_TABLES to the
backup user also failed:

mysql> GRANT FLUSH_TABLES ON my_wiki.* TO 'mwuser'@'%';
ERROR 3619 (HY000): Illegal privilege level specified for FLUSH_TABLES
mysql> GRANT RELOAD ON my_wiki.* TO 'mwuser'@'%';
ERROR 1410 (42000): You are not allowed to create a user with GRANT

We reached our limit of knowledge for MySQL administration. I think we
will have to wait until the Ubuntu 2003866 bug is fixed.

Jeff
_______________________________________________
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org
To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/

Re: MediaWiki backup failures due to mysqldump [ In reply to ]

bawolff at gmail

Mar 30, 2023, 11:47 PM

Post #2 of 3 (166 views)

Permalink

I don't know about the error message, but RELOAD is a global right. I dont
think you are allowed to grant it to just a specific database instead of
all of mysql.

However the error message suggests something beyond that is going on.

--
Brian

On Thursday, March 30, 2023, Jeffrey Walton <noloader@gmail.com> wrote:

> Hi Everyone,
>
> A quick heads up for others in this situation... We attempted to
> migrate to MW 1.38.6 tonight. Our first step is a manual backup.
>
> We found our manual backup (and backups for the last couple of months)
> have been failing (yuk!):
>
> # /sbin/mw-backup
> Repair wiki database ok
> mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need
> (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this
> operation (1227)
> Failed to dump wiki database
>
> It appears this is a known issue on Ubuntu:
> https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/2003866
>
> In our case, workarounds like adding RELOAD or FLUSH_TABLES to the
> backup user also failed:
>
> mysql> GRANT FLUSH_TABLES ON my_wiki.* TO 'mwuser'@'%';
> ERROR 3619 (HY000): Illegal privilege level specified for FLUSH_TABLES
> mysql> GRANT RELOAD ON my_wiki.* TO 'mwuser'@'%';
> ERROR 1410 (42000): You are not allowed to create a user with GRANT
>
> We reached our limit of knowledge for MySQL administration. I think we
> will have to wait until the Ubuntu 2003866 bug is fixed.
>
> Jeff
> _______________________________________________
> MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org
> To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
> https://lists.wikimedia.org/postorius/lists/mediawiki-l.
> lists.wikimedia.org/
>

Re: MediaWiki backup failures due to mysqldump [ In reply to ]

noloader at gmail

Mar 31, 2023, 8:31 AM

Post #3 of 3 (166 views)

Permalink

Thanks Brian,

> However the error message suggests something beyond that is going on.

Yeah, that would not surprise me. The initial MySQL database and
mwuser was setup around 2005 or so. It probably missed a lot of
improvements over the years. I don't want to mess with it any more
than necessary because I'm not a MySQL admin. I don't know how to fix
it.

Jeff

On Fri, Mar 31, 2023 at 2:47?AM Brian Wolff <bawolff@gmail.com> wrote:
>
> I don't know about the error message, but RELOAD is a global right. I dont think you are allowed to grant it to just a specific database instead of all of mysql.
>
> However the error message suggests something beyond that is going on.
>
>
> On Thursday, March 30, 2023, Jeffrey Walton <noloader@gmail.com> wrote:
>>
>> Hi Everyone,
>>
>> A quick heads up for others in this situation... We attempted to
>> migrate to MW 1.38.6 tonight. Our first step is a manual backup.
>>
>> We found our manual backup (and backups for the last couple of months)
>> have been failing (yuk!):
>>
>> # /sbin/mw-backup
>> Repair wiki database ok
>> mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need
>> (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this
>> operation (1227)
>> Failed to dump wiki database
>>
>> It appears this is a known issue on Ubuntu:
>> https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/2003866
>>
>> In our case, workarounds like adding RELOAD or FLUSH_TABLES to the
>> backup user also failed:
>>
>> mysql> GRANT FLUSH_TABLES ON my_wiki.* TO 'mwuser'@'%';
>> ERROR 3619 (HY000): Illegal privilege level specified for FLUSH_TABLES
>> mysql> GRANT RELOAD ON my_wiki.* TO 'mwuser'@'%';
>> ERROR 1410 (42000): You are not allowed to create a user with GRANT
>>
>> We reached our limit of knowledge for MySQL administration. I think we
>> will have to wait until the Ubuntu 2003866 bug is fixed.
>>
_______________________________________________
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org
To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/