Initialize and configure the database in OpenStack Installation Guide for Red Hat Enterprise Linux, CentOS, and Fedora - havana

[hoover]

the dashboard install guide is hosed. When trying to run syncdb, I get the following error on centos 6.4:

 File "/usr/lib/python2.6/site-packages/django/conf/__init__.py", line 95, in __init__
    raise ImportError("Could not import settings '%s' (Is it on sys.path?): %s" % (self.SETTINGS_MODULE, e))
ImportError: Could not import settings 'openstack_dashboard.settings' (Is it on sys.path?): No module named pbr.version

-----------------------------------
Built: 2013-11-28T13:09:28 00:00
git SHA: 2e03e7d1123d8463a675caaafd3c77cffae2b060
URL: http://docs.openstack.org/trunk/install-guide/install/yum/content/dashboard-session-database.html
source File: file:/home/jenkins/workspace/openstack-install-deploy-guide-fedora/doc/common/section_dashboard_sessions.xml
xml:id: dashboard-session-database

[Tom Fifield (fifieldt)]

It seems like the pbr package isn't installed - can you do a yum search?

[hoover (uwe-schuerkamp)]

Thanks, that fixed it, now syncdb works after granting the privs to dash@localhost explicitly (the grant statement from the docs would result in an "access denied" mysql error).

Now on to the next problem ;)

Uwe

[Stephen Gordon (sgordon)]

Yeah, the '%' wildcard doesn't match local socket connections - a known MySQL peculiarity - I will update.

[Stephen Gordon (sgordon)]

(I also just did a quick check and this appears to be the only case where we didn't do both GRANTS)

[Stephen Gordon (sgordon)]

For the benefit of the tape I've set Closes-Bug in that commit as if the PBR thing is still an issue then that is likely a packaging issue we need to follow up with the RDO guys, not an openstack-manuals fault.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/59190
Committed: http://github.com/openstack/openstack-manuals/commit/1cad5969600f53f46b948a9ba6f6cd907f033a9c
Submitter: Jenkins
Branch: master

commit 1cad5969600f53f46b948a9ba6f6cd907f033a9c
Author: Stephen Gordon <email address hidden>
Date: Fri Nov 29 09:44:15 2013 -0500

    Grant access to 'dash'@'localhost' in dashboard setup

    MySQL does not include local socket connection in the '%' wildcard. This
    meant that following the existing instructions if the dash was installed
    on the same system as the database it was not actually able to access
    it.

    A grant for 'dash'@'localhost' has been added to address this. It is
    worth noting that in this situation (dash + MySQL on same host) this
    means that the wildcard grant is actually insecure and not required, but
    this is a wider issue that we need to address/highlight at some point.

    Currently we issue both grants for all services, this fix just brings
    the dashboard instructions into line with the rest.

    Change-Id: Id32432c3612945d6cc8860e947d332d15a8072b4
    Closes-Bug: #1255975
    backport: havana

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/havana
Review: https://review.openstack.org/59275

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/59275
Committed: http://github.com/openstack/openstack-manuals/commit/ab858285f1259d954200dd94f487d036c21c032c
Submitter: Jenkins
Branch: stable/havana

commit ab858285f1259d954200dd94f487d036c21c032c
Author: Stephen Gordon <email address hidden>
Date: Fri Nov 29 09:44:15 2013 -0500

    Grant access to 'dash'@'localhost' in dashboard setup

    MySQL does not include local socket connection in the '%' wildcard. This
    meant that following the existing instructions if the dash was installed
    on the same system as the database it was not actually able to access
    it.

    A grant for 'dash'@'localhost' has been added to address this. It is
    worth noting that in this situation (dash + MySQL on same host) this
    means that the wildcard grant is actually insecure and not required, but
    this is a wider issue that we need to address/highlight at some point.

    Currently we issue both grants for all services, this fix just brings
    the dashboard instructions into line with the rest.

    Change-Id: Id32432c3612945d6cc8860e947d332d15a8072b4
    Closes-Bug: #1255975
    backport: havana
    (cherry picked from commit 1cad5969600f53f46b948a9ba6f6cd907f033a9c)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/openstack-manuals 15.0.0 release.