Hi Nayeem,
This is actually 1 error. Initialization of database is failing because '172.18.0.1' does not have access to connect to Mysql Server. This is a permission issue which might have been caused by the change in permission you did to solve the previous issue. Can you connect to your running sql container and run 'SELECT host, user FROM mysql.user;'. You should have host = '%' for user root and airavata, which means every IP is allowed for these users. You can refer this thread<https://github.com/docker-library/mysql/issues/275> for more info.? - Aarushi Bisht ________________________________ From: Nayeemullah Baig <[email protected]> Sent: Monday, March 30, 2020 2:57 PM To: [email protected] Subject: Re: [External] Airavata database connection error while starting Hi Aarushi, I followed the steps which were updated on the wiki. mysql is currently running, I have attached the log as well. But I'm now getting two errors. 1. Exception in thread "main" java.lang.RuntimeException: Failed to initialize database for database_scripts/expcatalog 2. Caused by: java.sql.SQLException: Host '172.18.0.1' is not allowed to connect to this MySQL server. A few things which I had to do additionally, after restarting the db docker, the database_data owner was 'systemd-coredump', that was the reason I got the permission denied error previously, I changed the owner of the directory and subdirectories and files using ' sudo chown -R kubeadmin:kubeadmin database_data/ ' Any help would be appreciated. Thanks, Nayeem On Sun, Mar 29, 2020 at 1:57 AM Bisht, Aarushi <[email protected]<mailto:[email protected]>> wrote: Hi Nayeem, Since a lot of you are facing the same database issue, I have added a note to the cwiki<https://cwiki.apache.org/confluence/display/AIRAVATA/Setup+your+local+Airavata+Development+Environment>. If you are still facing the issue, send us the logs of the db container and we can try to debug the issue. You can also verify the initialized databases by connecting to the database using the following command(credentials can be found in docker-compose.yml file): docker exec -it <container name> mysql -u root -p - Aarushi Bisht ________________________________ From: Nayeemullah Baig <[email protected]<mailto:[email protected]>> Sent: Sunday, March 29, 2020 1:00 AM To: [email protected]<mailto:[email protected]> Subject: [External] Airavata database connection error while starting This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources. Hi, While starting Airavata, I run into the following database connection error. Attached the screenshot and error message. Thanks, Nayeem.
