H Oliver, your mysql seems to new for cloudstack ;) and welcome back
On 06/07/2017, 09:02, "Olivier Lamy" <ol...@apache.org> wrote:
Hi,
Long time I didn't participate here.
I'd like to do some hacking.
I'm not clear on the process for noob :-)
I ran sql scripts:
* create-database.sql
* create-schema.sql
Then I start with mvn -pl :cloud-client-ui jetty:run
But I got the this error (see stacktrace below)
I use osx, mysql 5.7.18_1 installed with brew
Thanks a lot for your help
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to
upgrade the database
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:438)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:509)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
at
org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55)
at
org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:173)
... 70 more
Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to
execute upgrade script:
/Users/olamy/dev/sources/open-sources/cloudstack/cloudstack/client/target/utilities/scripts/db/db/schema-410to420.sql
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:331)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:425)
... 74 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ALTER
command denied to user 'cloud'@'localhost' for table 'account'
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:322)
Cheers
--
Olivier Lamy
http://twitter.com/olamy | http://linkedin.com/in/olamy
daan.hoogl...@shapeblue.com
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
