Re: help for airavata installation

["Christie, Marcus Aaron" <ma...@iu.edu>]

Qiyang,

I’m not sure. There may be a problem with the hashing method. Try setting the hash method to PLAINTEXT like so:

default.registry.password.hash.method=PLAINTEXT


Thanks,

Marcus


On Aug 31, 2017, at 1:34 PM, Hu, Qiyang <hu...@idre.ucla.edu>> wrote:

Hi Marcus,

I got this:


bash-4.2# grep "default.registry" ~airavata/master-deployment/api-orchestrator/apache-airavata-server-0.17-SNAPSHOT/bin/airavata-server.properties
default.registry.user=admin
default.registry.password=admin
default.registry.password.hash.method=SHA
default.registry.gateway=default


Any hints?

Thanks,
Qiyang
________________________________
From: Christie, Marcus Aaron <ma...@iu.edu>>
Sent: Wednesday, August 30, 2017 12:49:14 PM
To: users@airavata.apache.org<ma...@airavata.apache.org>
Subject: Re: help for airavata installation

Seems to be something wrong with the password specified as property “default.registry.password” in airavata-server.properties.

What is the value of default.registry.password in  ~airavata/master-deployment/api-orchestrator/apache-airavata-server-0.17-SNAPSHOT/bin/airavata-server.properties?

On Aug 29, 2017, at 6:35 PM, Hu, Qiyang <hu...@idre.ucla.edu>> wrote:

Hello Marcus,

Thanks for the detailed guidelines. I followed the steps and worked out all the installations without any errors from ansible-playbook commands.

However after completing ansible steps, when I tried to start the airavata as root with the command like below



(ENV) bash-4.2# ~airavata/master-deployment/api-orchestrator/apache-airavata-server-0.17-SNAPSHOT/bin/airavata-server-start.sh all

I got bunch of errors like below which seems not picking up the passwords correctly from airavata-server.properties:


[INFO] DB Event subscriber created
[ERROR] The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:594)
        at org.apache.airavata.registry.core.experiment.catalog.resources.UserResource.save(UserResource.java:174)
        at org.apache.airavata.registry.api.service.util.ExperimentCatalogInitUtil.initializeDB(ExperimentCatalogInitUtil.java:119)
        at org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer(RegistryAPIServer.java:57)
        at org.apache.airavata.registry.api.service.RegistryAPIServer.start(RegistryAPIServer.java:149)
        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: org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2337)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2174)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2072)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1990)
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1514)
        at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
        ... 7 common frames omitted
Caused by: org.apache.openjpa.persistence.PersistenceException: (conn:148) Incorrect string value: '\xEF\xBF\xBD3\xEF\xBF...' for column 'PASSWORD' at row 1 {prepstmnt 635001030
INSERT INTO USERS (GATEWAY_ID, USER_NAME, AIRAVATA_INTERNAL_USER_ID,
        PASSWORD)
    VALUES (?, ?, ?, ?)
[params=(String) default, (String) admin, (String) admin@default, (String) �3�*�H��f^O�^T
�5�^LM��]} [code=1366, state=22007]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4918)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4878)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)

Any hints to fix this?

Thanks,
Qiyang
________________________________
From: Christie, Marcus Aaron <ma...@iu.edu>>
Sent: Friday, August 25, 2017 12:30:46 PM
To: users@airavata.apache.org<ma...@airavata.apache.org>
Subject: Re: help for airavata installation

Qiyang,

I’m afraid that the inventories/develop inventory directory is a little out-dated and is missing some config variables.

The more up-to-date inventories are the ones in inventories/scigap, which are the ones we use in SciGaP for our deployments.

I would recommend that you make copy inventories/scigap/production and then go update the following files:
* hosts
* delete the files/ directory
* update variables as needed in group_vars/all/vars.yml. NOTE: some of these vars get their values from the vault.yml file. The vault.yml file is encrypted so you’ll either need to remove it and just specify the values in vars.yml directly or you can create your own vault.yml file with your own password
* you probably only need a single pga_config directory so just use the seagrid one as an example. Put these vars into group_vars/pga/vars.yml. Same comment regarding vault.yml.

Also the site.yml file is out-dated too. Honestly I don’t use it myself because I usually deploy different parts of airavata separately. Like so:

ansible-playbook -i inventories/YOUR_INVENTORY_DIR database.yml

ansible-playbook -i inventories/YOUR_INVENTORY_DIR keycloak.yml

ansible-playbook -i inventories/YOUR_INVENTORY_DIR airavata.yml

ansible-playbook -i inventories/YOUR_INVENTORY_DIR pga.yml


Thanks,

Marcus



On Aug 24, 2017, at 2:32 PM, Hu, Qiyang <hu...@idre.ucla.edu>> wrote:

Hello Marcus,

I met some problems in running ansible script in master branch. After following the readme file, when I ran

ansible-playbook -i inventories/develop site.yml

I got the error:


TASK [database : create databases] *********************************************
fatal: [149.165.156.184]: FAILED! => {"failed": true, "msg": "['{{ app_catalog }}', '{{ exp_catalog }}', '{{ replica_catalog }}', '{{ workflow_catalog }}', '{{ credential_store }}', '{{ sharing_catalog }}', '{{ profile_service }}']: 'profile_service' is undefined"}
    to retry, use: --limit @/home/huqy/airavata/dev-tools/ansible/site.retry

When I ran

ansible-playbook -i inventories/scigap/production site.yml

I got the error:


ERROR! Attempted to read "/home/huqy/airavata/dev-tools/ansible/inventories/scigap/production/pga_config/NCSAIndustry/vault.yml" as YAML: Decryption failed on b'/home/huqy/airavata/dev-tools/ansible/inventories/scigap/production/pga_config/NCSAIndustry/vault.yml'
Attempted to read "/home/huqy/airavata/dev-tools/ansible/inventories/scigap/production/pga_config/NCSAIndustry/vault.yml" as ini file: Decryption failed on b'/home/huqy/airavata/dev-tools/ansible/inventories/scigap/production/pga_config/NCSAIndustry/vault.yml'

Anywhere to find further instructions about configurations?

Thanks,
Qiyang