You need to create the db.properties.override file and fill it with the correct information to access your mysql db instance.
--Alex > -----Original Message----- > From: Mike Tutkowski [mailto:mike.tutkow...@solidfire.com] > Sent: Tuesday, January 08, 2013 3:47 PM > To: cloudstack-dev@incubator.apache.org > Subject: Re: Running Maven Command > > No problem, Alex. > > Thanks for all the help while I try to get up and running with CloudStack. > :) > > SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". > > SLF4J: Defaulting to no-operation (NOP) logger implementation > > SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further > details. > > [INFO] Scanning for projects... > > [INFO] > > > [INFO] > ------------------------------------------------------------------------ > > [INFO] Building Apache CloudStack Developer Tools 4.1.0-SNAPSHOT > > [INFO] > ------------------------------------------------------------------------ > > [INFO] > > [INFO] --- properties-maven-plugin:1.0-alpha-2:read-project-properties > (default) @ cloud-developer --- > > [WARNING] Ignoring missing properties file: > /Users/mtutkowski/Documents/CloudStack/src/incubator- > cloudstack/utils/conf/db.properties.override > > [INFO] > > [INFO] --- maven-remote-resources-plugin:1.3:process (default) @ > cloud-developer --- > > [INFO] > > [INFO] --- maven-antrun-plugin:1.7:run (default) @ cloud-developer --- > > [INFO] Executing tasks > > > main: > > [INFO] Executed tasks > > [INFO] > > [INFO] >>> exec-maven-plugin:1.2.1:java (create-schema) @ cloud- > developer > >>> > > [INFO] > > [INFO] <<< exec-maven-plugin:1.2.1:java (create-schema) @ cloud- > developer > <<< > > [INFO] > > [INFO] --- exec-maven-plugin:1.2.1:java (create-schema) @ cloud-developer > --- > > =============> Processing SQL file at > /Users/mtutkowski/Documents/CloudStack/src/incubator- > cloudstack/developer/target/db/create-schema.sql > > 2013-01-08 16:32:20,735 WARN [db.Transaction.Transaction] > (com.cloud.upgrade.DatabaseCreator.main():) Unable to load db > configuration, using defaults with 5 connections. Please check your > configuration > > java.io.FileNotFoundException: > file:/Users/mtutkowski/.m2/repository/org/apache/cloudstack/cloud- > utils/4.1.0-SNAPSHOT/cloud-utils-4.1.0-SNAPSHOT-tests.jar!/db.properties > (No such file or directory) > > at java.io.FileInputStream.open(Native Method) > > at java.io.FileInputStream.<init>(FileInputStream.java:120) > > at com.cloud.utils.db.Transaction.<clinit>(Transaction.java:1015) > > at com.cloud.upgrade.DatabaseCreator.main(DatabaseCreator.java:66) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:597) > > at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297) > > at java.lang.Thread.run(Thread.java:680) > > 2013-01-08 16:32:20,907 ERROR [db.Transaction.Transaction] > (com.cloud.upgrade.DatabaseCreator.main():) Unexpected exception: > > java.sql.SQLException: Access denied for user 'cloud'@'localhost' (using > password: YES) > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:920) > > at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4000) > > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1285) > > at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2186) > > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787) > > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49) > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > at sun.reflect.NativeConstructorAccessorImpl.newInstance( > NativeConstructorAccessorImpl.java:39) > > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance( > DelegatingConstructorAccessorImpl.java:27) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) > > at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:357) > > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:28 > 5 > ) > > at java.sql.DriverManager.getConnection(DriverManager.java:582) > > at java.sql.DriverManager.getConnection(DriverManager.java:185) > > at > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnec > tion( > DriverManagerConnectionFactory.java:75) > > at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject( > PoolableConnectionFactory.java:582) > > at org.apache.commons.pool.impl.GenericObjectPool.borrowObject( > GenericObjectPool.java:1188) > > at org.apache.commons.dbcp.PoolingDataSource.getConnection( > PoolingDataSource.java:106) > > at com.cloud.utils.db.Transaction.getStandaloneConnectionWithException( > Transaction.java:200) > > at com.cloud.utils.db.Transaction.getStandaloneConnection( > Transaction.java:209) > > at com.cloud.upgrade.DatabaseCreator.main(DatabaseCreator.java:66) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:597) > > at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297) > > at java.lang.Thread.run(Thread.java:680) > > [WARNING] > > java.lang.reflect.InvocationTargetException > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:597) > > at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297) > > at java.lang.Thread.run(Thread.java:680) > > Caused by: java.lang.NullPointerException > > at com.cloud.upgrade.DatabaseCreator.main(DatabaseCreator.java:89) > > ... 6 more > > [INFO] > ------------------------------------------------------------------------ > > [INFO] BUILD FAILURE > > [INFO] > ------------------------------------------------------------------------ > > [INFO] Total time: 4.206s > > [INFO] Finished at: Tue Jan 08 16:32:20 MST 2013 > > [INFO] Final Memory: 15M/81M > > [INFO] > ------------------------------------------------------------------------ > > [ERROR] Failed to execute goal > org.codehaus.mojo:exec-maven-plugin:1.2.1:java (create-schema) on > project > cloud-developer: An exception occured while executing the Java class. null: > InvocationTargetException: NullPointerException -> [Help 1] > > [ERROR] > > [ERROR] To see the full stack trace of the errors, re-run Maven with the -e > switch. > > [ERROR] Re-run Maven using the -X switch to enable full debug logging. > > [ERROR] > > [ERROR] For more information about the errors and possible solutions, > please read the following articles: > > [ERROR] [Help 1] > http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionExcepti > on > > > On Tue, Jan 8, 2013 at 4:44 PM, Alex Huang <alex.hu...@citrix.com> wrote: > > > Can you post more of the log output? Would give more context. > > > > --Alex > > > > > -----Original Message----- > > > From: Mike Tutkowski [mailto:mike.tutkow...@solidfire.com] > > > Sent: Tuesday, January 08, 2013 3:41 PM > > > To: cloudstack-dev@incubator.apache.org > > > Subject: Re: Running Maven Command > > > > > > When I look at the file that wasn't found ( > > > > > > file:/Users/mtutkowski/.m2/repository/org/apache/cloudstack/cloud- > > > utils/4.1.0-SNAPSHOT/cloud-utils-4.1.0-SNAPSHOT- > tests.jar!/db.properties > > > > > > ), I'm not familiar with the exclamation-mark syntax. I assume what this > > > means is it was looking for the file db.properties inside of the JAR > > file? > > > > > > Any pointers for me on why this might be? > > > > > > Thanks!! :) > > > > > > > > > On Tue, Jan 8, 2013 at 3:50 PM, Mike Tutkowski > > > <mike.tutkow...@solidfire.com > > > > wrote: > > > > > > > Thanks for the feedback, Alex. > > > > > > > > I'm trying to deploy the DB and am here: > > > > Deploying Database > > > > > > > > Note: The following is a WIP feature, use the old Ant command for a > > > > complete refresh. This command assumes you have a proper setup in > > > > utils/conf/db.properties and the cloud user already exists on your > > mysql > > > > database. > > > > > > > > $ mvn -P developer -pl developer -Ddeploydb > > > > > > > > To customize hosts, password etc. just copy utils/conf/db.properties to > > > > utils/conf/db.properties.override (this is git ignored by default) and > > edit > > > > the properties as needed they will override the defaults in > > > > utils/conf/db.properties. > > > > > > > > > > > > I'm not exactly sure what a "proper setup" means. Would you be able > to > > > > clarify this for me? > > > > > > > > Currently when I run the Maven command to deploy the DB, I get a > > > warning > > > > (which I think I can ignore): > > > > > > > > [WARNING] Ignoring missing properties file: > > > > /Users/mtutkowski/Documents/CloudStack/src/incubator- > > > cloudstack/utils/conf/db.properties.override > > > > > > > > I think I only need the .override file if I actually overrode a > > property, > > > > but perhaps I should be overriding properties? I'm not sure. > > > > > > > > In a related manner, this message is later displayed: > > > > > > > > java.io.FileNotFoundException: > > > > file:/Users/mtutkowski/.m2/repository/org/apache/cloudstack/cloud- > > > utils/4.1.0-SNAPSHOT/cloud-utils-4.1.0-SNAPSHOT- > tests.jar!/db.properties > > > > > > > > Thanks for any help! > > > > > > > > > > > > > > > > On Tue, Jan 8, 2013 at 2:51 PM, Alex Huang <alex.hu...@citrix.com> > > > wrote: > > > > > > > >> mvn -pl client jetty:run > > > >> > > > >> man....i always have to go find these things myself. Maven is pretty > > > >> chatty in terms of params. > > > >> > > > >> --Alex > > > >> > > > >> > -----Original Message----- > > > >> > From: Mike Tutkowski [mailto:mike.tutkow...@solidfire.com] > > > >> > Sent: Tuesday, January 08, 2013 1:46 PM > > > >> > To: cloudstack-dev@incubator.apache.org > > > >> > Subject: Running Maven Command > > > >> > > > > >> > Hi everyone, > > > >> > > > > >> > I'm trying to follow the instructions on this URL: > > > >> > > > > >> > https://cwiki.apache.org/CLOUDSTACK/building-with- > > > >> > maven.html#BuildingwithMaven-Dependencies > > > >> > > > > >> > Running on the javelin branch, I've successfully executed mvn clean > > and > > > >> mvn > > > >> > install -Dnonoss. > > > >> > > > > >> > When I get down to this instruction and execute it, it fails: > > > >> > > > > >> > mvn -pl :cloud-client-ui jetty:run > > > >> > > > > >> > > > > >> > This is the error message: > > > >> > > > > >> > > > > >> > Listening for transport dt_socket at address: 8787 > > > >> > [INFO] Scanning for projects... > > > >> > [ERROR] Could not find the selected project in the reactor: > > > >> > :cloud-client-ui -> [Help 1] > > > >> > [ERROR] > > > >> > [ERROR] To see the full stack trace of the errors, re-run Maven with > > > >> > the -e switch. > > > >> > [ERROR] Re-run Maven using the -X switch to enable full debug > > logging. > > > >> > [ERROR] > > > >> > [ERROR] For more information about the errors and possible > > solutions, > > > >> > please read the following articles: > > > >> > [ERROR] [Help 1] > > > >> > > > > > http://cwiki.apache.org/confluence/display/MAVEN/MavenExecutionExcept > > > >> > ion > > > >> > > > > >> > > > > >> > Any help would be appreciated. > > > >> > > > > >> > > > > >> > Thanks!! > > > >> > > > > >> > > > > >> > -- > > > >> > *Mike Tutkowski* > > > >> > *Senior CloudStack Developer, SolidFire Inc.* > > > >> > e: mike.tutkow...@solidfire.com > > > >> > o: 303.746.7302 > > > >> > Advancing the way the world uses the > > > >> > cloud<http://solidfire.com/solution/overview/?video=play> > > > >> > *(tm)* > > > >> > > > > > > > > > > > > > > > > -- > > > > *Mike Tutkowski* > > > > *Senior CloudStack Developer, SolidFire Inc.* > > > > e: mike.tutkow...@solidfire.com > > > > o: 303.746.7302 > > > > Advancing the way the world uses the > > > cloud<http://solidfire.com/solution/overview/?video=play> > > > > *(tm)* > > > > > > > > > > > > > > > > -- > > > *Mike Tutkowski* > > > *Senior CloudStack Developer, SolidFire Inc.* > > > e: mike.tutkow...@solidfire.com > > > o: 303.746.7302 > > > Advancing the way the world uses the > > > cloud<http://solidfire.com/solution/overview/?video=play> > > > *(tm)* > > > > > > -- > *Mike Tutkowski* > *Senior CloudStack Developer, SolidFire Inc.* > e: mike.tutkow...@solidfire.com > o: 303.746.7302 > Advancing the way the world uses the > cloud<http://solidfire.com/solution/overview/?video=play> > *(tm)*
