You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@airavata.apache.org by Dinuka Desilva <l....@gmail.com> on 2020/03/26 04:49:09 UTC
[Airavata][macOS] Failed to initialize database for database_scripts/expcatalog
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
Re: [External] [Airavata][macOS] Failed to initialize database for
database_scripts/expcatalog
Posted by "Bisht, Aarushi" <ab...@iu.edu>.
Hi Dinuka,
Glad that you were able to resolve the issue. You can also refer the github<https://github.com/apache/airavata-django-portal> page of airavata django portal for detailed instructions (https://github.com/apache/airavata-django-portal).
Regards,
Aarushi Bisht
________________________________
From: Dinuka Desilva <l....@gmail.com>
Sent: Thursday, March 26, 2020 5:44 PM
To: Bisht, Aarushi; users@airavata.apache.org
Subject: Re: [External] [Airavata][macOS] Failed to initialize database for database_scripts/expcatalog
Hi Aarushi,
It was because I had missed following step before running the portal.
python manage.py load_default_gateway
Now, It works and thank you.
Regards,
Dinuka
On Fri, Mar 27, 2020 at 2:36 AM Dinuka Desilva <l....@gmail.com>> wrote:
Hi Aarushi,
Thank you very much. It works now.
Actually, what I'm trying to do is getting both Airavata server and portal running. Now, I have both of them running. But, following the instructions in this<https://cwiki.apache.org/confluence/display/AIRAVATA/Setup+your+local+Airavata+Development+Environment>., still I couldn't get the two connected. I think I have missed something in the settings file in the portal. I actually used the sample settings file and didn't make any edits. Can you help me.
When I browse to the local server and try to login with default-admin and password : 123456, I'm stuck on following screen and neither signup works.
[Screenshot 2020-03-27 at 2.35.24 AM.png]
[Screenshot 2020-03-27 at 2.35.38 AM.png]
Regards,
Dinuka
On Fri, Mar 27, 2020 at 1:08 AM Bisht, Aarushi <ab...@iu.edu>> wrote:
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 <l....@gmail.com>>
Sent: Thursday, March 26, 2020 12:49 AM
To: users@airavata.apache.org<ma...@airavata.apache.org>
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
Re: [External] [Airavata][macOS] Failed to initialize database for database_scripts/expcatalog
Posted by Dinuka Desilva <l....@gmail.com>.
Hi Aarushi,
It was because I had missed following step before running the portal.
python manage.py load_default_gateway
Now, It works and thank you.
Regards,
Dinuka
On Fri, Mar 27, 2020 at 2:36 AM Dinuka Desilva <l....@gmail.com>
wrote:
> Hi Aarushi,
>
> Thank you very much. It works now.
>
> Actually, what I'm trying to do is getting both Airavata server and portal
> running. Now, I have both of them running. But, following the instructions
> in this
> <https://cwiki.apache.org/confluence/display/AIRAVATA/Setup+your+local+Airavata+Development+Environment>
> ., still I couldn't get the two connected. I think I have missed
> something in the settings file in the portal. I actually used the sample
> settings file and didn't make any edits. Can you help me.
>
> When I browse to the local server and try to login with default-admin and
> password : 123456, I'm stuck on following screen and neither signup works.
>
> [image: Screenshot 2020-03-27 at 2.35.24 AM.png]
>
>
> [image: Screenshot 2020-03-27 at 2.35.38 AM.png]
>
> Regards,
> Dinuka
>
> On Fri, Mar 27, 2020 at 1:08 AM Bisht, Aarushi <ab...@iu.edu> wrote:
>
>> 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 <l....@gmail.com>
>> *Sent:* Thursday, March 26, 2020 12:49 AM
>> *To:* users@airavata.apache.org
>> *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
>> <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
>>
>
Re: [External] [Airavata][macOS] Failed to initialize database for database_scripts/expcatalog
Posted by Dinuka Desilva <l....@gmail.com>.
Hi Aarushi,
Thank you very much. It works now.
Actually, what I'm trying to do is getting both Airavata server and portal
running. Now, I have both of them running. But, following the instructions
in this
<https://cwiki.apache.org/confluence/display/AIRAVATA/Setup+your+local+Airavata+Development+Environment>
., still I couldn't get the two connected. I think I have missed something
in the settings file in the portal. I actually used the sample settings
file and didn't make any edits. Can you help me.
When I browse to the local server and try to login with default-admin and
password : 123456, I'm stuck on following screen and neither signup works.
[image: Screenshot 2020-03-27 at 2.35.24 AM.png]
[image: Screenshot 2020-03-27 at 2.35.38 AM.png]
Regards,
Dinuka
On Fri, Mar 27, 2020 at 1:08 AM Bisht, Aarushi <ab...@iu.edu> wrote:
> 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 <l....@gmail.com>
> *Sent:* Thursday, March 26, 2020 12:49 AM
> *To:* users@airavata.apache.org
> *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
> <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
>
Re: [External] [Airavata][macOS] Failed to initialize database for
database_scripts/expcatalog
Posted by "Bisht, Aarushi" <ab...@iu.edu>.
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 <l....@gmail.com>
Sent: Thursday, March 26, 2020 12:49 AM
To: users@airavata.apache.org
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