
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