A new request with request id 16642 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is :
Title : Koha-devel Digest, Vol 188, Issue 17
Category :
Description : Send Koha-devel mailing list submissions to
koha-devel@lists.koha-community.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
koha-devel-request@lists.koha-community.org
You can reach the person managing the list at
koha-devel-owner@lists.koha-community.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."
Today's Topics:
1. mysqldump: Error: 'Access denied; you need (at least one of)
the PROCESS privilege(s) for this operation' when trying to dump
tablespaces (dcook@prosentient.com.au)
----------------------------------------------------------------------
Message: 1
Date: Fri, 30 Jul 2021 13:33:50 +1000
From: <dcook@prosentient.com.au>
To: "'Koha Devel'" <koha-devel@lists.koha-community.org>, "'Jonathan
Druart'" <jonathan.druart@bugs.koha-community.org>
Subject: [Koha-devel] mysqldump: Error: 'Access denied; you need (at
least one of) the PROCESS privilege(s) for this operation' when trying
to dump tablespaces
Message-ID: <0b6d01d784f3$b675ece0$2361c6a0$@prosentient.com.au>
Content-Type: text/plain; charset="utf-8"
Hi all (especially Jonathan),
I was looking at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23329#c85 where Jonathan points out under MySQL 8 that we’re now getting this error with dumping the database:
“mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces”
I’ve seen this pop a few times myself on Koha projects, and it looks like it traces back to the security notes listed here: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-31.html
“Incompatible Change: Access to the INFORMATION_SCHEMA.FILES table now requires the PROCESS privilege.”
“This change affects users of the mysqldump command, which accesses tablespace information in the FILES table, and thus now requires the PROCESS privilege as well. Users who do not need to dump tablespace information can work around this requirement by invoking mysqldump with the --no-tablespaces option. (Bug #30350829)”
I haven’t looked into it too deeply yet, but I imagine adding the --no-tablespaces option to mysqldump in koha-dump is the way to go.
(I would’ve commented on Bugzilla but every time I try it keep blocking me and kicking me out.)
David Cook
Senior Software Engineer
Prosentient Systems
Suite 7.03
6a Glen St
Milsons Point NSW 2061
Australia
Office: 02 9212 0899
Online: 02 8005 0595
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210730/4f625475/attachment-0001.htm>
------------------------------
Subject: Digest Footer
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
------------------------------
End of Koha-devel Digest, Vol 188, Issue 17
*******************************************
NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.