Hi Dinuka, From the logs that you posted in the email, I can see that the sql database has not been initialized correctly. As you mentioned that you have verified that all the docker services are up, make sure db service is also up. Next check if database_data has been created in resources folder in ide-integration. I would suggest you to make all docker services down first, then delete database_data folder and again try making the services up.
Let me know if this solves the issue. If this does not work can you please post a screenshot of database_data folder and I'll be able to guide you further. Regards, Aarushi Bisht ________________________________ From: Dinuka Desilva <[email protected]> Sent: Thursday, March 26, 2020 12:49 AM To: [email protected] Subject: [External] [Airavata][macOS] Failed to initialize database for database_scripts/expcatalog This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources. 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 * * 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 * * 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
