I haven't yet figured out what privileges are needed. On Mon, Jul 11, 2022 at 1:27 PM Evan Stewart <[email protected]> wrote:
> 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
