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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> Sent: Wednesday, August 30, 2017 12:49:14 PM To: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> Sent: Friday, August 25, 2017 12:30:46 PM To: [email protected]<mailto:[email protected]> 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 <[email protected]<mailto:[email protected]>> 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
