On Thu, Mar 21, 2019 at 9:43 AM Miguel Duarte de Mora Barroso <mdbarroso@redhat.com> wrote:

>>
>> OK.
>> Is there a command to clean all so that I can restart with a new OVN setup in this infra?
>> I think I messed up too many things on it....
>>
>> Thanks,
>> Gianluca
>>
>
>
> I have deleted provider from web admin gui and then on manager from command line:
>
> ovn-nbctl lsp-del <port_name>
> for the ports defined and then
> ovn-nbctl destroy logical_switch <switch_name>
> for the defined switches.
>
> Then reboot of manager.
>
> Now I have on it:
> [root@ovmgr1 ~]# ovs-vsctl show
> eae54ff9-b86c-4050-8241-46f44336ba94
>     ovs_version: "2.10.1"
> [root@ovmgr1 ~]#
>
> [root@ovmgr1 ~]# ovn-nbctl show
> [root@ovmgr1 ~]#
>
> and no provider and/or networks on OVN in web admin gui.
>
> What could be the sequence to re-add an OVN provider now?
> From engine-setup or from web admin gui?

Through engine UI, through "Administration" -> "Providers" -> Add

> Any quick tip for? Any other commands (eg at db level) to verify all previous config is cleaned?

+Ales Musil could you indicate how to check the network list on the
engine's DB ? A query to filter all the external networks is what
we're after.

> Thanks
> Gianluca
>
>

In the mean time tested this on database, searching around tables:

 engine=# select name from providers;
          name          
------------------------
 ovirt-image-repository
(1 row)

engine=# 

engine=# select provider_network_provider_id,provider_network_external_id,provider_physical_network_id from network;
 provider_network_provider_id | provider_network_external_id | provider_physical_network_id 
------------------------------+------------------------------+------------------------------
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
(9 rows)

engine=# select provider_network_provider_id,provider_network_external_id,provider_physical_network_id from network_view ;
 provider_network_provider_id | provider_network_external_id | provider_physical_network_id 
------------------------------+------------------------------+------------------------------
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
                              |                              | 
(9 rows)

engine=# select * from provider_binding_host_id;
                vds_id                |    plugin_type     |           binding_host_id            
--------------------------------------+--------------------+--------------------------------------
 8ef1ce6f-4e38-486c-b3a4-58235f1f1d06 | OVIRT_PROVIDER_OVN | b8872ab5-4606-4a79-b77d-9d956a18d349
 9001bfea-d7d8-4ae4-aeaf-14a5e2d88d77 | OVIRT_PROVIDER_OVN | ddecf0da-4708-4f93-958b-6af365a5eeca
 d16e723c-b44c-4c1c-be76-c67911e47ccd | OVIRT_PROVIDER_OVN | 1dce5b7c-a9fc-4ddb-99b4-e2c9e0fa54c5
(3 rows)

The last seems to me the configuration of my 3 hosts... do I need to clean in any way it or can I say that it is a sort of default empty config without any network configured?

Thanks,
Gianluca