Hi Keerthi, Please make sure that in airavata/dev-tools/ansible/inventories/standalone/group_vars/all/vars.yml, db_server is set to localhost [1].
[1] https://docs.google.com/document/d/19anefh_IOrzXKlumyq6xcdBLfU01ReJTocixwsDBgus/edit#heading=h.oiadzzlle10s > On Mar 13, 2019, at 1:37 AM, Keerthi N <keerthi4...@gmail.com> wrote: > > Hello Suresh, > > I will try to be more precise as I'm learning to interpret the logs. From the > error message, I noticed that it couldn't instantiate Airavata client and as > a result I verified open ports and keycloak url is working and there are no > errors in keycloak logs as well. Is there something else I could do to > resolve this? > > Apart from that I checked airavata.logs in > pga/master-deployment/api-orchestrator/logs. There is an error issue > database couldn't be initialized (for all > experment_catalog,profile_service,credential_store...) and so airavata server > isn't up. Where exactly should make changes so that permission is granted or > fix the issue? > > 2019-03-12 19:16:39,529 [main] ERROR o.a.airavata.server.ServerMain - Server > Start Error: > 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.server.ServerMain.startAllServers(ServerMain.java:372) > at > org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:221) > at org.apache.airavata.server.ServerMain.main(ServerMain.java:206) > Caused by: java.sql.SQLSyntaxErrorException: Could not connect: Access denied > for user 'airavata'@'192.168.56.2' to database 'experiment_catalog' > > Thanks, > Keerthi > > On Tue, Mar 12, 2019 at 11:59 PM Suresh Marru <sma...@apache.org > <mailto:sma...@apache.org>> wrote: > Hi Sai. Keerthi, > > I would like to request you to improve error messages. It could be messages > like “Unable to instantiate Airavata IamAdminServices Client” indicate to us > few developers that it is related to a connection issue with IAM service and > we immediately look for if IAM service is up. I would like to understand what > impression did this error message give you and what alternative message would > have set you on a correct path to debug. > > Suresh > >> On Mar 12, 2019, at 11:25 PM, Keerthi N <keerthi4...@gmail.com >> <mailto:keerthi4...@gmail.com>> wrote: >> >> Hello, >> >> A few days back I almost reported about the same issue and Marcus suggested >> me to try #5 troubleshooting steps (from installation guide), "ps wwwaux | >> grep api-orch", ip address and port, but the issue wasn't resolved. So I >> would like share my laravel.log file as well. >> >> Thanks, >> Keerthi >> >> [2019-02-20 14:40:56] production.DEBUG: Theme has no landingpage view, will >> render standard home page ["View [views.landingpage] not found."] [] >> [2019-02-20 14:41:33] production.DEBUG: Theme has no landingpage view, will >> render standard home page ["View [views.landingpage] not found."] [] >> [2019-02-20 14:41:46] production.DEBUG: Keycloak userinfo ["[object] >> (stdClass: >> {\"sub\":\"7a51236e-4cbf-468f-9e46-86a409addf42\",\"name\":\"keerthi >> n\",\"preferred_username\":\"default-admin\",\"given_name\":\"keerthi\",\"family_name\":\"n\",\"email\":\"knare...@iu.edu >> <mailto:knare...@iu.edu>\"})"] [] >> [2019-02-20 14:41:46] production.ERROR: Airavata is down! >> {"exception":"[object] (Exception(code: 0): Unable to instantiate Airavata >> Client at >> /var/www/portals/default/app/libraries/Airavata/AiravataServiceProvider.php:54, >> Thrift\\Exception\\TException(code: 0): TSocket: Could not connect to >> tls://192.168.56.2:9930 <http://192.168.56.2:9930/> (Connection refused >> [111]) at >> /var/www/portals/default/app/libraries/Thrift/Transport/TSocket.php:235)"} [] >> [2019-02-20 14:41:46] production.DEBUG: Theme has no landingpage view, will >> render standard home page ["View [views.landingpage] not found."] [] >> [2019-02-20 14:43:01] production.ERROR: exception >> 'Thrift\Exception\TException' with message 'TSocket: Could not connect to >> 192.168.56.2:8962 <http://192.168.56.2:8962/> (Connection refused [111])' in >> /var/www/portals/default/app/libraries/Thrift/Transport/TSocket.php:235 >> Stack trace: >> #0 >> /var/www/portals/default/app/libraries/Airavata/IamAdminServiceProvider.php(52): >> Thrift\Transport\TSocket->open() >> #1 /var/www/portals/default/bootstrap/compiled.php(120): >> Airavata\IamAdminServiceProvider->Airavata\{closure}(Object(Illuminate\Foundation\Application)) >> #2 /var/www/portals/default/bootstrap/compiled.php(233): >> Illuminate\Container\Container->Illuminate\Container\{closure}(Object(Illuminate\Foundation\Application), >> Array) >> #3 /var/www/portals/default/bootstrap/compiled.php(205): >> Illuminate\Container\Container->build(Object(Closure), Array) >> #4 /var/www/portals/default/bootstrap/compiled.php(565): >> Illuminate\Container\Container->make('iam_admin_servi...', Array) >> #5 /var/www/portals/default/bootstrap/compiled.php(353): >> Illuminate\Foundation\Application->make('iam_admin_servi...') >> #6 /var/www/portals/default/bootstrap/compiled.php(1425): >> Illuminate\Container\Container->offsetGet('iam_admin_servi...') >> #7 /var/www/portals/default/bootstrap/compiled.php(1411): >> Illuminate\Support\Facades\Facade::resolveFacadeInstance('iam_admin_servi...') >> #8 /var/www/portals/default/bootstrap/compiled.php(1445): >> Illuminate\Support\Facades\Facade::getFacadeRoot() >> #9 /var/www/portals/default/app/libraries/IamAdminServicesUtilities.php(9): >> Illuminate\Support\Facades\Facade::__callStatic('registerUser', Array) >> #10 /var/www/portals/default/app/libraries/IamAdminServicesUtilities.php(9): >> Airavata\Facades\IamAdminServices::registerUser(Object(Airavata\Model\Security\AuthzToken), >> 'knaredla', 'knare...@iu.edu <mailto:knare...@iu.edu>', 'keerthi', >> 'naredla', 'Gateway@98') >> #11 /var/www/portals/default/app/controllers/AccountController.php(60): >> IamAdminServicesUtilities::registerUser('knaredla', 'knare...@iu.edu >> <mailto:knare...@iu.edu>', 'keerthi', 'naredla', 'Gateway@98') >> #12 [internal function]: AccountController->createAccountSubmit() >> #13 >> /var/www/portals/default/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): >> call_user_func_array(Array, Array) >> #14 /var/www/portals/default/bootstrap/compiled.php(3819): >> Illuminate\Routing\Controller->callAction('createAccountSu...', Array) >> #15 /var/www/portals/default/bootstrap/compiled.php(3807): >> Illuminate\Routing\ControllerDispatcher->call(Object(AccountController), >> Object(Illuminate\Routing\Route), 'createAccountSu...') >> #16 /var/www/portals/default/bootstrap/compiled.php(3012): >> Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), >> Object(Illuminate\Http\Request), 'AccountControll...', 'createAccountSu...') >> #17 [internal function]: >> Illuminate\Routing\Router->Illuminate\Routing\{closure}() >> #18 /var/www/portals/default/bootstrap/compiled.php(3370): >> call_user_func_array(Object(Closure), Array) >> #19 /var/www/portals/default/bootstrap/compiled.php(3037): >> Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) >> #20 /var/www/portals/default/bootstrap/compiled.php(3025): >> Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) >> #21 /var/www/portals/default/bootstrap/compiled.php(702): >> Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) >> #22 /var/www/portals/default/bootstrap/compiled.php(678): >> Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) >> #23 /var/www/portals/default/bootstrap/compiled.php(5797): >> Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), >> 1, true) >> #24 /var/www/portals/default/bootstrap/compiled.php(6404): >> Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, >> true) >> #25 /var/www/portals/default/bootstrap/compiled.php(6351): >> Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) >> #26 /var/www/portals/default/bootstrap/compiled.php(8430): >> Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) >> #27 /var/www/portals/default/bootstrap/compiled.php(639): >> Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) >> #28 /var/www/portals/default/public/index.php(51): >> Illuminate\Foundation\Application->run() >> #29 {main} >> >> Next exception 'Exception' with message 'Unable to instantiate Airavata >> IamAdminServices Client' in >> /var/www/portals/default/app/libraries/Airavata/IamAdminServiceProvider.php:57 >> Stack trace: >> #0 /var/www/portals/default/bootstrap/compiled.php(120): >> Airavata\IamAdminServiceProvider->Airavata\{closure}(Object(Illuminate\Foundation\Application)) >> #1 /var/www/portals/default/bootstrap/compiled.php(233): >> Illuminate\Container\Container->Illuminate\Container\{closure}(Object(Illuminate\Foundation\Application), >> Array) >> #2 /var/www/portals/default/bootstrap/compiled.php(205): >> Illuminate\Container\Container->build(Object(Closure), Array) >> #3 /var/www/portals/default/bootstrap/compiled.php(565): >> Illuminate\Container\Container->make('iam_admin_servi...', Array) >> #4 /var/www/portals/default/bootstrap/compiled.php(353): >> Illuminate\Foundation\Application->make('iam_admin_servi...') >> #5 /var/www/portals/default/bootstrap/compiled.php(1425): >> Illuminate\Container\Container->offsetGet('iam_admin_servi...') >> #6 /var/www/portals/default/bootstrap/compiled.php(1411): >> Illuminate\Support\Facades\Facade::resolveFacadeInstance('iam_admin_servi...') >> #7 /var/www/portals/default/bootstrap/compiled.php(1445): >> Illuminate\Support\Facades\Facade::getFacadeRoot() >> #8 /var/www/portals/default/app/libraries/IamAdminServicesUtilities.php(9): >> Illuminate\Support\Facades\Facade::__callStatic('registerUser', Array) >> #9 /var/www/portals/default/app/libraries/IamAdminServicesUtilities.php(9): >> Airavata\Facades\IamAdminServices::registerUser(Object(Airavata\Model\Security\AuthzToken), >> 'knaredla', 'knare...@iu.edu <mailto:knare...@iu.edu>', 'keerthi', >> 'naredla', 'Gateway@98') >> #10 /var/www/portals/default/app/controllers/AccountController.php(60): >> IamAdminServicesUtilities::registerUser('knaredla', 'knare...@iu.edu >> <mailto:knare...@iu.edu>', 'keerthi', 'naredla', 'Gateway@98') >> #11 [internal function]: AccountController->createAccountSubmit() >> #12 >> /var/www/portals/default/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): >> call_user_func_array(Array, Array) >> #13 /var/www/portals/default/bootstrap/compiled.php(3819): >> Illuminate\Routing\Controller->callAction('createAccountSu...', Array) >> #14 /var/www/portals/default/bootstrap/compiled.php(3807): >> Illuminate\Routing\ControllerDispatcher->call(Object(AccountController), >> Object(Illuminate\Routing\Route), 'createAccountSu...') >> #15 /var/www/portals/default/bootstrap/compiled.php(3012): >> Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), >> Object(Illuminate\Http\Request), 'AccountControll...', 'createAccountSu...') >> #16 [internal function]: >> Illuminate\Routing\Router->Illuminate\Routing\{closure}() >> #17 /var/www/portals/default/bootstrap/compiled.php(3370): >> call_user_func_array(Object(Closure), Array) >> #18 /var/www/portals/default/bootstrap/compiled.php(3037): >> Illuminate\Routing\Route->run(Object(Illuminate\Http\Request)) >> #19 /var/www/portals/default/bootstrap/compiled.php(3025): >> Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) >> #20 /var/www/portals/default/bootstrap/compiled.php(702): >> Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) >> #21 /var/www/portals/default/bootstrap/compiled.php(678): >> Illuminate\Foundation\Application->dispatch(Object(Illuminate\Http\Request)) >> #22 /var/www/portals/default/bootstrap/compiled.php(5797): >> Illuminate\Foundation\Application->handle(Object(Illuminate\Http\Request), >> 1, true) >> #23 /var/www/portals/default/bootstrap/compiled.php(6404): >> Illuminate\Session\Middleware->handle(Object(Illuminate\Http\Request), 1, >> true) >> #24 /var/www/portals/default/bootstrap/compiled.php(6351): >> Illuminate\Cookie\Queue->handle(Object(Illuminate\Http\Request), 1, true) >> #25 /var/www/portals/default/bootstrap/compiled.php(8430): >> Illuminate\Cookie\Guard->handle(Object(Illuminate\Http\Request), 1, true) >> #26 /var/www/portals/default/bootstrap/compiled.php(639): >> Stack\StackedHttpKernel->handle(Object(Illuminate\Http\Request)) >> #27 /var/www/portals/default/public/index.php(51): >> Illuminate\Foundation\Application->run() >> #28 {main} [] [] >> >> On Tue, Mar 12, 2019 at 11:21 PM Keerthi N <keerthi4...@gmail.com >> <mailto:keerthi4...@gmail.com>> wrote: >> Hello, >> >> A few days back I almost reported about the same issue and Marcus suggested >> me to try #5 troubleshooting steps (from installation guide), "ps wwwaux | >> grep api-orch", ip address and port, but the issue wasn't resolved. So I >> would like share my laravel.log file as well. >> >> Thanks, >> Keerthi >> >> On Tue, Mar 12, 2019 at 11:40 AM Christie, Marcus Aaron <machr...@iu.edu >> <mailto:machr...@iu.edu>> wrote: >> The PGA log file is /var/www/portals/default/app/storage/logs/laravel.log >> >> What sort of error message are you getting? >> >>> On Mar 12, 2019, at 1:06 AM, Achanta, Sai Rohith <sacha...@iu.edu >>> <mailto:sacha...@iu.edu>> wrote: >>> >>> Killing all the Helix related processes and then trying Helix configuration >>> worked well. I was able to run the PGA application, but facing issues when >>> I’m trying to login/register. Where can I see the logs of the PGA to debug >>> the issue? or do I need to ignore the PGA and start looking with Django >>> portal? >>> >>> Thanks, >>> Sai Rohith Achanta. >>> >>> From: "Achanta, Sai Rohith" <sacha...@iu.edu <mailto:sacha...@iu.edu>> >>> Reply-To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Date: Monday, March 11, 2019 at 11:44 PM >>> To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Subject: Re: Error installing Airavata+RabbitMQ+Zookeeper >>> >>> Sure, I will try to kill it and try again. >>> >>> From: Suresh Marru <sma...@apache.org <mailto:sma...@apache.org>> >>> Reply-To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Date: Monday, March 11, 2019 at 11:31 PM >>> To: Airavata Dev <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Subject: Re: Error installing Airavata+RabbitMQ+Zookeeper >>> >>> Both previous one and this error was clearly in the error message: “there >>> are live instances in the cluster shut them down first” This typically >>> indicates there are zombie process running. You should search for any >>> running java processes on same ports and kill them first. >>> >>> Suresh >>> On Mar 11, 2019, at 11:23 PM, Achanta, Sai Rohith <sacha...@iu.edu >>> <mailto:sacha...@iu.edu>> wrote: >>> >>> I’m now facing the issue while creating helix cluster. However, other jobs >>> are executed successfully. I have attached the screenshot to this e-mail. >>> >>> From: "Achanta, Sai Rohith" <sacha...@iu.edu <mailto:sacha...@iu.edu>> >>> Reply-To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Date: Monday, March 11, 2019 at 10:47 PM >>> To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Subject: Re: Error installing Airavata+RabbitMQ+Zookeeper >>> >>> Thank you so much. The issue got resolved. >>> >>> From: "Pamidighantam, Sudhakar V" <spami...@illinois.edu >>> <mailto:spami...@illinois.edu>> >>> Reply-To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Date: Monday, March 11, 2019 at 10:23 PM >>> To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Subject: Re: Error installing Airavata+RabbitMQ+Zookeeper >>> >>> Can you try a VM with more memory (not disk space) say 8GB or so. >>> >>> Thanks, >>> Sudhakar. >>> >>> From: "Achanta, Sai Rohith" <sacha...@iu.edu <mailto:sacha...@iu.edu>> >>> Reply-To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Date: Monday, March 11, 2019 at 10:20 PM >>> To: "dev@airavata.apache.org <mailto:dev@airavata.apache.org>" >>> <dev@airavata.apache.org <mailto:dev@airavata.apache.org>> >>> Subject: Error installing Airavata+RabbitMQ+Zookeeper >>> >>> Hi team, >>> >>> I’m trying to setup Airavata on my laptop by following this link >>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.google.com_document_d_19anefh-5FIOrzXKlumyq6xcdBLfU01ReJTocixwsDBgus_edit-23heading-3Dh.x4u6k5meq2w7&d=DwMGaQ&c=OCIEmEwdEq_aNlsP4fF3gFqSN-E3mlr2t9JcDdfOZag&r=MHiqdWK8XhH0q9z3CNwPncJXwbe2U-jRufk9VnVTRww&m=-CLv3q4xGi7ObwzrYBDSXd-1DeYB3XDC1g4O0C_L3RM&s=44_dcL8Eqee27WEPe2UmFlED5Xm9BBYfL3sQNHgyrVQ&e=>. >>> I’m successful till Keycloak configuration. When I’m trying to install >>> “Airavata+RabbitMQ+Zookeeper”, I’m facing memory issue with VM when the >>> maven build is running. I tried to increase the disk space of VM, but still >>> I see the error. >>> >>> I have attached the screenshot to this e-mail. >>> Can anyone help me, please. >>> >>> Thanks and regards, >>> Sai Rohith Achanta. >>> >>> <helix_cluster.png> >> >
smime.p7s
Description: S/MIME cryptographic signature