Hi Keith, Thanks for the confirmation. I'm surprised too that the Koha install didn't get the higher privileges for the DB tables. That's why I thought it might be a Linux root issue because my Koha install gave privileges to root for all MariaDB tables.
Were you able to solve the problem by granting more privileges to the mysql user? -Evan On Mon, Jul 11, 2022 at 8:48 AM Keith Sorbo <[email protected]> wrote: > Thanks, Evan, > > I am already running as root. > > I looked at the script and it pulls the mysql username and password from > the library koha-config.xml. > > I am rather surprised that during installation, the koha system did not > give sufficient grants to this user. > > Keith > > On Sun, Jul 10, 2022 at 11:28 PM Evan Stewart <[email protected]> > wrote: > >> Hi Keith, >> >> Try using "sudo" with the command and include the instance name of the >> library (For example, my library instance is named "catalog"). Sudo gives >> your account the extra admin privileges it needs to run the command. >> >> Anytime I run this command I type it as: >> >> sudo koha-dump catalog >> >> When prompted, I enter my Linux user account password because it has sudo >> privileges. >> >> If you don't know your library instance name, then run the command: >> >> sudo koha-list >> >> Your instance name (or instances if multiple are installed) will be >> listed. >> >> -Evan Stewart >> Africa's Hope, USA >> >> On Sun, Jul 10, 2022 at 8:43 PM Keith Sorbo <[email protected]> wrote: >> >>> I am attempting to move my library instance to a new server using the >>> koha-dump command >>> >>> When I run the command, I get >>> >>> Error: 'Access denied; you need (at least one of) the PROCESS >>> privilege(s) >>> for this operation' when trying to dump tablespaces >>> >>> How can I correct this? >>> >>> Keith >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> [email protected] >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
