No SSL options

[Sebastian Sanitz]

Binary package hint: pgadmin3

I am unable to use the SSL-Options when creating a new server. Running Ubuntu Natty. Screenshot http://i.imgur.com/8GgcC.png

[Andreas Neumann (a-neumann)]

I am running into the same issue. One of my servers only allows SSL logins, which means that with Natty I am currently locked out.

I compiled pgadmin3 12.0.3 from source, but the issue also persists with the self-compiled version.

I will ask at the pgadmin3 mailing-list if they have a hint.

Andreas

[uoL (wmarcos)]

Same problem here, I'm completely lock too

Any news ?

Thanks,
Marcos.

[uoL (wmarcos)]

I've made it work by compiling the source code with:

cd
wget http://wwwmaster.postgresql.org/download/mirrors-ftp/pgadmin3/release/v1.12.3/src/pgadmin3-1.12.3.tar.gz
sudo apt-get install postgresql-server-dev-8.4
sudo apt-get install libwxgtk2.8-dev
sudo apt-get install libxml2-dev
sudo apt-get install libxslt1-dev
./configure
make
~/pgadmin3-1.12.3/pgadmin/pgadmin3 &

I hope you find it useful
Marcos.

[Eric Caudal - www.elico-corp.com (elicoidal)]

same problem here in 11.04. Tried complete removal in synaptic and reinstall: not successful.

[Walter Scheper (ratlaw)]

As an additional workaround you can manually set the SSL option in $HOME/.pgadmin3. Just create the server entry as usual and then close pgadmi3. Then edit $HOME/.pgadmin3 and change SSL=-1 to SSL=0, for "preferred." I wasn't able to permanently change SSL to "required."

[Sebastian Sanitz (sebastian-sanitz)]

Problem still unsolved in Ubtuntu 11.10

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Guillaume Lelarge (guillaume-lelarge-info)]

I applied a patch upstream to fix the behaviour. It should be available in 1.14.2, but you can also grab the patch: http://git.postgresql.org/gitweb/?p=pgadmin3.git;a=commit;h=65b188df52c1ae4e75ae89899d693d9a268662fd

[chrone (chrone81)]

thanks for the patch, looking forward for the official update. ssl is a must these days. :)