<html><head><meta http-equiv="content-type" content="text/html; charset=UTF-8"><style>body { line-height: 1.5; }blockquote { margin-top: 0px; margin-bottom: 0px; margin-left: 0.5em; }body { font-size: 10.5pt; font-family: 微软雅黑; color: rgb(0, 0, 0); line-height: 1.5; }</style></head><body>
<div><b><span></span>Still did not work. Looks like no table exists in keystone DB, but the following command did not throw out any error.</b></div><div><b><br></b></div><div><pre>su -s /bin/sh -c <span class="s2">"keystone-manage db_sync"</span> keystone</pre></div><div><br></div><div><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">[root@controller ~]# mysql -u root -p<br>Enter password:<br>Welcome to the MariaDB monitor. Commands end with ; or \g.<br>Your MariaDB connection id is 3<br>Server version: 10.1.18-MariaDB MariaDB Server<br><br>Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.<br><br>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br><br>MariaDB [(none)]> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'controller' IDENTIFIED BY 'XXXXXXXX';<br>Query OK, 0 rows affected (0.01 sec)<br><br>MariaDB [(none)]> exit<br></span></div><div><br></div><div><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">[root@controller ~]# su - admin<br>上一次登录：四 12月 29 00:23:04 CST 2016pts/0 上<br>[admin@controller ~]$ export OS_USERNAME=admin<br>[admin@controller ~]$ export OS_PASSWORD=</span>XXXXXXXX<span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);"><br>[admin@controller ~]$ export OS_PROJECT_NAME=admin<br>[admin@controller ~]$ export OS_USER_DOMAIN_NAME=default<br>[admin@controller ~]$ export OS_PROJECT_DOMAIN_NAME=default<br>[admin@controller ~]$ export OS_AUTH_URL=http://controller:35357/v3<br>[admin@controller ~]$ export OS_IDENTITY_API_VERSION=3<br>[admin@controller ~]$ openstack project create --domain default --description "Service Project" service<br>An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-1350a2a8-8ad9-4f45-9c1a-3d844cceee31)<br></span><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">[admin@controller ~]$ export OS_PROJECT_NAME=admin<br>[admin@controller ~]$ export OS_USER_DOMAIN_NAME=default<br>[admin@controller ~]$ export OS_PROJECT_DOMAIN_NAME=default<br>[admin@controller ~]$ export OS_AUTH_URL=http://controller:35357/v3<br>[admin@controller ~]$ export OS_IDENTITY_API_VERSION=3<br>[admin@controller ~]$ openstack project create --domain default --description "Service Project" service<br>An unexpected error prevented the server from fulfilling your request. (HTTP 500) (Request-ID: req-1350a2a8-8ad9-4f45-9c1a-3d844cceee31)<br></span></div><div><span style="background-color: rgba(0, 0, 0, 0);">MariaDB [(none)]> use keystone<br>Database changed<br>MariaDB [keystone]> select Host,User from user where User='keystone';<br><font color="#ff0000">ERROR 1146 (42S02): Table 'keystone.user' doesn't exist</font><br>MariaDB [keystone]><br></span></div><div><span style="background-color: rgba(0, 0, 0, 0);"><br></span></div><div><span style="background-color: rgba(0, 0, 0, 0);">MariaDB [keystone]> select Host,Db,User from db where User='keystone';<br><font color="#ff0000">ERROR 1146 (42S02): Table 'keystone.db' doesn't exist<br></font></span></div><div><span style="background-color: rgba(0, 0, 0, 0);"><font color="#ff0000"><br></font></span></div><div><span style="background-color: rgba(0, 0, 0, 0);">MariaDB [keystone]> show tables;<br><font color="#ff0000">Empty set (0.00 sec)</font><br></span></div>
<div><br></div><hr style="width: 210px; height: 1px;" color="#b5c4df" size="1" align="left">
<div><span><div style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt"><div style="margin: 10px; font-size: 10pt;">====================</div><div style="margin: 10px; font-size: 10pt;"><br></div><div style="margin: 10px; font-size: 10pt;">=====================</div><div style="margin: 10px; font-size: 10pt;"><span style="color: rgb(0, 0, 0); background-color: rgba(0, 0, 0, 0);">董 建 华<br>地址：杭州滨江区南环路3766号新世纪办公楼<br>邮编：310053<br>手机：13857132818<br>总机：0571-28996000<br>传真：0571-28996001<br>热线：4006728686<br>网址：www.ahope.com.cn<br>Email：dongjh@</span><span style="font-size: 10pt; line-height: 1.5; background-color: window;">ahope.com.cn</span></div></div></span></div>
<blockquote style="margin-top: 0px; margin-bottom: 0px; margin-left: 0.5em;"><div> </div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><div style="PADDING-RIGHT: 8px; PADDING-LEFT: 8px; FONT-SIZE: 12px;FONT-FAMILY:tahoma;COLOR:#000000; BACKGROUND: #efefef; PADDING-BOTTOM: 8px; PADDING-TOP: 8px"><div><b>发件人：</b> <a href="mailto:turbo@bayour.com">Turbo Fredriksson</a></div><div><b>发送时间：</b> 2016-12-29 01:03</div><div><b>收件人：</b> <a href="mailto:dongjh@ahope.com.cn">dongjh@ahope.com.cn</a></div><div><b>抄送：</b> <a href="mailto:openstack@lists.openstack.org">openstack</a></div><div><b>主题：</b> Re: [Openstack] 回复: keystone fail</div></div></div><div><div>On 28 Dec 2016, at 16:35, dongjh@ahope.com.cn wrote:</div>
<div> </div>
<div>> 2016-12-29 00:27:13.006 1825 ERROR keystone.common.wsgi OperationalError: (pymysql.err.OperationalError) (1045, u"Access denied for user 'keystone'@'controller' (using password: YES)")</div>
<div> </div>
<div>You might not have created the user correctly, OR not given it the correct</div>
<div>access. As in, you might have allowed “keystone@localhost”, but not</div>
<div>“keystone@controller”.</div>
<div> </div>
<div>Look at the ‘mysql’ database:</div>
<div> </div>
<div> select Host,User from user where User='keystone’;</div>
<div> select Host,Db,User from db where User='keystone’;</div>
<div> </div>
</div></blockquote>
</body></html>