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> 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> 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\"})"] []
> [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 (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 (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', 'keerthi', 'naredla', 'Gateway@98')
> #11 /var/www/portals/default/app/controllers/AccountController.php(60):
> IamAdminServicesUtilities::registerUser('knaredla', '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', 'keerthi', 'naredla', 'Gateway@98')
> #10 /var/www/portals/default/app/controllers/AccountController.php(60):
> IamAdminServicesUtilities::registerUser('knaredla', '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> 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>
>> 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>
>>> 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>
>>> *Reply-To: *"dev@airavata.apache.org" <dev@airavata.apache.org>
>>> *Date: *Monday, March 11, 2019 at 11:44 PM
>>> *To: *"dev@airavata.apache.org" <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>
>>> *Reply-To: *"dev@airavata.apache.org" <dev@airavata.apache.org>
>>> *Date: *Monday, March 11, 2019 at 11:31 PM
>>> *To: *Airavata Dev <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>
>>> 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>
>>> *Reply-To: *"dev@airavata.apache.org" <dev@airavata.apache.org>
>>> *Date: *Monday, March 11, 2019 at 10:47 PM
>>> *To: *"dev@airavata.apache.org" <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>
>>> *Reply-To: *"dev@airavata.apache.org" <dev@airavata.apache.org>
>>> *Date: *Monday, March 11, 2019 at 10:23 PM
>>> *To: *"dev@airavata.apache.org" <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>
>>> *Reply-To: *"dev@airavata.apache.org" <dev@airavata.apache.org>
>>> *Date: *Monday, March 11, 2019 at 10:20 PM
>>> *To: *"dev@airavata.apache.org" <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>
>>>
>>>
>>>
>
