Hi Marcus, Sorry for the delayed response.
I followed the following steps: 1. npm install -g npm-windows-upgrade 2. npm-windows-upgrade 3. docker-compose down 4. docker-compose rm 5. Created a new user and grant all permission to that user (followed -> https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql) Thanks, Bhakti From: Narvekar, Bhakti Sunil<mailto:bhn...@iu.edu> Sent: Wednesday, May 20, 2020 7:56 PM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: RE: [External] Airavata database connection issue Hi Marcus, Thank you for the help. The issue was resolved last week. Thanks, Bhakti From: Christie, Marcus Aaron<mailto:machr...@iu.edu> Sent: Wednesday, May 20, 2020 5:24 PM To: Airavata Dev<mailto:dev@airavata.apache.org> Subject: Re: [External] Airavata database connection issue Hi Bhakti, I have had issues with the mysql server started by docker-compose and it appears that the docker image got corrupted somehow. I was able to fix it by deleting and redownloading the image which I did by doing docker-composer down docker-compose rm docker system prune --all Thanks, Marcus On May 15, 2020, at 7:02 PM, Narvekar, Bhakti Sunil <bhn...@iu.edu<mailto:bhn...@iu.edu>> wrote: Hi Professor, Thank you for the response. I did search on StackOverFlow and other websites and tried changing the version of MariaDB in pom.xml but doing this did not resolve the issue. I will try connecting the database container externally. Thanks. Sincerely, Bhakti From: Suresh Marru<mailto:sma...@apache.org> Sent: Friday, May 15, 2020 4:32 PM To: Airavata Dev<mailto:dev@airavata.apache.org> Subject: Re: [External] Airavata database connection issue Hi Bhakti, Looks like your issues are generic port and database. May be you should search for issues on stack overflow and places like that. The error message is clear, the service externally is unable to connect to the database. So you may want to ignore airavata for a while and try to connect to the database container (externally) and verify before you switch back to bring up airavata services. Suresh On May 14, 2020, at 11:49 PM, Narvekar, Bhakti Sunil <bhn...@iu.edu<mailto:bhn...@iu.edu>> wrote: Hi, I’m still not able to resolve this issue. It would be great if someone can help me out. Thanks. Sincerely, Bhakti From: Narvekar, Bhakti Sunil<mailto:bhn...@iu.edu> Sent: Wednesday, May 13, 2020 4:14 PM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: RE: [External] Re: Airavata database connection issue Hi Aarushi, I tried stopping the local MySQL instance and also I tried uninstalling the instance as well but I’m still facing the same issue. All the containers are up but now I’m not able to access localhost:13306 as well. I have attached the StackTrace and logs for MySQL. Thanks, Bhakti From: Bisht, Aarushi<mailto:abi...@iu.edu> Sent: Wednesday, May 13, 2020 3:45 PM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: RE: [External] Re: Airavata database connection issue Hi Bhakti, Since you have a local mysql instance running that is why you are able to connect to localhost 13306. Can you try to stop the mysql instance running locally and only start the docker containers. If the container has successfully started mysql should be available on localhost:3306. You can see all the running containers using docker-compose ps. Thanks, Aarushi Bisht On May 13, 2020 1:03 PM, "Narvekar, Bhakti Sunil" <bhn...@iu.edu<mailto:bhn...@iu.edu>> wrote: Hi Vivek, I feel this is a different issue. I have attached the StackTrace as well. Please let me know if you think it is similar. Thanks, Bhakti From: Bandaru, Vivek Shresta<mailto:vivb...@iu.edu> Sent: Wednesday, May 13, 2020 12:04 PM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: Re: [External] Re: Airavata database connection issue Hi Bhakti, This looks very similar to the database connection error a couple of us faced few weeks ago. Without the full stacktrace I can’t say for sure, but you can try the fix mentioned in this mail: https://markmail.org/message/oojdzfmczss2gepr?q=Airavata+database+connection+error+while+starting Regards, Vivek. From: "Narvekar, Bhakti Sunil" <bhn...@iu.edu<mailto:bhn...@iu.edu>> Reply-To: "dev@airavata.apache.org<mailto:dev@airavata.apache.org>" <dev@airavata.apache.org<mailto:dev@airavata.apache.org>> Date: Wednesday, May 13, 2020 at 11:52 AM To: "dev@airavata.apache.org<mailto:dev@airavata.apache.org>" <dev@airavata.apache.org<mailto:dev@airavata.apache.org>> Subject: RE: [External] Re: Airavata database connection issue Hi Aarushi, The services are up and running. I have attached the screenshots for the same. The localhost:13306 is reachable but localhost:3306 is not. I have attached the result of the telnet for both the ports 3306 and 13306. Also, I have MySQL server installed on my local machine, would that be an issue. Thanks & Regards, Bhakti Narvekar From: Bisht, Aarushi<mailto:abi...@iu.edu> Sent: Wednesday, May 13, 2020 4:15 AM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: RE: [External] Re: Airavata database connection issue Hi Bhakti, From the logs it seems you are not able to connect to database on localhost: 13306. Make sure db container is up and running. Try using nc or some other command to make sure that you are able to connect to this port. - Aarushi Bisht On May 13, 2020 12:05 AM, "Narvekar, Bhakti Sunil" <bhn...@iu.edu<mailto:bhn...@iu.edu>> wrote: Hi Akhil, Yes, I tried deleting the ide-integration/resources/database_data folder, stopping all the services, and restarting them again. But I'm still facing this issue. Regards, Bhakti From: akhil nagulavancha<mailto:akhilnl...@gmail.com> Sent: Tuesday, May 12, 2020 9:43 PM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: [External] Re: Airavata database connection issue This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources. Hi Bhakti , Did you try the note mentioned in start airavata server step of cwiki ? It has helped me to solve a similar database related error. Regards Akhil On Tue, May 12, 2020 at 8:41 PM Narvekar, Bhakti Sunil <bhn...@iu.edu<mailto:bhn...@iu.edu>> wrote: Hi, On starting APIServerStarter, I ran into an exception - SQLNonTransientConnectionException. I have attached the StackTrace and database logs. Could anyone please help me with this issue. Thanks & Regards, Bhakti Narvekar
