[Koha] Site user lacks priviledges for koha-dump

[Mason James]

aah... if you look at koha-create, it simply assigns ALL privs

so that's the easier fix :)

mysql> GRANT ALL PRIVILEGES ON `koha_dev1`.* TO `koha_dev1`@`localhost`;
mysql> FLUSH PRIVILEGES;


On 12/07/22 3:16 pm, Mason James wrote:
> 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
>