ssl connection with key with password
От | Robert Bisom |
---|---|
Тема | ssl connection with key with password |
Дата | |
Msg-id | 544FBF1E.7030703@gmail.com обсуждение исходный текст |
Список | pgadmin-support |
<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>
В списке pgadmin-support по дате отправления: