<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi Amit,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Can you verify the GRANTS allowed on the nova database? By GRANTS, I mean the privileges / permissions for the nova database.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Krishnaprasad<o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Amit Anand [mailto:aanand@viimed.com]
<br>
<b>Sent:</b> Mittwoch, 26. November 2014 22:56<br>
<b>To:</b> Jay Pipes<br>
<b>Cc:</b> openstack@lists.openstack.org<br>
<b>Subject:</b> Re: [Openstack] Nova DB sync Operational error<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Well created a new controller on a whole new machine and get all the way up until compute and get same error again. I have to think it something with my nova.conf but I cant figure it out. Ive pasted here so if anyone can take a look and
see maybe what Im doing incorrect I would appreciate it...<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://paste.openstack.org/show/139079/">http://paste.openstack.org/show/139079/</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Nov 26, 2014 at 4:09 PM, Amit Anand <<a href="mailto:aanand@viimed.com" target="_blank">aanand@viimed.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p class="MsoNormal">Im going to try building a new controller on a whole new nuc see if I get the same I will keep yall abreast if it works or not. In any case thank you very much for all your help!!!<o:p></o:p></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Nov 26, 2014 at 3:56 PM, Amit Anand <<a href="mailto:aanand@viimed.com" target="_blank">aanand@viimed.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Password is viimed1 <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Nov 26, 2014 at 3:55 PM, Amit Anand <<a href="mailto:aanand@viimed.com" target="_blank">aanand@viimed.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p class="MsoNormal">George<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks. Yeah there no other nova.conf I went as far as to do a find in case I put somewhere nothing turned up except the proper one. I did have a nova.conf.orig (I always make a backup so i can always start over) and was hoping maybe you
hit the nail on the head so I moved that out to my /home/amit dir but alas that failed as well :-(<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Permissions I made rwrwrw still same. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Nov 26, 2014 at 3:42 PM, Amit Anand <<a href="mailto:aanand@viimed.com" target="_blank">aanand@viimed.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p class="MsoNormal">Geo <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Error logs are here:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://paste.openstack.org/show/139035/" target="_blank">http://paste.openstack.org/show/139035/</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">When I run your command with password nova it fails - when I run it with the real password it works fine<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">[root@controller ~]# mysql -u nova -p -h controller nova<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Enter password:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I entered nova here<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">ERROR 1045 (28000): Access denied for user 'nova'@'controller' (using password: YES)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">[root@controller ~]# mysql -u nova -p -h controller nova<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Enter password:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I entered real password here<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Welcome to the MariaDB monitor. Commands end with ; or \g.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Your MariaDB connection id is 13<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Server version: 5.5.40-MariaDB MariaDB Server<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">MariaDB [nova]> quit<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Bye<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Nov 26, 2014 at 3:36 PM, Amit Anand <<a href="mailto:aanand@viimed.com" target="_blank">aanand@viimed.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p class="MsoNormal">Jay,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">So this is the command that u sent, works just fine connect to Nova DB:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">[root@controller nova]# mysql -unova -hlocalhost -p -Dnova<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Enter password:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Welcome to the MariaDB monitor. Commands end with ; or \g.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Your MariaDB connection id is 8<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Server version: 5.5.40-MariaDB MariaDB Server<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">MariaDB [nova]><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I also changed in nvoa.conf <span style="font-size:10.0pt;font-family:"Arial",sans-serif">connection=mysql://nova:__PASSWORD@localhost/nova (I tried with both a space and a _ as I was not sure exactly what you meant - still same error)
:-(</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">I also took a look at a command you ran and I tried it, would this be correct output (notice I didnt specify a DB in command)?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">MariaDB [mysql]> SELECT * FROM db WHERE User = 'root'\G<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">*************************** 1. row ***************************<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Host: %<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Db: nova<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> User: root<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Select_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Insert_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Update_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Delete_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Create_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Drop_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Grant_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> References_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Index_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Alter_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Create_tmp_table_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Lock_tables_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Create_view_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Show_view_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Create_routine_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Alter_routine_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Execute_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Event_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"> Trigger_priv: Y<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">1 row in set (0.01 sec)<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal">Also this is the output for user Nova:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">MariaDB [mysql]> SELECT * FROM db WHERE User = 'nova'\G;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">*************************** 1. row ***************************<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Host: localhost<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Db: nova<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> User: nova<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Select_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Insert_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Update_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Delete_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Create_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Drop_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Grant_priv: N<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> References_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Index_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Alter_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Create_tmp_table_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Lock_tables_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Create_view_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Show_view_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Create_routine_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Alter_routine_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Execute_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Event_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Trigger_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">*************************** 2. row ***************************<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Host: %<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Db: nova<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> User: nova<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Select_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Insert_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Update_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Delete_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Create_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Drop_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Grant_priv: N<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> References_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Index_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Alter_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Create_tmp_table_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Lock_tables_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Create_view_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Show_view_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Create_routine_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Alter_routine_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Execute_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Event_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Trigger_priv: Y<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">2 rows in set (0.00 sec)<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Nov 26, 2014 at 3:12 PM, Jay Pipes <<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">On 11/26/2014 02:36 PM, Amit Anand wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">Same error - also tried with 127.0.0.1. Even crazier I removed all<br>
keystone nova (user, service, etc) and dropped the nova DB and recreated<br>
that, then recreated keystone nova with a new different password,<br>
updated nova.conf with new password and still get the same error (notice<br>
below now nova has the different password):<o:p></o:p></p>
</blockquote>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
Permissions for a user are not affected by the removal of a database. You can even add permissions for a user to operate on a database that doesn't exist:<br>
<br>
mysql> SHOW DATABASES;<br>
+--------------------+<br>
| Database |<br>
+--------------------+<br>
| information_schema |<br>
| mysql |<br>
| performance_schema |<br>
| test |<br>
+--------------------+<br>
4 rows in set (0.03 sec)<br>
<br>
mysql> GRANT ALL ON foo.* TO root@localhost;<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
mysql> GRANT ALL ON test.* TO root@localhost;<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
mysql> USE mysql<br>
Database changed<br>
mysql> SELECT * FROM db WHERE User = 'root' AND Db = 'foo'\G<br>
*************************** 1. row ***************************<br>
Host: localhost<br>
Db: foo<br>
User: root<br>
Select_priv: Y<br>
Insert_priv: Y<br>
Update_priv: Y<br>
Delete_priv: Y<br>
Create_priv: Y<br>
Drop_priv: Y<br>
Grant_priv: N<br>
References_priv: Y<br>
Index_priv: Y<br>
Alter_priv: Y<br>
Create_tmp_table_priv: Y<br>
Lock_tables_priv: Y<br>
Create_view_priv: Y<br>
Show_view_priv: Y<br>
Create_routine_priv: Y<br>
Alter_routine_priv: Y<br>
Execute_priv: Y<br>
Event_priv: Y<br>
Trigger_priv: Y<br>
1 row in set (0.00 sec)<br>
<br>
Go figure :)<br>
<br>
If you manually specify the host on the command line, do you still get in to the MySQL server?<br>
<br>
i.e., if you do this on the command line, does it work?<br>
<br>
mysql -unova -hlocalhost -p -Dnova<br>
<br>
Best,<br>
-jay<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal" style="margin-bottom:12.0pt">MariaDB [mysql]> SELECT user,password,host FROM user;<br>
+----------+-------------------------------------------+-----------+<br>
| user | password | host |<br>
+----------+-------------------------------------------+-----------+<br>
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |<br>
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |<br>
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |<br>
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |<br>
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |<br>
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |<br>
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |<br>
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | localhost |<br>
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | % |<br>
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |<br>
+----------+-------------------------------------------+-----------+<br>
10 rows in set (0.00 sec)<br>
<br>
<br>
On Wed, Nov 26, 2014 at 2:26 PM, Jay Pipes <<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a><br>
<mailto:<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a>>> wrote:<br>
<br>
On 11/26/2014 02:21 PM, Amit Anand wrote:<br>
<br>
Hi Jay - I believe so below is the part that is in the nova.conf<br>
<br>
# The SQLAlchemy connection string used to connect to the<br>
# bare-metal database (string value)<br>
connection=mysql://nova:__PASSWORD@controller/nova<br>
<br>
The PASSWORD is exactly the same what I have in the conf file<br>
and what I<br>
have in the nova.conf<br>
<br>
Im doing this manually via the Juno instruction guide for CentOs 7.<br>
<br>
<br>
try:<br>
<br>
connection=mysql://nova:__PASSWORD@localhost/nova<br>
<br>
Best,<br>
-jay<br>
<br>
<o:p></o:p></p>
</blockquote>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>