Deleting userrole using ldapdelete post upgrade from 14.07 to 15.01

[jhans]

Hello Folks,

We have issues wherein after we upgrade from 14.07 to 15.01 we face issues with userroles and we get below error on UI:

"Invalid Role Name"

This happens as the openldap is not able to read userroles with spaces.

Because of this the UI is not able to display all apis.

To avoid this problem we need to delete userroles with spaces and recreate them. UI does not even allow to delete these hence you need to remove it using ldapdelete command

Below is what I tried with my test org:

We need to delete it using ldapdelete command:

[root@jagjyot ~]# ldapdelete -r -H "ldap://localhost:10389" -D "cn=manager,dc=apigee,dc=com" 'cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com' -w $pass -v
ldap_initialize( ldap://localhost:10389/??base )
deleting entry "cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com"
deleting children of: cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
deleting children of: ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
deleting children of: cn=@@@environments@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@environments@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@environments@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@environments,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@environments,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@environments,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@environments@@@*@@@virtualhosts,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@environments@@@*@@@virtualhosts,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@environments@@@*@@@virtualhosts,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@environments@@@*@@@virtualhosts@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@environments@@@*@@@virtualhosts@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@environments@@@*@@@virtualhosts@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@developers,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@developers,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@developers,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@companies,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@companies,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@companies,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@applications,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@applications,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@applications,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@apiproducts,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@apiproducts,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@apiproducts,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@reports,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@reports,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@reports,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@developers@@@*@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@developers@@@*@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@developers@@@*@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@developers@@@*@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@developers@@@*@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@developers@@@*@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@companies@@@*@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@companies@@@*@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@companies@@@*@@@apps,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@companies@@@*@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@companies@@@*@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@companies@@@*@@@apps@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@deployments,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@deployments,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@deployments,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@environments@@@prod@@@caches,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@environments@@@prod@@@caches,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@environments@@@prod@@@caches,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@environments@@@prod@@@caches@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@environments@@@prod@@@caches@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@environments@@@prod@@@caches@@@*,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
deleting children of: cn=@@@,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	removing cn=@@@,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	cn=@@@,ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed
	removing ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com
	ou=resources,cn=test userrole,ou=userroles,o=testuserrole,ou=organizations,dc=apigee,dc=com removed

If you see above this will remove the userrole with space and the error on UI will cease to appear.