airavata-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suresh Marru <sma...@apache.org>
Subject Re: Contributing to airavata
Date Mon, 23 Jan 2017 04:02:46 GMT
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 <ddrwijethunge@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 <smarru@apache.org <mailto: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/ <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 <mailto: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