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]>
Sent: Friday, August 25, 2017 12:30:46 PM
To: [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
