Hi, As you can see below the error seems to be your database related - “CREATE command denied to user 'airavata'@'localhost’ "
Suresh > On Jan 22, 2017, at 10:58 PM, Damith Dilshan <ddrwijethu...@gmail.com> wrote: > > Hi suresh, > > An error occurs when I try to setup airavata.I have rabbitmq and mariadb > running.I have included the error log below. It would be great if you can > pint out what am I doing wrong, > > > Error occurred while executing : /* * * Licensed to the Apache Software > Foundation (ASF) under one * or more contributor license agreements. See the > NOTICE file * distributed with this work for additional information * > regarding copyright ownership. The ASF licenses this file * to you under the > Apache License, Version 2.0 (the * "License"); you may not use this file > except in compliance * with the License. You may obtain a copy of the > License at * * http://www.apache.org/licenses/LICENSE-2.0 > <http://www.apache.org/licenses/LICENSE-2.0> * * Unless required by > applicable law or agreed to in writing, * software distributed under the > License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR > CONDITIONS OF ANY * KIND, either express or implied. See the License for the > * specific language governing permissions and limitations * under the > License. * */ CREATE TABLE GATEWAY ( GATEWAY_ID VARCHAR(255), GATEWAY_NAME > VARCHAR(255), DOMAIN VARCHAR(255), EMAIL_ADDRESS VARCHAR(255), PRIMARY KEY > (GATEWAY_ID) ) > java.lang.Exception: Error occurred while executing : /* * * Licensed to the > Apache Software Foundation (ASF) under one * or more contributor license > agreements. See the NOTICE file * distributed with this work for additional > information * regarding copyright ownership. The ASF licenses this file * to > you under the Apache License, Version 2.0 (the * "License"); you may not use > this file except in compliance * with the License. You may obtain a copy of > the License at * * http://www.apache.org/licenses/LICENSE-2.0 > <http://www.apache.org/licenses/LICENSE-2.0> * * Unless required by > applicable law or agreed to in writing, * software distributed under the > License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR > CONDITIONS OF ANY * KIND, either express or implied. See the License for the > * specific language governing permissions and limitations * under the > License. * */ CREATE TABLE GATEWAY ( GATEWAY_ID VARCHAR(255), GATEWAY_NAME > VARCHAR(255), DOMAIN VARCHAR(255), EMAIL_ADDRESS VARCHAR(255), PRIMARY KEY > (GATEWAY_ID) ) > at > org.apache.airavata.api.server.util.DatabaseCreator.executeSQL(DatabaseCreator.java:154) > at > org.apache.airavata.api.server.util.DatabaseCreator.executeSQLScript(DatabaseCreator.java:299) > at > org.apache.airavata.api.server.util.DatabaseCreator.createDatabase(DatabaseCreator.java:238) > at > org.apache.airavata.api.server.util.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:66) > at > org.apache.airavata.api.server.util.ExperimentCatalogInitUtil.initializeDB(ExperimentCatalogInitUtil.java:81) > at > org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:68) > at > org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202) > at > org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:320) > at > org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:169) > at org.apache.airavata.server.ServerMain.main(ServerMain.java:152) > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE > command denied to user 'airavata'@'localhost' for table 'GATEWAY' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.Util.getInstance(Util.java:408) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) > at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) > at > org.apache.airavata.api.server.util.DatabaseCreator.executeSQL(DatabaseCreator.java:126) > ... 9 more > [ERROR] Server Start Error: > java.lang.RuntimeException: Database failure > at > org.apache.airavata.api.server.util.ExperimentCatalogInitUtil.initializeDB(ExperimentCatalogInitUtil.java:124) > at > org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:68) > at > org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202) > at > org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:320) > at > org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:169) > at org.apache.airavata.server.ServerMain.main(ServerMain.java:152) > Caused by: java.lang.Exception: Error occurred while executing : /* * * > Licensed to the Apache Software Foundation (ASF) under one * or more > contributor license agreements. See the NOTICE file * distributed with this > work for additional information * regarding copyright ownership. The ASF > licenses this file * to you under the Apache License, Version 2.0 (the * > "License"); you may not use this file except in compliance * with the > License. You may obtain a copy of the License at * * > http://www.apache.org/licenses/LICENSE-2.0 > <http://www.apache.org/licenses/LICENSE-2.0> * * Unless required by > applicable law or agreed to in writing, * software distributed under the > License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR > CONDITIONS OF ANY * KIND, either express or implied. See the License for the > * specific language governing permissions and limitations * under the > License. * */ CREATE TABLE GATEWAY ( GATEWAY_ID VARCHAR(255), GATEWAY_NAME > VARCHAR(255), DOMAIN VARCHAR(255), EMAIL_ADDRESS VARCHAR(255), PRIMARY KEY > (GATEWAY_ID) ) > at > org.apache.airavata.api.server.util.DatabaseCreator.executeSQL(DatabaseCreator.java:154) > at > org.apache.airavata.api.server.util.DatabaseCreator.executeSQLScript(DatabaseCreator.java:299) > at > org.apache.airavata.api.server.util.DatabaseCreator.createDatabase(DatabaseCreator.java:238) > at > org.apache.airavata.api.server.util.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:66) > at > org.apache.airavata.api.server.util.ExperimentCatalogInitUtil.initializeDB(ExperimentCatalogInitUtil.java:81) > ... 5 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: CREATE > command denied to user 'airavata'@'localhost' for table 'GATEWAY' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.Util.getInstance(Util.java:408) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) > at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) > at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) > at > org.apache.airavata.api.server.util.DatabaseCreator.executeSQL(DatabaseCreator.java:126) > ... 9 more > [INFO] connected to rabbitmq: amqp://guest@127.0.0.1:5672/ > <http://guest@127.0.0.1:5672/> for airavata_rabbitmq_exchange > [INFO] setting basic.qos / prefetch count to 64 for airavata_rabbitmq_exchange > [INFO] connected to rabbitmq: amqp://guest@127.0.0.1:5672/ > <http://guest@127.0.0.1:5672/> for null > [INFO] setting basic.qos / prefetch count to 64 for null > DriverClassName=com.mysql.jdbc.Driver,Url=jdbc:mysql://localhost:3306/experiment_catalog?autoReconnect=true,Username=airavata,Password=airavata,validationQuery=SELECT > 1 from CONFIGURATION > 694 experiment_data INFO [main] openjpa.Runtime - OpenJPA dynamically > loaded the class enhancer. Any classes that were not enhanced at build time > will be enhanced when they are loaded by the JVM. > 746 experiment_data INFO [main] openjpa.Runtime - Starting OpenJPA 2.2.0 > [ERROR] Cannot create PoolableConnectionFactory (SELECT command denied to > user 'airavata'@'localhost' for table 'CONFIGURATION') > <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102) > at > org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603) > at > org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1510) > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:518) > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:443) > at > org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:104) > at > org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) > at > org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:968) > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:959) > at > org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:638) > at > org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203) > at > org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.getEntityManager(ExpCatResourceUtils.java:69) > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.isGatewayExist(ExpCatResourceUtils.java:221) > at > org.apache.airavata.registry.core.experiment.catalog.impl.ExperimentCatalogImpl.<init>(ExperimentCatalogImpl.java:65) > at > org.apache.airavata.registry.core.experiment.catalog.impl.RegistryFactory.getDefaultExpCatalog(RegistryFactory.java:82) > at > org.apache.airavata.orchestrator.server.OrchestratorServerHandler.<init>(OrchestratorServerHandler.java:109) > at > org.apache.airavata.orchestrator.server.OrchestratorServer.start(OrchestratorServer.java:109) > at > org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:320) > at > org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:169) > at org.apache.airavata.server.ServerMain.main(ServerMain.java:152) > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > at > org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110) > at > org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87) > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91) > ... 24 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT > command denied to user 'airavata'@'localhost' for table 'CONFIGURATION' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.Util.getInstance(Util.java:408) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) > at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369) > at > org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > at > org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558) > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) > ... 29 more > [ERROR] Unable to create experiment catalog instance > org.apache.airavata.registry.cpi.RegistryException: > <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.isGatewayExist(ExpCatResourceUtils.java:232) > at > org.apache.airavata.registry.core.experiment.catalog.impl.ExperimentCatalogImpl.<init>(ExperimentCatalogImpl.java:65) > at > org.apache.airavata.registry.core.experiment.catalog.impl.RegistryFactory.getDefaultExpCatalog(RegistryFactory.java:82) > at > org.apache.airavata.orchestrator.server.OrchestratorServerHandler.<init>(OrchestratorServerHandler.java:109) > at > org.apache.airavata.orchestrator.server.OrchestratorServer.start(OrchestratorServer.java:109) > at > org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:320) > at > org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:169) > at org.apache.airavata.server.ServerMain.main(ServerMain.java:152) > Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102) > at > org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603) > at > org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1510) > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:518) > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:443) > at > org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:104) > at > org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) > at > org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:968) > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:959) > at > org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:638) > at > org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203) > at > org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.getEntityManager(ExpCatResourceUtils.java:69) > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.isGatewayExist(ExpCatResourceUtils.java:221) > ... 7 more > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > at > org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110) > at > org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87) > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91) > ... 24 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT > command denied to user 'airavata'@'localhost' for table 'CONFIGURATION' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.Util.getInstance(Util.java:408) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) > at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369) > at > org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > at > org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558) > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) > ... 29 more > [ERROR] org.apache.airavata.registry.cpi.RegistryException: > <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > org.apache.airavata.registry.cpi.RegistryException: > org.apache.airavata.registry.cpi.RegistryException: > <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.airavata.registry.core.experiment.catalog.impl.RegistryFactory.getDefaultExpCatalog(RegistryFactory.java:86) > at > org.apache.airavata.orchestrator.server.OrchestratorServerHandler.<init>(OrchestratorServerHandler.java:109) > at > org.apache.airavata.orchestrator.server.OrchestratorServer.start(OrchestratorServer.java:109) > at > org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:320) > at > org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:169) > at org.apache.airavata.server.ServerMain.main(ServerMain.java:152) > Caused by: org.apache.airavata.registry.cpi.RegistryException: > <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.isGatewayExist(ExpCatResourceUtils.java:232) > at > org.apache.airavata.registry.core.experiment.catalog.impl.ExperimentCatalogImpl.<init>(ExperimentCatalogImpl.java:65) > at > org.apache.airavata.registry.core.experiment.catalog.impl.RegistryFactory.getDefaultExpCatalog(RegistryFactory.java:82) > ... 5 more > Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102) > at > org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603) > at > org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1510) > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:518) > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:443) > at > org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:104) > at > org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) > at > org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:968) > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:959) > at > org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:638) > at > org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203) > at > org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.getEntityManager(ExpCatResourceUtils.java:69) > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.isGatewayExist(ExpCatResourceUtils.java:221) > ... 7 more > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > at > org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110) > at > org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87) > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91) > ... 24 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT > command denied to user 'airavata'@'localhost' for table 'CONFIGURATION' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.Util.getInstance(Util.java:408) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) > at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369) > at > org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > at > org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558) > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) > ... 29 more > [ERROR] Server Start Error: > org.apache.airavata.orchestrator.core.exception.OrchestratorException: Error > while initializing orchestrator service > at > org.apache.airavata.orchestrator.server.OrchestratorServerHandler.<init>(OrchestratorServerHandler.java:120) > at > org.apache.airavata.orchestrator.server.OrchestratorServer.start(OrchestratorServer.java:109) > at > org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:320) > at > org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:169) > at org.apache.airavata.server.ServerMain.main(ServerMain.java:152) > Caused by: org.apache.airavata.registry.cpi.RegistryException: > org.apache.airavata.registry.cpi.RegistryException: > <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.airavata.registry.core.experiment.catalog.impl.RegistryFactory.getDefaultExpCatalog(RegistryFactory.java:86) > at > org.apache.airavata.orchestrator.server.OrchestratorServerHandler.<init>(OrchestratorServerHandler.java:109) > ... 4 more > Caused by: org.apache.airavata.registry.cpi.RegistryException: > <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.isGatewayExist(ExpCatResourceUtils.java:232) > at > org.apache.airavata.registry.core.experiment.catalog.impl.ExperimentCatalogImpl.<init>(ExperimentCatalogImpl.java:65) > at > org.apache.airavata.registry.core.experiment.catalog.impl.RegistryFactory.getDefaultExpCatalog(RegistryFactory.java:82) > ... 5 more > Caused by: <openjpa-2.2.0-r422266:1244990 fatal general error> > org.apache.openjpa.persistence.PersistenceException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:102) > at > org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl.getDBDictionaryInstance(JDBCConfigurationImpl.java:603) > at > org.apache.openjpa.jdbc.meta.MappingRepository.endConfiguration(MappingRepository.java:1510) > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:518) > at > org.apache.openjpa.lib.conf.Configurations.configureInstance(Configurations.java:443) > at > org.apache.openjpa.lib.conf.PluginValue.instantiate(PluginValue.java:104) > at > org.apache.openjpa.conf.MetaDataRepositoryValue.instantiate(MetaDataRepositoryValue.java:68) > at > org.apache.openjpa.lib.conf.ObjectValue.instantiate(ObjectValue.java:83) > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.newMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:968) > at > org.apache.openjpa.conf.OpenJPAConfigurationImpl.getMetaDataRepositoryInstance(OpenJPAConfigurationImpl.java:959) > at > org.apache.openjpa.kernel.AbstractBrokerFactory.makeReadOnly(AbstractBrokerFactory.java:638) > at > org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:203) > at > org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154) > at > org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60) > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.getEntityManager(ExpCatResourceUtils.java:69) > at > org.apache.airavata.registry.core.experiment.catalog.ExpCatResourceUtils.isGatewayExist(ExpCatResourceUtils.java:221) > ... 7 more > Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (SELECT command denied to user > 'airavata'@'localhost' for table 'CONFIGURATION') > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) > at > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) > at > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) > at > org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:110) > at > org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:87) > at > org.apache.openjpa.jdbc.sql.DBDictionaryFactory.newDBDictionary(DBDictionaryFactory.java:91) > ... 24 more > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT > command denied to user 'airavata'@'localhost' for table 'CONFIGURATION' > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) > at com.mysql.jdbc.Util.getInstance(Util.java:408) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) > at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369) > at > org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > at > org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:658) > at > org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1558) > at > org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) > ... 29 more > [INFO] Starting > [INFO] State change: CONNECTED > [INFO] connected to rabbitmq: amqp://guest@127.0.0.1:5672/ > <http://guest@127.0.0.1:5672/> for airavata_task_launch_rabbitmq_exchange > [INFO] connected to rabbitmq: amqp://guest@127.0.0.1:5672/ > <http://guest@127.0.0.1:5672/> for airavata_rabbitmq_exchange > [INFO] setting basic.qos / prefetch count to 64 for airavata_rabbitmq_exchange > [INFO] Started Gfac Server on Port 8950 ... > > > > Regards, > Damith Wijethunge. > > > On Fri, Jan 6, 2017 at 8:32 PM, Suresh Marru <sma...@apache.org > <mailto:sma...@apache.org>> wrote: > Hi Damith, > > Good to see your interest. A good first place to start will be to install > Airavata and start getting familiar with the software - > http://airavata.readthedocs.io/en/latest/ > <http://airavata.readthedocs.io/en/latest/> > > The current documentation overall is very sparse across wiki, website and > readthedocs. Do not hesitate to ask questions on the mailing lists is > anything is not clear. In the next few months we plan to work on clear and > concise getting started guides for contributors. You can probably contribute > by initiating such as a document - essentially capturing what you learn. > > Cheers, > Suresh > >> On Jan 6, 2017, at 7:26 AM, Damith Dilshan <ddrwijethu...@gmail.com >> <mailto:ddrwijethu...@gmail.com>> wrote: >> >> Hi, >> I am an undergraduate of University of Moratuwa, Sri Lanka, currently on the >> 4th year of the degree program. >> I got to know about the project airavata and it seems very interesting and i >> would like to know the process to get started on contributing to the project >> and also I would like to continue to contribute to it as a GSOC project in >> the future if possible. >> >> Regards, >> Damith Wijethunge. > >
