[Koha] Site user lacks priviledges for koha-dump

[Evan Stewart]

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
>>>
>>