Create a domain, projects, users, and roles in Installation Guide

[Walt Corey]

This is in the Newton install doc set for ubuntu 16.04. The command:

openstack project create --domain default --description "Service Project" service

fails.

The failure text is:
An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-b289477b-65dc-460b-b5c3-a900b95d13fc)

I have to ask this, has anyone actually tried to, as was suggested in a previous bug, actually follow these instructions to the letter? I doubt it as it does not work. It doesn't work for installing MariaDB, breaking in the secure_installation step. I believe this is relegated to a change in how 16.04 does security but it did screw up when su is required and when it can't be set.

http://docs.openstack.org/newton/install-guide-ubuntu/environment-sql-database.html

I see below this is release 0.1.

-----------------------------------
Release: 0.1 on 2016-12-13 09:02
SHA: 9d9161b3a033ca0fd68a74d12070308e0643c4be
Source: http://git.openstack.org/cgit/openstack/openstack-manuals/tree/doc/install-guide/source/keystone-users.rst
URL: http://docs.openstack.org/newton/install-guide-ubuntu/keystone-users.html

[Walt Corey (waltc)]

I did attempt this with a sudo prefix and received the following.

Missing parameter(s):
Set a username with --os-username, OS_USERNAME, or auth.username
Set an authentication URL, with --os-auth-url, OS_AUTH_URL or auth.auth_url

however my environment has this as exported values

declare -x OS_AUTH_URL="http://controller:35357/v3"
declare -x OS_IDENTITY_API_VERSION="3"
declare -x OS_PASSWORD="ADMIN_PASS"
declare -x OS_PROJECT_DOMAIN_NAME="default"
declare -x OS_PROJECT_NAME="admin"
declare -x OS_USERNAME="admin"
declare -x OS_USER_DOMAIN_NAME="default"

from the install page this should not require, and shows it doesn't do super user, which goes back to the 16.04 issue with permissions, which I mentioned above. However, notwithstanding the sudo issue, it appears both values 'missing' are known.

please advise.

[maestropandy (maestropandy)]

Hi,

it seems that, issues with your source file, which you have exported ? & have u checked same with V2, are you able to other creation CLI's with same source file contents ?

[Walt Corey (waltc)]

According to the install tutorial, why they changed this name from install guide, especially when clearly nobody has sample run the tutorial, is beyond me but also out of scope, the auth URL is for V3. I am not sure what you mean by source file, this one?

export OS_USERNAME=admin
export OS_PASSWORD=ADMIN_PASS
export OS_PROJECT_NAME=admin
export OS_USER_DOMAIN_NAME=default
export OS_PROJECT_DOMAIN_NAME=default
export OS_AUTH_URL=http://controller:35357/v3
export OS_IDENTITY_API_VERSION=3

This is from page (apparently they don't do page numbers anymore. It comes after Install and Configure under Identity so there really isn't much else I can do. I think the issue stems from MariaDB's installation as, it prompts for password which it never did under Havana. I should note, the machine I am running these on IS 'controller' and is defined as such in hosts.

walt@controller:~$ openstack project create --domain default --description "Service Project" service
Password:

[Alexandra Settle (alexandra-settle)]

Hi Walt,

When you said "I have to ask this, has anyone actually tried to, as was suggested in a previous bug, actually follow these instructions to the letter?" What previous bug are you referring to?

I have tested the command "openstack project create --domain default --description "Service Project" service" and it executed without error.

I'm not entirely too sure what your report is detailing as you appear to have several concerns within your comments.

Could you please outline your problem clearly, what is failing? What are you trying to install? What documentation are you reading?
Could you please include links and examples when reporting back :)

Thank you,

Alex

[Manjunath Warad (m70905)]

Hi Walt,

Suppose to run the command as non SU user and there will be no error.

Regards,
Manjunath

[nitin nanda (ninanda1981)]

Hi Team,

I am too facing same issue, here is what i did:

nnanda@nnanda:~$ export OS_USERNAME=admin
nnanda@nnanda:~$ export OS_PASSWORD=nnanda
nnanda@nnanda:~$ export OS_PROJECT_NAME=admin
nnanda@nnanda:~$ export OS_USER_DOMAIN_NAME=Default
nnanda@nnanda:~$ export OS_PROJECT_DOMAIN_NAME=Default
nnanda@nnanda:~$ export OS_AUTH_URL=http://controller:35357/v3
nnanda@nnanda:~$ export OS_IDENTITY_API_VERSION=3
nnanda@nnanda:~$
nnanda@nnanda:~$
nnanda@nnanda:~$ openstack project create --domain default --description "Service Project" service
An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-c06c7fa5-14d5-42b6-b03b-573ee1998759)
nnanda@nnanda:~$
nnanda@nnanda:~$
nnanda@nnanda:~$ grep req-c06c7fa5-14d5-42b6-b03b-573ee1998759 /var/log/apache2/keystone.log
2017-02-18 19:08:36.693912 2017-02-18 19:08:36.693 12612 INFO keystone.common.wsgi [req-c06c7fa5-14d5-42b6-b03b-573ee1998759 - - - - -] POST http://controller:35357/v3/auth/tokens
2017-02-18 19:08:36.730158 2017-02-18 19:08:36.724 12612 ERROR keystone.common.wsgi [req-c06c7fa5-14d5-42b6-b03b-573ee1998759 - - - - -] (sqlite3.OperationalError) no such table: project [SQL: u'SELECT project.id AS project_id, project.name AS project_name, project.domain_id AS project_domain_id, project.description AS project_description, project.enabled AS project_enabled, project.extra AS project_extra, project.parent_id AS project_parent_id, project.is_domain AS project_is_domain \\nFROM project \\nWHERE project.name = ? AND project.domain_id = ?'] [parameters: (u'Default', '<<keystone.domain.root>>')]
nnanda@nnanda:~$

Could anyone help please?

thanks & regards
Nitin nanda