[Koha] Site user lacks priviledges for koha-dump

[Keith Sorbo]

I haven't yet figured out what privileges are needed.

On Mon, Jul 11, 2022 at 1:27 PM Evan Stewart <evanstewart406 at 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 at 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 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
>>>>
>>>