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

[Wensley, Barton]

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