Oliver, I am pretty sure you where having a mysql version error at first. This one is new to me. Did you fully remove mysql and the cloud database and then install mariadb? Maybe you can drop all tables and run the mvn command for installing a db instead of the create db script. just for checking
On Mon, Jul 10, 2017 at 9:39 AM, Olivier Lamy <ol...@apache.org> wrote: > Hi > Looks more to be a permission issue > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: ALTER > command denied to user 'cloud'@'localhost' for table 'account' > > When running create-database script I get this warning. > > sql> GRANT ALL ON cloud.* to cloud@`%` identified by 'cloud' > [2017-07-07 09:47:56] [HY000][1287] Using GRANT statement to modify > existing user's properties other than privileges is deprecated and will be > removed in future release. Use ALTER USER statement for this operation. > > Anyway I changed to MariaBD and made some progress :-) but still an error. > > My steps: > > * running the following scripts to create databases: create-database.sql, > create-database-premium.sql, create-database-simulator.sql. > > * running the following scripts to create base schemas: create-schema.sql, > create-schema-premium.sql, create-schema-simulator.sql > > * start the ui with mvn -pl :cloud-client-ui jetty:run > > But now it fail with (stack trace truncated but full available here: > https://gist.github.com/olamy/b13e5f831b933829dd2ced7ddb5dc59b > > INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Cleanup upgrade > Upgrade441to442 to upgrade from 4.4.1-4.4.2 to 4.4.2 > > ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: ALTER > TABLE `cloud`.`guest_os_hypervisor` ADD FOREIGN KEY (`guest_os_id`) > REFERENCES `cloud`.`guest_os`(`id`) > > ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Cannot add or update a child row: a foreign key constraint fails > (`cloud`.`#sql-882f_27`, CONSTRAINT `#sql-882f_27_ibfk_1` FOREIGN KEY > (`guest_os_id`) REFERENCES `guest_os` (`id`)) > > ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to execute > upgrade script: > /Users/olamy/dev/sources/open-sources/cloudstack/cloudstack/client/target/utilities/scripts/db/db/schema-442to450.sql > > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Cannot add or update a child row: a foreign key constraint fails > (`cloud`.`#sql-882f_27`, CONSTRAINT `#sql-882f_27_ibfk_1` FOREIGN KEY > (`guest_os_id`) REFERENCES `guest_os` (`id`)) > > ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to upgrade > the database > > 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-442to450.sql > > Not sure what to do here :-( > > On 6 July 2017 at 19:22, Wido den Hollander <w...@widodh.nl> wrote: > >> >> > Op 6 juli 2017 om 9:02 schreef Olivier Lamy <ol...@apache.org>: >> > >> > >> > 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(DatabaseUpg >> radeChecker.java:438) >> > >> > at >> > com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgra >> deChecker.java:509) >> > >> > at >> > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLif >> eCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65) >> > >> > at >> > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLif >> eCycle.start(CloudStackExtendedLifeCycle.java:55) >> > >> > at >> > org.springframework.context.support.DefaultLifecycleProcesso >> r.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(DatabaseU >> pgradeChecker.java:331) >> > >> > at >> > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpg >> radeChecker.java:425) >> > >> > ... 74 more >> > >> > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >> ALTER >> > command denied to user 'cloud'@'localhost' for table 'account' >> > >> >> I see a access denied. Could you check the access credentials of the user >> in MySQL? >> >> Wido >> >> > 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(DatabaseU >> pgradeChecker.java:322) >> > Cheers >> > -- >> > Olivier Lamy >> > http://twitter.com/olamy | http://linkedin.com/in/olamy >> > > > > -- > Olivier Lamy > http://twitter.com/olamy | http://linkedin.com/in/olamy -- Daan
