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@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