Diego Dias 0 Posted July 3, 2017 Share Posted July 3, 2017 Good afternoon, does anyone know why when I go to backup according to the documentation of the server era it gives this error? [root@srv-eset-01 ~]# mysqldump --host 100.100.100.8 --disable-keys --extended-insert --routines -u era -p era_db > eradb Enter password: mysqldump: Couldn't execute 'show create table `vw_activethreats_aggr`': SHOW VIEW command denied to user 'era'@'100.100.100.8' for table 'vw_activethreats_aggr' (1142) [root@srv-eset-01 ~]# Thank you Link to comment Share on other sites More sharing options...
ESET Staff MartinK 384 Posted July 3, 2017 ESET Staff Share Posted July 3, 2017 Problem is that user "era" used for SERVER has not enough permissions for this operations, and that is why root user (or user with enough permissions) should be used. Could you please provide ling to documentation you used? I found similar command in our documentation but it uses root user to backup database. Link to comment Share on other sites More sharing options...
Diego Dias 0 Posted July 3, 2017 Author Share Posted July 3, 2017 I used this link hxxp://help.eset.com/era_install/64/en-US/index.html?migration_same_version.htm since I also used the root user and the same error still. 1 hour ago, MartinK said: O problema é que o "era" do usuário usado para o SERVER não possui permissões suficientes para essas operações, e é por isso que o usuário root (ou usuário com permissões suficientes) deve ser usado. Você poderia fornecer ling para documentação que você usou? Eu encontrei um comando similar em nossa documentação, mas usa usuários raiz para banco de dados de backup. Link to comment Share on other sites More sharing options...
Diego Dias 0 Posted July 5, 2017 Author Share Posted July 5, 2017 Any Solution? Link to comment Share on other sites More sharing options...
ESET Staff MartinK 384 Posted July 6, 2017 ESET Staff Share Posted July 6, 2017 I have tried it with "root" user from localhost, and everything went fine. Could you please provide output of query: SHOW GRANTS; when logged into database with various users (users you tried to backup database): mysql -u root -h localhost -p -e 'SHOW GRANTS;' era_db Standard era user, created during appliance initialization has not enough permissions to backup whole databasae (it is missing SHOW VIEW permissions), but root user (at least root%localhost) should have full access to all databases. Link to comment Share on other sites More sharing options...
Diego Dias 0 Posted July 27, 2017 Author Share Posted July 27, 2017 [root@srv-eset-01 ~]# mysql -u root -h localhost -p -e 'SHOW GRANTS;' era_db Enter password: +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*64037E23FE82637A11CE3A2F5FAFE9EE5DD87AB3' WITH GRANT OPTION | | GRANT ALL PRIVILEGES ON `era_db`.* TO 'root'@'localhost' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `era_g2_db`.* TO 'root'@'localhost' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `era_g2_proxy_db`.* TO 'root'@'localhost' | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ [root@srv-eset-01 ~]# i have permissions, i just can not backup. i need for upgrade version of ERA Appliance. Link to comment Share on other sites More sharing options...
Recommended Posts