On Fri, Jul 11, 2014 at 1:23 PM, Ashesh Vashi <ashesh.va...@enterprisedb.com > wrote:
> On Fri, Jul 11, 2014 at 1:20 PM, Dave Page <dp...@pgadmin.org> wrote: > >> >> >> >> On Fri, Jul 11, 2014 at 8:27 AM, Sandeep Thakkar < >> sandeep.thak...@enterprisedb.com> wrote: >> >>> There is no change in the build script. I opened the pgAdmin.sln and see >>> that the PG_SSL is not defined in the Preprocessor Definitions for x64 >>> platform. So, the change should be made in the source code. >>> >> >> Oh, how'd that happen I wonder? >> >> Ashesh, can you commit a fix for that please? Thanks. >> > Sure. > Thanks > Done in both REL-1_18_0_PATCHES branch and master branch. -- Ashesh > >> >>> >>> >>> On Thu, Jul 10, 2014 at 4:34 PM, Sandeep Thakkar < >>> sandeep.thak...@enterprisedb.com> wrote: >>> >>>> Sure. Looking into it. >>>> >>>> On Wed, Jul 9, 2014 at 3:30 PM, Dave Page <dp...@pgadmin.org> wrote: >>>> >>>>> Hi >>>>> >>>>> >>>>> On Tue, Jul 8, 2014 at 5:23 PM, Colin Wright < >>>>> colin.wri...@thinkwhere.com> wrote: >>>>> >>>>>> Hi Dave, >>>>>> >>>>>> >>>>>> >>>>>> It is always either the version bundled with PG 9.3.x downloaded from >>>>>> http://www.enterprisedb.com/products-services-training/pgdownload#windows >>>>>> , or the stand-alone version from >>>>>> http://www.postgresql.org/ftp/pgadmin3/release/v1.18.1/win32/ >>>>>> >>>>>> >>>>>> >>>>>> When I do set up PGAdmin with a copy of the server certificate it >>>>>> does connect to the database OK, so at least some of the SSL >>>>>> functionality >>>>>> must be there. >>>>>> >>>>>> >>>>>> >>>>> >>>>> OK, I checked the MSI package and the 32 and 64 bit PG installers from >>>>> EDB. I see this issue on the 64bit EDB installer only - the others are all >>>>> OK. >>>>> >>>>> Sandeep, can you look into this ASAP please - it's behaving as if >>>>> PG_SSL isn't defined. >>>>> >>>>> >>>>> >>>>>> *From:* Dave Page [mailto:dp...@pgadmin.org] >>>>>> *Sent:* 08 July 2014 16:52 >>>>>> *To:* Colin Wright >>>>>> *Cc:* pgadmin-support@postgresql.org >>>>>> *Subject:* Re: [pgadmin-support] SSL Mode in PGAdmin 1.18.1 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Tue, Jul 8, 2014 at 4:42 PM, Colin Wright < >>>>>> colin.wri...@thinkwhere.com> wrote: >>>>>> >>>>>> Hi, >>>>>> >>>>>> I’ve been trying to set up SSL connections to our postgres databases >>>>>> but I’m coming across some difficulties with the way the settings are >>>>>> working with the latest version of PGAdmin. Can someone tell me if these >>>>>> are known bugs with the use of SSL in PGAdmin 1.18.1 (windows 7), and if >>>>>> there are any work-arounds? >>>>>> >>>>>> >>>>>> >>>>>> The SSL drop-down is empty which I assume is a bug? It had a list of >>>>>> options in previous versions. >>>>>> >>>>>> >>>>>> >>>>>> When I try to connect to a database that forces SSL (using a >>>>>> self-signed certificate) it is failing to connect because of being unable >>>>>> to validate the certificate. Does this mean that PGAdmin is defaulting >>>>>> to either “verify-ca” or “verify-all” SSL option? Is there any way of >>>>>> changing this to “require” instead so that I don’t need to set up the >>>>>> server certificate on every PC running PGAdmin (given that the drop-down >>>>>> doesn’t have any options)? >>>>>> >>>>>> >>>>>> >>>>>> In PGAdmin 1.18.0 and earlier there was a list of SSL settings on the >>>>>> properties tab of the details pane for the connection, including whether >>>>>> or >>>>>> not you were using an encrypted connection. Is this information still >>>>>> available somehow as it can be useful confirmation that you are using an >>>>>> encrypted connection? >>>>>> >>>>>> >>>>>> >>>>>> Thanks in advance for any tips and advice you can provide >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> It sounds like your build has SSL disabled. Where did it come from? >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Dave Page >>>>>> Blog: http://pgsnake.blogspot.com >>>>>> Twitter: @pgsnake >>>>>> >>>>>> EnterpriseDB UK: http://www.enterprisedb.com >>>>>> The Enterprise PostgreSQL Company >>>>>> >>>>>> Colin Wright >>>>>> Principal Developer >>>>>> >>>>>> <http://www.thinkwhere.com> >>>>>> >>>>>> t: 01786 476060 (Office) >>>>>> t: 01786 476083 (Direct Dial) >>>>>> w:www.thinkwhere.com >>>>>> >>>>>> Glendevon House >>>>>> Castle Business Park >>>>>> Stirling FK9 4TZ >>>>>> <https://twitter.com/thinkWhere1> >>>>>> <http://www.linkedin.com/company/1509510?trk=companies_home_ycp_logo_forth-valley-gis> >>>>>> >>>>>> This email and its attachments are private and confidential. If you >>>>>> believe you have received this email in error, please contact the sender >>>>>> immediately on 01786 476060. If you are not the intended recipient, you >>>>>> may >>>>>> not rely on, use or disclose this email or any attachments in any way. >>>>>> >>>>>> thinkWhere Limited does not accept any liability for any damage that >>>>>> may be caused to the recipient's system or data by this email or any >>>>>> attachments. Please note that our email system may be subject to random >>>>>> monitoring by us. This Company accepts no liability for personal emails. >>>>>> >>>>>> thinkWhere is a limited company registered in Scotland with >>>>>> Registered Number SC315349 and having its Registered Office at Glendevon >>>>>> House, Castle Business Park, Stirling, FK9 4TZ. >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Dave Page >>>>> Blog: http://pgsnake.blogspot.com >>>>> Twitter: @pgsnake >>>>> >>>>> EnterpriseDB UK: http://www.enterprisedb.com >>>>> The Enterprise PostgreSQL Company >>>>> >>>> >>>> >>>> >>>> -- >>>> Sandeep Thakkar >>>> Senior Software Engineer >>>> >>>> >>>> Phone: +91.20.30589505 >>>> >>>> Website: www.enterprisedb.com >>>> EnterpriseDB Blog: http://blogs.enterprisedb.com/ >>>> Follow us on Twitter: http://www.twitter.com/enterprisedb >>>> >>>> This e-mail message (and any attachment) is intended for the use of the >>>> individual or entity to whom it is addressed. This message contains >>>> information from EnterpriseDB Corporation that may be privileged, >>>> confidential, or exempt from disclosure under applicable law. If you are >>>> not the intended recipient or authorized to receive this for the intended >>>> recipient, any use, dissemination, distribution, retention, archiving, or >>>> copying of this communication is strictly prohibited. If you have received >>>> this e-mail in error, please notify the sender immediately by reply e-mail >>>> and delete this message. >>>> >>> >>> >>> >>> -- >>> Sandeep Thakkar >>> Senior Software Engineer >>> >>> >>> Phone: +91.20.30589505 >>> >>> Website: www.enterprisedb.com >>> EnterpriseDB Blog: http://blogs.enterprisedb.com/ >>> Follow us on Twitter: http://www.twitter.com/enterprisedb >>> >>> This e-mail message (and any attachment) is intended for the use of the >>> individual or entity to whom it is addressed. This message contains >>> information from EnterpriseDB Corporation that may be privileged, >>> confidential, or exempt from disclosure under applicable law. If you are >>> not the intended recipient or authorized to receive this for the intended >>> recipient, any use, dissemination, distribution, retention, archiving, or >>> copying of this communication is strictly prohibited. If you have received >>> this e-mail in error, please notify the sender immediately by reply e-mail >>> and delete this message. >>> >> >> >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> > >