[rhos-list] openstack-db command error

[Shixiong Shang (shshang)]

Hi, experts:

I am running "openstack-db" command to initiate database table for nova and saw this error:

[dmd at as-msg1 ~]$  sudo openstack-db --init --service nova --password nova --rootpw mysql
Verified connectivity to MySQL.
Creating 'nova' database.
ERROR 1396 (HY000) at line 2: Operation CREATE USER failed for 'nova'@'localhost'

It traced back to the following two commands in the "openstack-db" script under /usr/bin:
CREATE USER '$APP'@'localhost' IDENTIFIED BY '${MYSQL_APP_PW}';
CREATE USER '$APP'@'%' IDENTIFIED BY '${MYSQL_APP_PW}';


I tried to manually create DB and user in mysql and it still gave me the same error.
CREATE USER 'nova@'localhost' IDENTIFIED BY 'nova';
CREATE USER 'nova'@'%' IDENTIFIED BY 'nova';

If I used the following command instead, it passed successfully.
CREATE USER 'nova' IDENTIFIED BY 'nova';

Is it normal? Thanks!

Shixiong






[cid:339726B9-FB1D-4F23-9820-263F5D7D86E1]



Shixiong Shang
Solution Architect
WWSP Digital Media Distribution
Advanced Services

CCIE R&S - #17235

shshang at cisco.com<mailto:shshang at cisco.com>
Phone: +1 919 392 5192
Mobile: +1 919 272 1358


Cisco Systems, Inc.
7200-4 Kit Creek Road
RTP, NC 27709-4987
United States
Cisco.com<http://www.cisco.com/>





!--- Stay Hungry Stay Foolish ---!


This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/rhos-list/attachments/20130207/be466f46/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: A94EACAF-A587-477E-8B89-160A48E838C1[4].png
Type: image/png
Size: 9461 bytes
Desc: A94EACAF-A587-477E-8B89-160A48E838C1[4].png
URL: <http://listman.redhat.com/archives/rhos-list/attachments/20130207/be466f46/attachment.png>