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> 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> 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 > > <https://markmail.org/message/oojdzfmczss2gepr?q=Airavata+database+connection+error+while+starting> > > Regards, > Vivek. > > From: "Narvekar, Bhakti Sunil" <bhn...@iu.edu> > Reply-To: "dev@airavata.apache.org" <dev@airavata.apache.org> > Date: Wednesday, May 13, 2020 at 11:52 AM > To: "dev@airavata.apache.org" <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> 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 >
