[Starlingx-discuss] [Containers] Incorrect provider/tenant networking steps in wiki

[Cordoba Malibran, Erich]

Thanks Bart!

Don't worry, I followed the updated steps without a problem.

On 1/29/19, 8:13 AM, "Wensley, Barton" <Barton.Wensley at windriver.com> wrote:

    Erich,
    
    The "neutron host-create" and "neutron host-bind-interface" commands (i.e. the whole "Create host and bind interfaces" section) are no longer required in loads build on January 25th or later. 
    
    We will update the wikis ASAP - sorry for the delay.
    
    Bart
    
    -----Original Message-----
    From: Cordoba Malibran, Erich [mailto:erich.cordoba.malibran at intel.com] 
    Sent: January 28, 2019 5:56 PM
    To: starlingx-discuss at lists.starlingx.io
    Subject: [Starlingx-discuss] [Containers] Incorrect provider/tenant networking steps in wiki
    
    Hi, 
    
    I'm following the wiki[0] and in the Provider/tenant networking setup
    these commands are listed: 
    
    $ neutron host-bind-interface --interface $(sudo -u postgres psql -qt -d sysinv -c "select uuid from ethernet_interfaces join interfaces on ethernet_interfaces.id=interfaces.id where providernetworks='physnet0';") --providernets physnet0 --mtu 1500 controller-0
    $ neutron host-bind-interface --interface $(sudo -u postgres psql -qt -d sysinv -c "select uuid from ethernet_interfaces join interfaces on ethernet_interfaces.id=interfaces.id where providernetworks='physnet1';") --providernets physnet1 --mtu 1500 controller-0
    
    Which uses the information directly from the database, however the SQL
    query requests data from an unexistent column and throw the following
    error.
    
    controller-0:/home/wrsroot# sudo -u postgres psql -qt -d sysinv -c "select uuid from ethernet_interfaces join interfaces on ethernet_interfaces.id=interfaces.id where providernetworks='physnet0';"
    ERROR:  column "providernetworks" does not exist
    LINE 1: ...ces on ethernet_interfaces.id=interfaces.id where providerne...
                                                                 ^
    It turns out that both tables, ethernet_interfaces and interfaces
    doesn't have any providernetworks field. 
    
    Which is the correct column to get the completion of this command?
    or what would be the equivalent sysinv api request to get this
    information? 
    
    In any case I think we should update the wiki. 
    
    Thanks in advance. 
    
    -Erich
    
    - [0] https://wiki.openstack.org/wiki/StarlingX/Containers/Installation#Verify_the_cluster_endpoints
    _______________________________________________
    Starlingx-discuss mailing list
    Starlingx-discuss at lists.starlingx.io
    http://lists.starlingx.io/cgi-bin/mailman/listinfo/starlingx-discuss