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 * * 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 * * 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 * * 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/ 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/ 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/ for airavata_task_launch_rabbitmq_exchange [INFO] connected to rabbitmq: amqp://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> 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/ > > 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> > 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. > > >
