<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>I had to update manually table bellow for root & nova passwords at FQDN host :-<br><br>[root@dfw01 ~(keystone_admin)]$ mysql -u root -p<br>Enter password: <br>Welcome to the MariaDB monitor. Commands end with ; or \g.<br>Your MariaDB connection id is 35<br>Server version: 5.5.34-MariaDB MariaDB Server<br><br>Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.<br><br>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br><br>MariaDB [(none)]> SELECT User, Host, Password FROM mysql.user;<br><br>+----------+-------------------+-------------------------------------------+<br>| User | Host | Password |<br>+----------+-------------------+-------------------------------------------+<br>| root | localhost | *E0DC09146F1310B49A34199B04274A9EED6F9EC7 |<br>| root | dfw01.localdomain | *E0DC09146F1310B49A34199B04274A9EED6F9EC7 | it's critical<br>| root | 127.0.0.1 | *E0DC09146F1310B49A34199B04274A9EED6F9EC7 |<br>| root | ::1 | *E0DC09146F1310B49A34199B04274A9EED6F9EC7 |<br>| keystone | localhost | *936E8F7AB2E21B47F6C9A7E5D9FE14DBA2255E5A |<br>| keystone | % | *936E8F7AB2E21B47F6C9A7E5D9FE14DBA2255E5A |<br>| glance | localhost | *CC67CAF178CB9A07D756302E0BBFA3B0165DFD49 |<br>| glance | % | *CC67CAF178CB9A07D756302E0BBFA3B0165DFD49 |<br>| cinder | localhost | *028F8298C041368BA08A280AA8D1EF895CB68D5C |<br>| cinder | % | *028F8298C041368BA08A280AA8D1EF895CB68D5C |<br>| neutron | localhost | *4DF421833991170108648F1103CD74FCB66BBE9E |<br>| neutron | % | *03A31004769F9E4F94ECEEA61AA28D9649084839 |<br>| nova | localhost | *0BE3B501084D35F4C66DD3AC4569EAE5EA738212 |<br>| nova | % | *0BE3B501084D35F4C66DD3AC4569EAE5EA738212 |<br>| nova | dfw01.localdomain | *0BE3B501084D35F4C66DD3AC4569EAE5EA738212 | it's critical<br>+----------+-------------------+-------------------------------------------+<br><br>15 rows in set (0.00 sec)<br><br>Otherwise , nothing is going to work , just "allinone" testing. When it's done , your schema goes ahead on F20 Two Node Real Cluster. I am going to file a bug regarding this updates , because I believe it should be done behind the scene. Updated and inserted rows are responsible for remote connection to controller for nova-compute and neutron-openswitch-agent services.<br><br>Thanks<br>Boris.<br><br><div>> Date: Mon, 10 Feb 2014 10:50:40 +0530<br>> From: kchamart@redhat.com<br>> To: bderzhavets@hotmail.com<br>> CC: rdo-list@redhat.com<br>> Subject: Re: [Rdo-list] Neutron configuration files for a two node Neutron+GRE+OVS<br>> <br>> (Please convince your mail client to wrap long lines, it's very<br>> difficult to read your emails.)<br>> <br>> On Sun, Feb 09, 2014 at 02:45:00AM -0500, Boris Derzhavets wrote:<br>> <br>> [. . .]<br>> <br>> > In new attempt on fresh F20 instance Neutron-server may be started only with<br>> > <br>> > [DATABASE]<br>> > sql_connection = mysql://root:password@localhost/ovs_neutron<br>> > <br>> > Block like :-<br>> > <br>> > Port "gre-2"<br>> > Interface "gre-2"<br>> > type: gre<br>> > options: {in_key=flow, local_ip="192.168.1.147", out_key=flow, remote_ip="192.168.1.157"}<br>> > <br>> > doesn't appear in `ovs-vsctl show` output . Nothing works on Compute<br>> > all Configs are the the same as in first attempt.<br>> <br>> > <br>> > The error from mysql, which I get "Access denied fror<br>> > 'root"@'new_hostname' new_hostname as before is in /etc/hosts<br>> ><br>> > <br>> > 192.168.1.147 new_hostname.localdomain new_hostname<br>> > <br>> > and in /etc/hostname<br>> > new_hostname.localdomain<br>> > <br>> > For me it looks like bug for neutron-server to be bind to 127.0.0.1<br>> > ,actually, connected with MariaDB database.<br>> <br>> It could possibly be. Please write a clear bug with full details and<br>> proper reproducer steps.<br>> <br>> <br>> ><br>> ><br>> > I did 2 attempts to reproduce it from scratch building Controller and<br>> > every time Neutron-server start up limitation came up.<br>> <br>> <br>> > Kashyap, my question to you :-<br>> > <br>> > Am I correct in my conclusions regarding Neutron-Server mysql<br>> > credentials affecting network abilities of Neutron or libvirtd daemon<br>> > is a real carrier for metadata and schema would work only on<br>> > non-default libvirt's network for virtual machines ?<br>> ><br>> <br>> I don't follow your question. Please rephrase or if you're convinced,<br>> please write bug with as much clear details as possible<br>> <br>> https://wiki.openstack.org/wiki/BugFilingRecommendations<br>> <br>> ><br>> > Then working real cluster is a kind of miracle. It's under testing on<br>> > daily basis.<br>> <br>> Thanks for testing.<br>> > <br>> > Thanks.<br>> > Boris.<br>> > <br>> > PS. All snapshots done on first Cluster (successfully working in<br>> > meantime with all updates accepted from yum) may be viewed here :-<br>> > <br>> > http://bderzhavets.blogspot.com/2014/01/setting-up-two-physical-node-openstack.html <br>> > <br>> <br>> -- <br>> /kashyap<br></div> </div></body>
</html>