cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rafael Weingartner <rafaelweingart...@gmail.com>
Subject Re: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Date Wed, 02 Oct 2013 12:42:52 GMT
Interesting errors, just by any change are you using the database on Amazon
RDS?


2013/10/2 Indra Pramana <indra@sg.or.id>

> Dear all,
>
> I tried to simulate upgrading the database from Cloudstack 4.1.1 to 4.2.0
> on my test environment and getting below error message:
>
> MySQLSyntaxErrorException: Access denied; you need (at least one of) the
> SUPER privilege(s) for this operation
>
> Anyone can advise what super privilege is required? The database worked
> fine on 4.1.1 prior to the upgrade.
>
> Below is more logs from the management-server.log:
>
> ====
> 2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
> `cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id IN (1,2)
> 2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
> `cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2)
> 2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
> `cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN (1,2)
> 2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
> VIEW `cloud`.`user_view` AS     select          user.id,
> user.uuid,         user.username,         user.password,
> user.firstname,         user.lastname,         user.email,
> user.state,         user.api_key,         user.secret_key,
> user.created,         user.removed,         user.timezone,
> user.registration_token,         user.is_registered,
> user.incorrect_login_attempts,         user.default,
> account.idaccount_id,         account.uuid account_uuid,
> account.account_name
> account_name,         account.type account_type,
> domain.iddomain_id,         domain.uuid domain_uuid,
> domain.name domain_name,         domain.path domain_path,
> async_job.id job_id,         async_job.uuid job_uuid,
> async_job.job_status job_status,         async_job.account_id
> job_account_id     from         `cloud`.`user`             inner
> join         `cloud`.`account` ON user.account_id = account.id
> inner join         `cloud`.`domain` ON account.domain_id = domain.id
> left join         `cloud`.`async_job` ON async_job.instance_id =
> user.id
> and async_job.instance_type = 'User'             and async_job.job_status =
> 0
> 2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error
> executing: ALTER VIEW `cloud`.`user_view` AS     select
> user.id,
> user.uuid,         user.username,         user.password,
> user.firstname,         user.lastname,         user.email,
> user.state,         user.api_key,         user.secret_key,
> user.created,         user.removed,         user.timezone,
> user.registration_token,         user.is_registered,
> user.incorrect_login_attempts,         user.default,
> account.idaccount_id,         account.uuid account_uuid,
> account.account_name
> account_name,         account.type account_type,
> domain.iddomain_id,         domain.uuid domain_uuid,
> domain.name domain_name,         domain.path domain_path,
> async_job.id job_id,         async_job.uuid job_uuid,
> async_job.job_status job_status,         async_job.account_id
> job_account_id     from         `cloud`.`user`             inner
> join         `cloud`.`account` ON user.account_id = account.id
> inner join         `cloud`.`domain` ON account.domain_id = domain.id
> left join         `cloud`.`async_job` ON async_job.instance_id =
> user.id
> and async_job.instance_type = 'User'             and async_job.job_status =
> 0
> 2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied;
> you need (at least one of) the SUPER privilege(s) for this operation
> 2013-10-02 20:33:06,009 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) Unable to execute upgrade script:
> /usr/share/cloudstack-management/setup/db/schema-410to420.sql
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied;
> you need (at least one of) the SUPER privilege(s) for this operation
>         at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
>         at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
>         at
>
> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:201)
>         at
>
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262)
>         at
>
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391)
>         at
>
> com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
>         at
> com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
>         at java.util.TimerThread.mainLoop(Timer.java:534)
>         at java.util.TimerThread.run(Timer.java:484)
> 2013-10-02 20:33:06,011 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
> (Timer-1:null) Unable to upgrade the database
> com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
> script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql
>         at
>
> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:210)
>         at
>
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262)
>         at
>
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391)
>         at
>
> com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
>         at
> com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
>         at java.util.TimerThread.mainLoop(Timer.java:534)
>         at java.util.TimerThread.run(Timer.java:484)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> Access denied; you need (at least one of) the SUPER privilege(s) for this
> operation
>         at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
>         at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
>         at
>
> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:201)
>         ... 6 more
> ===
>



-- 
Rafael Weingartner

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message