I haven't yet figured out what privileges are needed. On Mon, Jul 11, 2022 at 1:27 PM Evan Stewart <evanstewart406@gmail.com> 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 <keith@thesorbos.com> 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 <evanstewart406@gmail.com> 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 <keith@thesorbos.com> 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 Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha