Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fPm0z-00041w-3r for pgadmin-hackers@arkaria.postgresql.org; Mon, 04 Jun 2018 09:43:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fPm0w-0002Ox-45 for pgadmin-hackers@arkaria.postgresql.org; Mon, 04 Jun 2018 09:42:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fPm0v-0002On-SE for pgadmin-hackers@lists.postgresql.org; Mon, 04 Jun 2018 09:42:58 +0000 Received: from mail-lf0-x242.google.com ([2a00:1450:4010:c07::242]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fPm0s-0008N8-LL for pgadmin-hackers@postgresql.org; Mon, 04 Jun 2018 09:42:57 +0000 Received: by mail-lf0-x242.google.com with SMTP id y20-v6so24168222lfy.0 for ; Mon, 04 Jun 2018 02:42:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=13s3YdMpn5hmGqyZAZtlJtrrsIIWcJoUoD6xdFN61TQ=; b=sbZIH5HHBhSeeNFq7yT5UO85CvIn9Ju65nZVy6nrsEOe9Ylq749VUOrUfwIUriIKNW qQpxvo8+kf/Lke7U6qM/lUxyaIf7O1Vg6TlwXkQt10Vio/AeimluXW9nt3hIDN/Ys79s wnfsQfLTB53QxPw+iqJgha0imEJHM8Op/RyMsH1HY30LVFoWsO2SBrfBefnK6B8g63mi crYFR5rz6Q++TbvZ4PKO/wSSES6i8JP7dR8ZKeKqQgdiSCPDQdNsU7lc9030O5Zpfz4Q ba3aLMBhImKhZDrx+tcNGjPbQV0WfPvWviX5b/zp7M1sklhruP8sjqV3+pNXYQbX8Yqs MKLg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=13s3YdMpn5hmGqyZAZtlJtrrsIIWcJoUoD6xdFN61TQ=; b=OLbpRBKw+lFf8IESxedvxmqDDMH0FZd2jdZCPHAxhbkfF7I23AO5VT6tv5zYHUedIy UEMT0XrT5HL72lR+TE/lHcQ3ew1nBVXXv6e7Sj5S994VxiPJoRQ/TKXqqst28z7pLOTd 70MLJWCy+/Y0lZ3AMRIIRrETR0yeIqsjvtglGExs0dBWOMGkxe/sKaL/i+M5wlln/LhV ECBZXbNla11kPahxr540TjxJZVRSAKe4abszNR034Z+vT/+fU8ujNQtn3w52bp4y+qrz 7xL5zQ2IM6rA+HFujU/HLPH8Qs6VdsRQ7T3m9yo4Az+wPw94XjUbqykpns0u1zeva1bW qOYQ== X-Gm-Message-State: ALKqPwfXok1ZY8+IFP/wh3YAOQ7KKSBJg46wEnRfUs+O/ipo4J3iE3Bz RJsan5aScAxg6UfsWglJX9qWe6Bs9s/WIAi4w+t0VA== X-Google-Smtp-Source: ADUXVKJqn9NbpzRg330gFSO41mgo8LXhpfbaC0tsOL0KDQQfGuUj0IMv2ag1sSyyv6yh0dl5qdjbXVjFoty9BBNMADg= X-Received: by 2002:a19:5c4b:: with SMTP id q72-v6mr11851676lfb.128.1528105373927; Mon, 04 Jun 2018 02:42:53 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a2e:9e8a:0:0:0:0:0 with HTTP; Mon, 4 Jun 2018 02:42:53 -0700 (PDT) In-Reply-To: References: From: Aditya Toshniwal Date: Mon, 4 Jun 2018 15:12:53 +0530 Message-ID: Subject: Re: [pgAdmin4][RM#3307]User interface unable to connect to database running on port range 1-1024 To: Dave Page Cc: Victoria Henry , pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000fe22ff056dcdc18e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000fe22ff056dcdc18e Content-Type: text/plain; charset="UTF-8" Hi Hackers, I missed one part here. There is a constraint on port in in sqlite config database also, and is not allowing ports below 1024. PFA patch - part2 which includes constraint change and migration script for the db file. Kindly review. Thanks and Regards, Aditya Toshniwal Software Engineer | EnterpriseDB Software Solutions | Pune "Don't Complain about Heat, Plant a tree" On Fri, May 18, 2018 at 3:43 PM, Dave Page wrote: > Thanks, applied. > > On Wed, May 16, 2018 at 2:34 PM, Victoria Henry wrote: > >> Hi Aditya, >> >> Looks good to us! >> >> Sincerely, >> >> Anthony & Victoria >> >> >> On Wed, May 16, 2018 at 7:24 AM Aditya Toshniwal < >> aditya.toshniwal@enterprisedb.com> wrote: >> >>> Hi Hackers, >>> >>> PFA patch to allow server port number below 1024 till 1 in Create Server >>> dialog. >>> >>> Thanks and Regards, >>> Aditya Toshniwal >>> Software Engineer | EnterpriseDB Software Solutions | Pune >>> "Don't Complain about Heat, Plant a tree" >>> >> > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > --000000000000fe22ff056dcdc18e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Hackers,

I missed one part here. The= re is a constraint on port in in sqlite config database also, and is not al= lowing ports below 1024.
PFA patch - part2 which includes constra= int change and migration script for the db file.
Kindly review.

Thanks and Regards,
Aditya Toshniwal
Software Engineer |=C2=A0EnterpriseDB Software Solutions= |=C2=A0Pune
"Don't Complain about Heat, Plant a tree&quo= t;

On Fri, May 18, 2018 at 3:43 PM, Dave Page <= span dir=3D"ltr"><dpage@pgadmin.org> wrote:
=
Thanks, applied.

On Wed, May 16, 2018 at 2:34 P= M, Victoria Henry <vhenry@pivotal.io> wrote:
Hi Aditya,

Looks goo= d to us!

Sincerely,

Antho= ny & Victoria


On Wed, May 16, 2018 at 7:24 AM Aditya Toshniwal &l= t;ad= itya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

PFA patch = to allow server port number below 1024 till 1 in Create Server dialog.

Thanks and R= egards,
Aditya Toshn= iwal
So= ftware Engineer |=C2=A0EnterpriseDB Software Solutions |=C2=A0Pune
"Don't Complain about Heat, Plant a tree"



<= /div>--
Dave= Page
Blog: ht= tp://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: = http://www.enterp= risedb.com
The Enterprise PostgreSQL Company

--000000000000fe22ff056dcdc18e--