Bugzilla – Attachment 194002 Details for
Bug 41353
koha-dump failing on mysqldump PROCESS privileges
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 41353: koha-dump failing on mysqldump PROCESS privileges
Bug-41353-koha-dump-failing-on-mysqldump-PROCESS-p.patch (text/plain), 1.83 KB, created by
Saiful Amin
on 2026-02-26 14:11:28 UTC
(
hide
)
Description:
Bug 41353: koha-dump failing on mysqldump PROCESS privileges
Filename:
MIME Type:
Creator:
Saiful Amin
Created:
2026-02-26 14:11:28 UTC
Size:
1.83 KB
patch
obsolete
>From 1f669d708b4f07d7f4d9b9008f2231dc1d4b80bb Mon Sep 17 00:00:00 2001 >From: Saiful Amin <saiful@semanticconsulting.com> >Date: Thu, 26 Feb 2026 13:59:44 +0000 >Subject: [PATCH] Bug 41353: koha-dump failing on mysqldump PROCESS privileges > >Problem: >Starting from MySQL 5.7.31 and MySQL 8.0.20, mysqldump requires the >PROCESS privilege to access tablespace metadata by default. Without >this privilege, backup operations fail with permission errors. > >Solution: >Add the --no-tablespaces flag to the dbflag variable. This prevents >mysqldump from attempting to access tablespace metadata, allowing >backups to complete successfully without requiring the PROCESS privilege. > >Test Plan: > 1. Set up a MySQL instance (5.7.31+ or 8.0.20+) without PROCESS privilege for the Koha database user > 2. Run the koha-dump script for a Koha instance: > sudo koha-dump kohadev > 3. Notice the backup fails with a PROCESS privilege error > 4. Apply the patch > 5. Copy debian/scripts/koha-dump to /usr/sbin/koha-dump > 6. Repeat step 2 > 7. Notice the backup now completes successfully without permission errors > 8. Test restoring the dump to ensure it's valid: > zcat /var/spool/koha/kohadev/kohadev-<date>.sql.gz | tail > 9. Sign-off >--- > debian/scripts/koha-dump | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/debian/scripts/koha-dump b/debian/scripts/koha-dump >index a4b5086cdb..5cf4fa712f 100755 >--- a/debian/scripts/koha-dump >+++ b/debian/scripts/koha-dump >@@ -76,7 +76,7 @@ dump_instance() > backupdir="$( xmlstarlet sel -t -v 'yazgfs/config/backupdir' $kohaconfig || true )" > [ -z "$backupdir" ] && backupdir="/var/spool/koha/$name" > dbdump="$backupdir/$name-$date.sql.gz" >- dbflag="--databases" >+ dbflag="--no-tablespaces --databases" > [ "$without_db_name" = "yes" ] && dbflag="" > if [ "$schema_only" = "yes" ] > then >-- >2.39.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 41353
:
190076
|
194002
|
194249