airavata-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Damith Dilshan <ddrwijethu...@gmail.com>
Subject Re: Contributing to airavata
Date Mon, 23 Jan 2017 03:58:36 GMT
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 <smarru@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 <ddrwijethunge@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.
>
>
>

Mime
View raw message