Hi,
I'm trying to run Airavata on my mac. I facing following issue while
running the server. It seems like a database connection issue. Any help
would be appreciated. I have built the project. Docker composer is running
all the services are up. I followed the instructions from this
<https://cwiki.apache.org/confluence/display/AIRAVATA/Setup+your+local+Airavata+Development+Environment>
.
Java : 14
macOs : 10.14.6
maven. : 3.6.3
*>>>>> mvn exec:java
-Dexec.mainClass="org.apache.airavata.ide.integration.APIServerStarter" *
*java.lang.RuntimeException*: *Failed to initialize database for
database_scripts/expcatalog*
*at* org.apache.airavata.common.utils.DBInitializer.initializeDB (
*DBInitializer.java:63*)
*at* org.apache.airavata.common.utils.DBInitializer.initializeDB (
*DBInitializer.java:45*)
*at*
org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer
(*RegistryAPIServer.java:69*)
*at* org.apache.airavata.registry.api.service.RegistryAPIServer.start (
*RegistryAPIServer.java:151*)
*at* org.apache.airavata.ide.integration.APIServerStarter.main (
*APIServerStarter.java:23*)
*at* jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 (*Native
Method*)
*at* jdk.internal.reflect.NativeMethodAccessorImpl.invoke (
*NativeMethodAccessorImpl.java:62*)
*at* jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke (
*DelegatingMethodAccessorImpl.java:43*)
*at* java.lang.reflect.Method.invoke (*Method.java:567*)
*at* org.codehaus.mojo.exec.ExecJavaMojo$1.run (*ExecJavaMojo.java:282*)
*at* java.lang.Thread.run (*Thread.java:830*)
*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),
GATEWAY_ACRONYM varchar(255), GATEWAY_ADMIN_EMAIL varchar(255),
GATEWAY_ADMIN_FIRST_NAME varchar(255), GATEWAY_APPROVAL_STATUS
varchar(255), GATEWAY_PUBLIC_ABSTRACT varchar(255), GATEWAY_URL
varchar(255), GATEWAY_ADMIN_LAST_NAME varchar(255),
IDENTITY_SERVER_PASSWORD_TOKEN varchar(255), IDENTITY_SERVER_USERNAME
varchar(255), GATEWAY_REVIEW_PROPOSAL_DESCRIPTION varchar(255),
DECLINED_REASON varchar(255), OAUTH_CLIENT_SECRET varchar(255),
OAUTH_CLIENT_ID varchar(255), REQUEST_CREATION_TIME TIMESTAMP DEFAULT
CURRENT_TIMESTAMP, REQUESTER_USERNAME VARCHAR(255), PRIMARY KEY
(GATEWAY_ID) )ENGINE=InnoDB DEFAULT CHARSET=latin1*
*at* org.apache.airavata.common.utils.DatabaseCreator.executeSQL (
*DatabaseCreator.java:160*)
*at* org.apache.airavata.common.utils.DatabaseCreator.executeSQLScript (
*DatabaseCreator.java:303*)
*at* org.apache.airavata.common.utils.DatabaseCreator.createDatabase (
*DatabaseCreator.java:244*)
*at* org.apache.airavata.common.utils.DatabaseCreator.createRegistryDatabase
(*DatabaseCreator.java:72*)
*at* org.apache.airavata.common.utils.DBInitializer.initializeDB (
*DBInitializer.java:56*)
*at* org.apache.airavata.common.utils.DBInitializer.initializeDB (
*DBInitializer.java:45*)
*at*
org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer
(*RegistryAPIServer.java:69*)
*at* org.apache.airavata.registry.api.service.RegistryAPIServer.start (
*RegistryAPIServer.java:151*)
*at* org.apache.airavata.ide.integration.APIServerStarter.main (
*APIServerStarter.java:23*)
*at* jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 (*Native
Method*)
*at* jdk.internal.reflect.NativeMethodAccessorImpl.invoke (
*NativeMethodAccessorImpl.java:62*)
*at* jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke (
*DelegatingMethodAccessorImpl.java:43*)
*at* java.lang.reflect.Method.invoke (*Method.java:567*)
*at* org.codehaus.mojo.exec.ExecJavaMojo$1.run (*ExecJavaMojo.java:282*)
*at* java.lang.Thread.run (*Thread.java:830*)
*Caused by*: java.sql.SQLSyntaxErrorException: *(conn:2) Table
'experiment_catalog.GATEWAY' doesn't exist*
*at* org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get (
*ExceptionMapper.java:158*)
*at* org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException
(*ExceptionMapper.java:118*)
*at* org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue (
*MariaDbStatement.java:245*)
*at* org.mariadb.jdbc.MariaDbStatement.executeInternal (
*MariaDbStatement.java:343*)
*at* org.mariadb.jdbc.MariaDbStatement.execute (
*MariaDbStatement.java:394*)
*at* org.apache.airavata.common.utils.DatabaseCreator.executeSQL (
*DatabaseCreator.java:132*)
*at* org.apache.airavata.common.utils.DatabaseCreator.executeSQLScript (
*DatabaseCreator.java:303*)
*at* org.apache.airavata.common.utils.DatabaseCreator.createDatabase (
*DatabaseCreator.java:244*)
*at* org.apache.airavata.common.utils.DatabaseCreator.createRegistryDatabase
(*DatabaseCreator.java:72*)
*at* org.apache.airavata.common.utils.DBInitializer.initializeDB (
*DBInitializer.java:56*)
*at* org.apache.airavata.common.utils.DBInitializer.initializeDB (
*DBInitializer.java:45*)
*at*
org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer
(*RegistryAPIServer.java:69*)
*at* org.apache.airavata.registry.api.service.RegistryAPIServer.start (
*RegistryAPIServer.java:151*)
*at* org.apache.airavata.ide.integration.APIServerStarter.main (
*APIServerStarter.java:23*)
*at* jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 (*Native
Method*)
*at* jdk.internal.reflect.NativeMethodAccessorImpl.invoke (
*NativeMethodAccessorImpl.java:62*)
*at* jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke (
*DelegatingMethodAccessorImpl.java:43*)
*at* java.lang.reflect.Method.invoke (*Method.java:567*)
*at* org.codehaus.mojo.exec.ExecJavaMojo$1.run (*ExecJavaMojo.java:282*)
*at* java.lang.Thread.run (*Thread.java:830*)
*Caused by*: java.sql.SQLException: *Table 'experiment_catalog.GATEWAY'
doesn't exist*
*Query is: /* * * 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),
GATEWAY_ACRONYM varchar(255), GATEWAY_ADMIN_EMAIL varchar(255),
GATEWAY_ADMIN_FIRST_NAME varchar(255...*
*at* org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery (
*LogQueryTool.java:113*)
*at* org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery
(*AbstractQueryProtocol.java:168*)
*at* org.mariadb.jdbc.MariaDbStatement.executeInternal (
*MariaDbStatement.java:337*)
*at* org.mariadb.jdbc.MariaDbStatement.execute (
*MariaDbStatement.java:394*)
*at* org.apache.airavata.common.utils.DatabaseCreator.executeSQL (
*DatabaseCreator.java:132*)
*at* org.apache.airavata.common.utils.DatabaseCreator.executeSQLScript (
*DatabaseCreator.java:303*)
*at* org.apache.airavata.common.utils.DatabaseCreator.createDatabase (
*DatabaseCreator.java:244*)
*at* org.apache.airavata.common.utils.DatabaseCreator.createRegistryDatabase
(*DatabaseCreator.java:72*)
*at* org.apache.airavata.common.utils.DBInitializer.initializeDB (
*DBInitializer.java:56*)
*at* org.apache.airavata.common.utils.DBInitializer.initializeDB (
*DBInitializer.java:45*)
*at*
org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer
(*RegistryAPIServer.java:69*)
*at* org.apache.airavata.registry.api.service.RegistryAPIServer.start (
*RegistryAPIServer.java:151*)
*at* org.apache.airavata.ide.integration.APIServerStarter.main (
*APIServerStarter.java:23*)
*at* jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 (*Native
Method*)
*at* jdk.internal.reflect.NativeMethodAccessorImpl.invoke (
*NativeMethodAccessorImpl.java:62*)
*at* jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke (
*DelegatingMethodAccessorImpl.java:43*)
*at* java.lang.reflect.Method.invoke (*Method.java:567*)
*at* org.codehaus.mojo.exec.ExecJavaMojo$1.run (*ExecJavaMojo.java:282*)
*at* java.lang.Thread.run (*Thread.java:830*)
Regards,
Dinuka
