[Koha] Site user lacks priviledges for koha-dump

[Keith Sorbo]

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 at 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 at 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 at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>