Hi Sebastien, You should create a cloud schema + cloud user on your Mac's MySQLServer
Regards, Charles On Wed, Nov 14, 2012 at 4:04 PM, Sebastien Goasguen <run...@gmail.com>wrote: > Hi, > > I am testing the awsapi with the new maven build. > Following: > https://cwiki.apache.org/CLOUDSTACK/cloudstack-devcloud-environment-setup.html > > I run: > mvn -pl :cloud-client-ui jetty:run > and > mvn -pl :cloud-awsapi jetty:run > > when I try to register a user it fails with a 401 error, and the jetty > logs show: > > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could > not create connection to database server. Attempted reconnect 3 times. > Giving up. > 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:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) > at > com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2299) > at > com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2220) > at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813) > at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) > 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:411) > at > com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399) > at > com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334) > at java.sql.DriverManager.getConnection(DriverManager.java:582) > at java.sql.DriverManager.getConnection(DriverManager.java:185) > at > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(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.getConnection(Transaction.java:558) > at > com.cloud.utils.db.Transaction.prepareStatement(Transaction.java:453) > at > com.cloud.utils.db.Transaction.prepareAutoCloseStatement(Transaction.java:446) > at > com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:382) > ... 56 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Access denied for user 'cloud'@'localhost' to database 'null' > 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:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919) > at > com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1694) > at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1244) > at > com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2397) > at > com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2238) > > > Database was setup with: > mvn -P developer -pl developer,tools/devcloud -Ddeploydb > > Don't know if it's a bug or I am doing it wrong. Thoughts ? > > -Sebastien > > -- Charles Moulliard Apache Committer / Sr. Enterprise Architect (RedHat) Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
