There was problems during playbook exectuions, in particular the TASK [../../library/roles/ckan/ckan : Initialize the CKAN databases] has failed several times:
- the table 'user' did not exist.. so I performed db init manually:
'SELECT \"user\".password AS user_password, \"user\".id AS user_id, \"user\".name AS user_name, \"user\".openid AS user_openid, \"user\".fullname AS user_fullname, \"user\".email AS user_email, \"user\".apikey AS user_apikey, \"user\".created AS user_created, \"user\".reset_key AS user_reset_key, \"user\".about AS user_about, \"user\".activity_streams_email_notifications AS user_activity_streams_email_notifications, \"user\".sysadmin AS user_sysadmin, \"user\".state AS user_state \\nFROM \"user\" \\nWHERE \"user\".name = %(name_1)s ORDER BY \"user\".name \\n LIMIT %(param_1)s' {'name_1': u'ckan_connector', 'param_1': 1}", "psql:/tmp/QknYwn.sql:1: ERROR: relation \"user\" does not exist", "LINE 1: update \"user\" set state = 'active' where name = 'ckan_connec...", " ^", "psql:/tmp/QknYwn.sql:2: ERROR: relation \"user\" does not exist", "LINE 1: select apikey from \"user\" where name = 'ckan_connector' and ...", " ^"], "stdout": "", "stdout_lines": []}
- the user 'ckan_connector' did not exist.. so I created it manually:
"stdout": "User \"ckan_connector\" not found\nCreate new user: ckan_connector? [y/n]Exiting ...", "stdout_lines": ["User \"ckan_connector\" not found", "Create new user: ckan_connector? [y/n]Exiting ..."]}
After fixes, now the playbook RECAP is ok:
PLAY RECAP *******************************************************************************************************************************************************************************************************
ckan-eosc.d4science.org : ok=227 changed=28 unreachable=0 failed=0
The Ckan Eosc is available at: https://ckan-eosc.d4science.org/ (now I'm going to update configurations for ckan template)
@costantino.perciante@isti.cnr.it, please, add the configurations (GR/RR) needed to run the catalogue in the VRE https://services.d4science.org/group/eosc_services asap, thanks.