From the fog log it looks like you're using Keystone V3. You may have to ensure the openstack 'admin' user is an admin of the domain you're connecting to. Try the following on the openstack controller:
# openstack role add --user admin --domain default admin
You should also check that there is an 'admin' project in the domain, and that the 'admin' user is also an admin of that project.
# openstack role add --user-domain default --user admin --project-domain default admin admin
Finally, when you add the openstack provider in ManageIQ, ensure you use the domain ID instead of the name (first column from this command):
# openstack domain list