[Users] Documentation: Storage Domain conversion from Data Domain to Export Domain

[Bob Doolittle]

On 11/26/2013 04:25 PM, Gianluca Cecchi wrote:
> On Tue, Nov 26, 2013 at 10:11 PM, Bob Doolittle  wrote:
>> On 11/26/2013 03:27 PM, Dafna Ron wrote:
>>> sql -U postgres engine -c 'select connection from
>>> storage_server_connections;'
>>
>> I guess you mean psql. But I keep getting an authentication error. I don't
>> see any obvious passwords in the postgresql.conf file, nor in my
>> setup/install logs. Is there a hardcoded password somewhere?
>>
>> I've tried different users - admin, postgres, engine, and I've tried all of
>> those with the admin password I specified during setup. No dice.
> As a workaroud possibly:
>
> - establish an ssh connection as root with the engine server
>
> - switch to postgres user
> [root at f18engine ~]# su - postgres
>
> - connect to engine database
> -bash-4.2$ psql engine
> psql (9.2.5)
> Type "help" for help.
>
> - execute the query
> engine=# select connection from storage_server_connections;
>                    connection
> -----------------------------------------------
>   f18engine.mydomain:/var/lib/exports/iso
>   f18ovn01.mydomain:gvdata
> (2 rows)
>
>
> It work for me with 3.3.1 on f19

Brilliant, thanks!

Yes this works, and produces:

engine=# select connection from storage_server_connections;
                  connection
---------------------------------------------
  ovirt-vm.smartcity.net:/var/lib/exports/iso
  172.16.0.58:/export/VM_EXPORTDOMAIN
  172.16.0.58:/export/VM_DATADOMAIN
(3 rows)


So that's strange - the /export/VM_EXPORTDOMAIN is in fact the export 
domain I am trying (and failing) to import.
Note that the first time I tried this it failed, because of a firewall 
running on the Host. I wonder if that left some bad state in the DB.

So, is there some way I can clear this out?

Thanks,
    Bob