ssl connection with key with password

From: Robert Bisom <robert(dot)bisom(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: ssl connection with key with password
Date: 2014-10-28 16:06:54
Message-ID: 544FBF1E.7030703@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

<html>
<head>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-2">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<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 password is 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-28 16:42:37 INFO   : Attempting to create a connection
object...<br>
2014-10-28 16:42:37 STATUS : Připojování k databá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 &#8211; 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  : Error connecting 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 seems OK, process monitor shows only "success" when
pgadmin access to key file..<br>
<br>
But I don't know why no ask password for 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(dot)bisom(at)gmail(dot)com">robert(dot)bisom(at)gmail(dot)com</a>
+420 736 606 800</pre>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.3 KB

Browse pgadmin-support by date

  From Date Subject
Next Message chenhj 2014-10-29 09:42:03 pgAdminIII will crash when connect failed
Previous Message Petr Vejsada 2014-10-27 17:54:45 Syntax error when modifying materialized view