No PostgreSQL description

Bug #1068971 reported by Dennis Leeuw
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
openstack-manuals
Fix Released
Medium
Anne Gentle

Bug Description

Make sure the /var/lib/keystone/keystone.db is not present ... etc ...
This example shows PostgreSQL.

Install PostgreSQL:
$ sudo apt-get install postgresql postgresql-client

Create a database use and a database for Keystone:
$ sudo su - postgres
postgres> psql
postgres=# CREATE USER keystonedbadmin;
postgres=# ALTER USER keystonedbadmin WITH PASSWORD 'passwd';
postgres=# CREATE DATABASE keystone;
postgres=# GRANT ALL PRIVILEGES ON DATABASE keystone TO keystonedbadmin;
postgres=# \q
postgres> exit
$

The database is created and we have a privileged user that controls the database. Now we have to install the packages that will help Keystone to access our database.

$ sudo apt-get install python-sqlalchemy python-psycopg2

With sqlalchemy installed we can move over to Keystone:
$ sudo apt-get install -y keystone

Configure the /etc/keystone/keystone.conf file, first we make sure we do not get messages about unhandled logging:
$ sudo sed -i 's/^log_config = /etc/keystone/logging.conf/# log_config = /etc/keystone/logging.conf/'
$ sudo sed -i 's/^use_syslog = False/use_syslog = True/'
$ sudo sed -i 's/^# syslog_log_facility = LOG_LOCAL0/syslog_log_facility = LOG_LOCAL0/'

Next we gonna tell Keystone how to contact our PostgresSQL database:
connection = postgres://keystonedbadmin:[passwd]@127.0.0.1/keystone

Follow rest of manual as for MySQL (admin_token, etc)

Anne Gentle (annegentle)
Changed in openstack-manuals:
status: New → Confirmed
importance: Undecided → Medium
assignee: nobody → Anne Gentle (annegentle)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to openstack-manuals (master)

Fix proposed to branch: master
Review: https://review.openstack.org/15151

Changed in openstack-manuals:
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to openstack-manuals (master)

Reviewed: https://review.openstack.org/15151
Committed: http://github.com/openstack/openstack-manuals/commit/84eee9a2746b3271b2c187fd1b784f0f1a8d16d2
Submitter: Jenkins
Branch: master

commit 84eee9a2746b3271b2c187fd1b784f0f1a8d16d2
Author: annegentle <email address hidden>
Date: Wed Oct 31 16:09:14 2012 -0500

    Fix doc bugs in Install guide

    bug 1054168 - documents v1 and v2 Image API details
    bug 1073003 - debian listed twice
    bug 1073005 - NTP best practices
    bug 1073370 - mismatch in sept/oct Folsom date listings
    bug 1068971 - adds PostgreSQL description for nova database, rather than keystone
    thinking of rewriting entire database into one section anyway... so this may be
    a poor fix to the bug but would like input.

    Rebase against master.

    Change-Id: I1e678ae98448928ca5096da5fdc01a5bb9c8bddf

Changed in openstack-manuals:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.