cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Indra Pramana <in...@sg.or.id>
Subject Re: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Date Wed, 02 Oct 2013 12:52:06 GMT
Hi Rafael,

What I did is just to setup a new CloudStack 4.1.1 on a test VM, restore
the dump backup of our production database into the test environment, and
try to upgrade to 4.2.0.

Could it be because the database was taken from a different environment?
However, I tested accessing the GUI of the test environment after the dump
restore and I can access it, prior to the upgrade.

Looking forward to your reply, thank you.

Cheers.




On Wed, Oct 2, 2013 at 8:42 PM, Rafael Weingartner <
rafaelweingartner@gmail.com> wrote:

> 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