cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Indra Pramana <in...@sg.or.id>
Subject Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Date Wed, 02 Oct 2013 12:39:11 GMT
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
===

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