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 <[email protected]>
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 <[email protected]> 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 <[email protected]>
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 <[email protected]> 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
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
