Qlustar version: 13.2 Qluman version: 13.7.2
I am trying to restore a qluman database from another server using "Manage Cluster" > "Global Configs" > "Restore database" and encountered an error: Permission denied. However, I also tried it with a backup, which I created within the current session, and encountered the same error. What can I do? Best regards, Lorenz
Hi Lorenz,
the "Permission denied" error is a server error so your backup file is fine and the client was able to parse it properly. The server though won't let your user restore the DB. There should be a log entry in /var/log/qluman/qlumand.log for the attempt giving more information why the server rejected the request.
Restoring the DB is only allowed for the actual admin user as there is currently no right option to allow other users to execute this request. Something we might have to change in the future. Are you logged in as the admin user?
Best regards, Goswin
Hi Goswin,
Thank you for your message. I am actually logged in as the admin user. When I tried to restore the database, I obtained the following log entry from qlumand.log: `ERROR server.admin client:admin [b'\x00k\x8bE\x94'] lacks right to request restore_db` Could something else cause the permission issue?
Best regards, Lorenz
Hi Lorenz,
this feature is not well-tested and really only used for internal tests. If you want to copy the database to another QluMan instance, you can use the regular mariadb backup located underneath /var/backups/mariaDB. On the server where you want to import the DB just stop qlumand, drop/recreate the QluMan DB and import the backup data in the usual mysql/mariadb way something like.
drop database QluMan; create database QluMan; mariadb QluMan < <backup file>
But beware that imported data on another cluster might need some handish adjustments in the DB due to changed network addresses on the new head-node.
Best,
Roland
On 2/20/25 08:51, ldettmann--- via Qlustar General wrote:
Hi Goswin,
Thank you for your message. I am actually logged in as the admin user. When I tried to restore the database, I obtained the following log entry from qlumand.log: `ERROR server.admin client:admin [b'\x00k\x8bE\x94'] lacks right to request restore_db` Could something else cause the permission issue?
Best regards, Lorenz _______________________________________________ Qlustar General mailing list -- qlustar-general@qlustar.org To unsubscribe send an email to qlustar-general-leave@qlustar.org
Hi Roland,
Thank you for your advice. I will do it that way and take care of the needed adjustments.
Best regards, Lorenz
-
Goswin von Brederlow -
ldettmann＠web.de -
Roland Fehrenbacher