<font face="Helvetica, Arial, sans-serif">Hello,<br /> I have pgsql server (Debian Wheezy, PGSQL 9.3) and pgadmin
1.18.1.<br/><br /> We have configured ssl auth outside LAN. We have keys protected wih password, because key without
passwordis like password written on paper on monitor:-)<br /><br /> I tested my key with linux desktop and
postgresql-client:<br/><br /> psql -h server.com -U postgres sslmode=require<br /><br /> and psql ask for password for
key- after writing all is ok, psql connect to server.<br /><br /> But with pgadmin - all defined (root.crt,
postgresql.crt,postgresql.key), but no asking for password for key.. And connection failed.. Log record:<br /><br />
2014-10-2816:42:37 INFO : Attempting to create a connection object...<br /> 2014-10-28 16:42:37 STATUS : Připojování
kdatabázi...<br /> 2014-10-28 16:42:37 INFO : Opening connection with connection string: host='server.com'
dbname='postgres'user='postgres' port=5432 sslmode=require
sslcert='C:\\Users\\Rob\\AppData\\Roaming\\postgresql\\postgresql-postgres.crt'
sslkey='C:\\Users\\Rob\\AppData\\Roaming\\postgresql\\postgresql-postgres.key'
sslrootcert='C:\\Users\\Rob\\AppData\\Roaming\\postgresql\\root.crt'sslcompression=0 application_name='pgAdmin III –
prohlížeč'<br/> 2014-10-28 16:42:37 STATUS : Připojování k databázi... (0,12 sec)<br /> 2014-10-28 16:42:37 ERROR :
Errorconnecting to the server: could not load private key file
"C:\Users\Rob\AppData\Roaming\postgresql\postgresql-postgres.key":problems getting password<br /><br /> All permission
seemsOK, process monitor shows only "success" when pgadmin access to key file..<br /><br /> But I don't know why no ask
passwordfor key???<br /> Thank you.<br /> Rob<br /><br /></font> <pre class="moz-signature" cols="72">--
Robert Bisom
<a class="moz-txt-link-abbreviated" href="mailto:robert.bisom@gmail.com">robert.bisom@gmail.com</a>
+420 736 606 800</pre>