when trying to login for the first time I get: An error occurred authenticating. Please try again later.

Asked by Stephen Smith on 2014-03-25

I did the http://docwiki.cisco.com/wiki/Openstack:Havana-Openstack-Installer#Prerequisites_for_All_Nodes for setting up my lab on my linux workstation. After installation when I first try to login to the horizon dashboard I get the following error:

 An error occurred authenticating. Please try again later.

I took a look at the horiozon log and it has:
2014-03-25 02:20:10,389 4319 DEBUG openstack_auth.backend Beginning user authentication for user "admin".
2014-03-25 02:20:10,389 4319 DEBUG keystoneclient.httpclient REQ: curl -i -X POST http://127.0.0.1:5000/v2.0/tokens -H "Content-Type: application/json" -H "User-Agent: python-keystoneclient"
2014-03-25 02:20:10,389 4319 DEBUG keystoneclient.httpclient REQ BODY: {"auth": {"passwordCredentials": {"username": "admin", "password": "Cisco123"}}}

2014-03-25 02:20:10,411 4319 DEBUG keystoneclient.httpclient RESP: [500] CaseInsensitiveDict({'date': 'Tue, 25 Mar 2014 02:20:10 GMT', 'vary': 'X-Auth-Token', 'content-length': '388', 'content-type': 'application/json'})
RESP BODY: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (ProgrammingError) (1146, \"Table 'keystone.domain' doesn't exist\") 'SELECT domain.id AS domain_id, domain.name AS domain_name, domain.enabled AS domain_enabled, domain.extra AS domain_extra \\nFROM domain \\nWHERE domain.id = %s' ('default',)", "code": 500, "title": "Internal Server Error"}}

2014-03-25 02:20:10,411 4319 DEBUG keystoneclient.httpclient Request returned failure status: 500
2014-03-25 02:20:10,412 4319 DEBUG openstack_auth.backend Authorization Failed: An unexpected error prevented the server from fulfilling your request. (ProgrammingError) (1146, "Table 'keystone.domain' doesn't exist") 'SELECT domain.id AS domain_id, domain.name AS domain_name, domain.enabled AS domain_enabled, domain.extra AS domain_extra \nFROM domain \nWHERE domain.id = %s' ('default',) (HTTP 500)
2014-03-25 02:20:10,412 4319 WARNING openstack_auth.forms Login failed for user "admin".

Not sure what my issue might be?

thanks!

Question information

Language:
English Edit question
Status:
Solved
For:
Cisco Openstack Edit question
Assignee:
No assignee Edit question
Solved by:
Stephen Smith
Solved:
2014-03-25
Last query:
2014-03-25
Last reply:
2014-03-25
Chris Ricker (chris-ricker) said : #1

The underlying problem appears to be that your databases aren't populated: "Table 'keystone.domain' doesn't exist"

If you do a puppet run (puppet apply /etc/puppet/manifests/site.pp) on your controller does it resolve the issue? If not, does it report any errors?

Stephen Smith (z-stephen) said : #2

Well that got me further it appears but I get a lot of dependency errors now after refreshing with (puppet apply /etc/puppet/manifests/site.pp)

Notice: /Stage[main]/Graphite/Exec[graphite-syncdb]/returns: Creating tables ...
Notice: /Stage[main]/Graphite/Exec[graphite-syncdb]/returns: Installing custom SQL ...
Notice: /Stage[main]/Graphite/Exec[graphite-syncdb]/returns: Installing indexes ...
Notice: /Stage[main]/Graphite/Exec[graphite-syncdb]/returns: Installed 0 object(s) from 0 fixture(s)
Notice: /Stage[main]/Graphite/Exec[graphite-syncdb]/returns: executed successfully
Notice: /Stage[main]/Graphite/Exec[restart-carbon]/returns: * Restarting Graphite backend daemon carbon-cache
Notice: /Stage[main]/Graphite/Exec[restart-carbon]/returns: ...done.
Notice: /Stage[main]/Graphite/Exec[restart-carbon]: Triggered 'refresh' from 1 events
Notice: /Stage[main]/Apache/Concat[/etc/apache2/ports.conf]/File[/etc/apache2/ports.conf]/content: content changed '{md5}152c2326cb5ff0eab65cf7d8a457618a' to '{md5}1483f0acdf0206ecc71c18d285cb4f8c'
Notice: /Stage[main]/Horizon/File_line[httpd_listen_on_bind_address_80]/ensure: created
Error: /Stage[main]/Keystone::Roles::Admin/Keystone_role[_member_]: Could not evaluate: Execution of '/usr/bin/keystone --os-endpoint http://192.168.56.102:35357/v2.0/ role-list' returned 1: An unexpected error prevented the server from fulfilling your request. (ProgrammingError) (1146, "Table 'keystone.role' doesn't exist") 'SELECT role.id AS role_id, role.name AS role_name, role.extra AS role_extra \nFROM role' () (HTTP 500)

Error: /Stage[main]/Neutron::Keystone::Auth/Keystone_service[neutron]: Could not evaluate: Execution of '/usr/bin/keystone --os-endpoint http://192.168.56.102:35357/v2.0/ service-list' returned 1: An unexpected error prevented the server from fulfilling your request. (ProgrammingError) (1146, "Table 'keystone.service' doesn't exist") 'SELECT service.id AS service_id, service.type AS service_type, service.extra AS service_extra \nFROM service' () (HTTP 500)

And these same errors continue the same on on each service:
[ceilometer]: Could not evaluate: Execution of '/usr/bin/keystone
[ResellerAdmin]: Could not evaluate: Execution of '/usr/bin/keystone
[nova_ec2]: Could not evaluate: Execution of '/usr/bin/keystone

and so on...

thank you!

Stephen Smith (z-stephen) said : #3

I was able to fix this by dropping the databases by running (keystone-manage db_sync)
After that I re ran (puppet apply /etc/puppet/manifests/site.pp) and it created my keystone users and I am able to login successfully!
thank you for the help!