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:[email protected]> Sent: Wednesday, May 13, 2020 3:45 PM To: [email protected]<mailto:[email protected]> 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" <[email protected]> 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:[email protected]> Sent: Wednesday, May 13, 2020 12:04 PM To: [email protected]<mailto:[email protected]> 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" <[email protected]> Reply-To: "[email protected]" <[email protected]> Date: Wednesday, May 13, 2020 at 11:52 AM To: "[email protected]" <[email protected]> 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:[email protected]> Sent: Wednesday, May 13, 2020 4:15 AM To: [email protected]<mailto:[email protected]> 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" <[email protected]> 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:[email protected]> Sent: Tuesday, May 12, 2020 9:43 PM To: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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
stacktrace
Description: stacktrace
logs
Description: logs
