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
===
