Site user lacks priviledges for koha-dump
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
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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Keith, Sorry if my answer is too basic. You might have already tried these steps. Just starting with the extra basics to double check the easy items. My old helpdesk days are showing through. : ) -Evan On Sun, Jul 10, 2022 at 10:28 PM Evan Stewart <evanstewart406@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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
I haven't yet figured out what privileges are needed. On Mon, Jul 11, 2022 at 1:27 PM Evan Stewart <evanstewart406@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@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@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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Evan Stewart -
Keith Sorbo -
Mason James