Sorry Oliver, I don't think we use such a tag. Good suggestion though. For now,
look at findbugs and such tools for things you could re-factor.
On 12/07/17 13:42, "Olivier Lamy" <ol...@apache.org> wrote:
Hi
Yes I dropped all databases.
But I was trying to create manually by myself all the databases and initial
schemas manually..
Well finally reading the thread "Developer Guide - Current Setup Guide"
helped me and I found what I missed to do :-) (sorry for the noise)
As a starter I'd like to know if you have any issue flagged as
"starter/noob" level? (just some easy issue I could have a look to discover
the code)
Thanks!
Cheers
Olivier
daan.hoogl...@shapeblue.com
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
On 11 July 2017 at 00:56, Daan Hoogland <daan.hoogl...@gmail.com> wrote:
> 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.MySQLIntegrityConstraintViol
> ationException:
> > 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.MySQLIntegrityConstraintViol
> ationException:
> > 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
>
--
Olivier Lamy
http://twitter.com/olamy | http://linkedin.com/in/olamy
