[Koha] Site user lacks priviledges for koha-dump

[Mason James]

hi Keith

the following command shows the user's privs, for an instance called 'dev1'...
  mysql> SHOW GRANTS FOR 'koha_dev1'@'localhost'\G


the following command grants the required privs...
  mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `koha_dev1`.* TO `koha_dev1`@`localhost`;


you'll need to replace 'dev1' with your instance's name



On 12/07/22 7:34 am, Keith Sorbo wrote:
> 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
>>>>>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha