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 1fPm1w-00044z-IS for pgadmin-hackers@arkaria.postgresql.org; Mon, 04 Jun 2018 09:44:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fPm1v-0002rb-00 for pgadmin-hackers@arkaria.postgresql.org; Mon, 04 Jun 2018 09:43:58 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fPm1u-0002rR-JC for pgadmin-hackers@lists.postgresql.org; Mon, 04 Jun 2018 09:43:58 +0000 Received: from mail-lf0-x241.google.com ([2a00:1450:4010:c07::241]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fPm1m-0002DX-9J for pgadmin-hackers@postgresql.org; Mon, 04 Jun 2018 09:43:57 +0000 Received: by mail-lf0-x241.google.com with SMTP id y20-v6so24172228lfy.0 for ; Mon, 04 Jun 2018 02:43:49 -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=E6qSVEOr6Rstf7mxNN9/80zxruxx8TF3VVcP3RMQeb8=; b=NCRwDAQCMDHJt/+ck9/zmSh5Uy/5WZ9cmwOyWQMXtrtdKIAZ606whFr5GMeUyt10ef u/bFdSqhAwkM58kplA0I8oLUJjTPGbwRh5sw4KqZGfIqRLvkzqEYlJqoDofYS9+7fpQR LdbV49DWdsWNLHA8kI5Jbwmi94FRoJvWAnAJJQs8b1f6PZevGS0OASasfi63gGYpsyTd iQN9N+DtuhD2cA0Uj/94ccn0hCYyJy/lIjqeFzvUv15pb/ko8gtqPU/MoqZWtCOVNKOQ 8BC9qrwn2j6jNpoUEpDJdaweeqOqSyP9+ClY/PZLdU4w2VmX55Wp+aFlMK/Yp7fHfKzm vLug== 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=E6qSVEOr6Rstf7mxNN9/80zxruxx8TF3VVcP3RMQeb8=; b=YOdtCTO3f/tovRJVdMov/xNmy63z6mLtczd0yLy+h0AjuVkQaXL6Lc6/4Qq2VehfuJ KYbd3BItEYBoeBCMOZv1mmMn1R3k0pqTRDHeRM7XF78SZ7kyR51bZvOmAtT9xU3ajJwt 0sg4us+cONM2lc78xYmsWm9h2QIWOh/494zaW4HMVKT1Va85fNuY5sCk9awMYWgyiLNr s8LpiRk2EZU938i29IlBSfYI2IJLKQN3fR/0/5ddlputPzD1LFNfoQwuMbUu17RArDas HCThYx3ZVsPz3ZA7JdGzxfJ6qvqfBOXbkADgSyyzCHKhBKPbDS1PGmsSrf5fasHnfvJt vogg== X-Gm-Message-State: ALKqPwcNFwu83NAUXykmRHpZoYAQANXOBi8wAqOGSzDtXsbP1Dei3AvE sPqSuXyKEvbhDd0plD/1yKp2KFfwVeVvHVwoxANv1g== X-Google-Smtp-Source: ADUXVKIhVq8HXTtAFijjEfozxwkxe48OETezJOTnaBJxRFoFINt4D7FR2l77gMTCaMmku2CXdwE8JAeH11kOWb8DN2k= X-Received: by 2002:a19:1156:: with SMTP id g83-v6mr11830814lfi.142.1528105428307; Mon, 04 Jun 2018 02:43:48 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a2e:9e8a:0:0:0:0:0 with HTTP; Mon, 4 Jun 2018 02:43:47 -0700 (PDT) In-Reply-To: References: From: Aditya Toshniwal Date: Mon, 4 Jun 2018 15:13:47 +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/mixed; boundary="0000000000003c0177056dcdc5b3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000003c0177056dcdc5b3 Content-Type: multipart/alternative; boundary="0000000000003c0173056dcdc5b1" --0000000000003c0173056dcdc5b1 Content-Type: text/plain; charset="UTF-8" Missed the attachment. Apologies :( PFA. Thanks and Regards, Aditya Toshniwal Software Engineer | EnterpriseDB Software Solutions | Pune "Don't Complain about Heat, Plant a tree" On Mon, Jun 4, 2018 at 3:12 PM, Aditya Toshniwal < aditya.toshniwal@enterprisedb.com> wrote: > 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 >> > > --0000000000003c0173056dcdc5b1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Missed the attachment. Apologies :(

PFA= .

Thanks and Regards,
Aditya Toshniwal
Software Engineer |=C2=A0EnterpriseDB Software Sol= utions |=C2=A0Pune
"Don't Complain about Heat, Plant a tr= ee"

On Mon, Jun 4, 2018 at 3:12 PM, Aditya Toshn= iwal <aditya.toshniwal@enterprisedb.com> wro= te:
Hi Hackers,

=
I missed one part here. There is a constraint on port in in sqli= te config database also, and is not allowing ports below 1024.
PF= A patch - part2 which includes constraint change and migration script for t= he db file.
Kindly review.
=
<= div dir=3D"ltr">Thanks and Regards,
Aditya Toshniwal
Software Engineer |=C2=A0EnterpriseDB Software Solution= s |=C2=A0Pune
<= font color=3D"#38761d">"Don't Complain about Heat, Plant a tree&qu= ot;

On Fri, May 18= , 2018 at 3:43 PM, Dave Page <dpage@pgadmin.org> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">
Thanks, applied.

On Wed, May 16, 2018 at 2:34 PM, Victoria Henry <vhen= ry@pivotal.io> wrote:
Hi Aditya,

Looks good to us!

<= /div>
Sincerely,

Anthony & Victoria
<= div>

On Wed, May 16, 2018 at 7:24 AM A= ditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Hackers,

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

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



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

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


--0000000000003c0173056dcdc5b1-- --0000000000003c0177056dcdc5b3 Content-Type: text/x-patch; charset="US-ASCII"; name="RM3307_part2.patch" Content-Disposition: attachment; filename="RM3307_part2.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_ji02iht90 ZGlmZiAtLWdpdCBhL3dlYi9taWdyYXRpb25zL3ZlcnNpb25zLzdjNTZlYTI1MDA4NV8ucHkgYi93 ZWIvbWlncmF0aW9ucy92ZXJzaW9ucy83YzU2ZWEyNTAwODVfLnB5Cm5ldyBmaWxlIG1vZGUgMTAw NjQ0CmluZGV4IDAwMDAwMDAuLjI0YWYzNDkKLS0tIC9kZXYvbnVsbAorKysgYi93ZWIvbWlncmF0 aW9ucy92ZXJzaW9ucy83YzU2ZWEyNTAwODVfLnB5CkBAIC0wLDAgKzEsOTAgQEAKKworIiIiQ2hh bmdlIHNlcnZlciBwb3J0IGNvbnN0cmFpbnQgdG8gYWxsb3cgcG9ydCBiZWxvdyAxMDI0IFJNIzMz MDcKKworUmV2aXNpb24gSUQ6IDdjNTZlYTI1MDA4NQorUmV2aXNlczogYTY4YjM3NGZlMzczCitD cmVhdGUgRGF0ZTogMjAxOC0wNi0wNCAxNDoyMzozMS40NzI2NDUKKworIiIiCitmcm9tIGFsZW1i aWMgaW1wb3J0IG9wCitpbXBvcnQgc3FsYWxjaGVteSBhcyBzYQorCitmcm9tIHBnYWRtaW4ubW9k ZWwgaW1wb3J0IGRiCisKKyMgcmV2aXNpb24gaWRlbnRpZmllcnMsIHVzZWQgYnkgQWxlbWJpYy4K K3JldmlzaW9uID0gJzdjNTZlYTI1MDA4NScKK2Rvd25fcmV2aXNpb24gPSAnYTY4YjM3NGZlMzcz JworYnJhbmNoX2xhYmVscyA9IE5vbmUKK2RlcGVuZHNfb24gPSBOb25lCisKKworZGVmIHVwZ3Jh ZGUoKToKKyAgICAjIFRvIFNhdmUgcHJldmlvdXMgZGF0YQorICAgIGRiLmVuZ2luZS5leGVjdXRl KCJBTFRFUiBUQUJMRSBzZXJ2ZXIgUkVOQU1FIFRPIHNlcnZlcl9vbGQiKQorCisgICAgIyBDcmVh dGUgdGFibGUgd2l0aCBuZXcgY29uc3RyYWludCBkZWZpbml0aW9uCisgICAgZGIuZW5naW5lLmV4 ZWN1dGUoIiIiCisgICAgICAgICAgICBDUkVBVEUgVEFCTEUgc2VydmVyICgKKyAgICAgICAgICAg IGlkCUlOVEVHRVIgTk9UIE5VTEwsCisgICAgICAgICAgICB1c2VyX2lkCUlOVEVHRVIgTk9UIE5V TEwsCisgICAgICAgICAgICBzZXJ2ZXJncm91cF9pZAlJTlRFR0VSIE5PVCBOVUxMLAorICAgICAg ICAgICAgbmFtZQlWQVJDSEFSKDEyOCkgTk9UIE5VTEwsCisgICAgICAgICAgICBob3N0CVZBUkNI QVIoMTI4KSwKKyAgICAgICAgICAgIHBvcnQJSU5URUdFUiBOT1QgTlVMTCBDSEVDSyhwb3J0ID49 IDEgQU5EIHBvcnQgPD0gNjU1MzQpLAorICAgICAgICAgICAgbWFpbnRlbmFuY2VfZGIJVkFSQ0hB Uig2NCksCisgICAgICAgICAgICB1c2VybmFtZQlWQVJDSEFSKDY0KSBOT1QgTlVMTCwKKyAgICAg ICAgICAgIHBhc3N3b3JkCVZBUkNIQVIoNjQpLAorICAgICAgICAgICAgcm9sZQlWQVJDSEFSKDY0 KSwKKyAgICAgICAgICAgIHNzbF9tb2RlCVZBUkNIQVIoMTYpIE5PVCBOVUxMIENIRUNLKHNzbF9t b2RlIElOCisgICAgICAgICAgICAgICAgKCAnYWxsb3cnICwgJ3ByZWZlcicgLCAncmVxdWlyZScg LCAnZGlzYWJsZScgLAorICAgICAgICAgICAgICAgICAgJ3ZlcmlmeS1jYScgLCAndmVyaWZ5LWZ1 bGwnICkKKyAgICAgICAgICAgICksCisgICAgICAgICAgICBjb21tZW50CVZBUkNIQVIoMTAyNCks CisgICAgICAgICAgICBkaXNjb3ZlcnlfaWQJVkFSQ0hBUigxMjgpLAorICAgICAgICAgICAgaG9z dGFkZHIJVEVYVCgxMDI0KSwKKyAgICAgICAgICAgIGRiX3JlcwlURVhULAorICAgICAgICAgICAg cGFzc2ZpbGUJVEVYVCwKKyAgICAgICAgICAgIHNzbGNlcnQJVEVYVCwKKyAgICAgICAgICAgIHNz bGtleQlURVhULAorICAgICAgICAgICAgc3Nscm9vdGNlcnQJVEVYVCwKKyAgICAgICAgICAgIHNz bGNybAlURVhULAorICAgICAgICAgICAgc3NsY29tcHJlc3Npb24JSU5URUdFUiBERUZBVUxUIDAs CisgICAgICAgICAgICBiZ2NvbG9yIFRFWFQoMTApLAorICAgICAgICAgICAgZmdjb2xvciBURVhU KDEwKSwKKyAgICAgICAgICAgIHNlcnZpY2UgVEVYVCwKKyAgICAgICAgICAgIHVzZV9zc2hfdHVu bmVsIElOVEVHRVIgREVGQVVMVCAwLAorICAgICAgICAgICAgdHVubmVsX2hvc3QgVEVYVCwKKyAg ICAgICAgICAgIHR1bm5lbF9wb3J0IFRFWFQsCisgICAgICAgICAgICB0dW5uZWxfdXNlcm5hbWUg VEVYVCwKKyAgICAgICAgICAgIHR1bm5lbF9hdXRoZW50aWNhdGlvbiBJTlRFR0VSIERFRkFVTFQg MCwKKyAgICAgICAgICAgIHR1bm5lbF9pZGVudGl0eV9maWxlIFRFWFQsCisgICAgICAgICAgICBQ UklNQVJZIEtFWShpZCksCisgICAgICAgICAgICBGT1JFSUdOIEtFWSh1c2VyX2lkKSBSRUZFUkVO Q0VTIHVzZXIoaWQpLAorICAgICAgICAgICAgRk9SRUlHTiBLRVkoc2VydmVyZ3JvdXBfaWQpIFJF RkVSRU5DRVMgc2VydmVyZ3JvdXAoaWQpCisgICAgICAgICkKKyAgICAiIiIpCisKKyAgICAjIENv cHkgb2xkIGRhdGEgYWdhaW4gaW50byB0YWJsZQorICAgIGRiLmVuZ2luZS5leGVjdXRlKCIiIgor ICAgIElOU0VSVCBJTlRPIHNlcnZlciAoCisgICAgICAgIGlkLCB1c2VyX2lkLCBzZXJ2ZXJncm91 cF9pZCwgbmFtZSwgaG9zdCwgcG9ydCwgbWFpbnRlbmFuY2VfZGIsCisgICAgICAgIHVzZXJuYW1l LCBwYXNzd29yZCwgcm9sZSwgc3NsX21vZGUsIGNvbW1lbnQsIGRpc2NvdmVyeV9pZCwgaG9zdGFk ZHIsCisgICAgICAgIGRiX3JlcywgcGFzc2ZpbGUsIHNzbGNlcnQsIHNzbGtleSwgc3Nscm9vdGNl cnQsIHNzbGNybCwKKyAgICAgICAgc3NsY29tcHJlc3Npb24sIGJnY29sb3IsIGZnY29sb3IsIHNl cnZpY2UsIHVzZV9zc2hfdHVubmVsLAorICAgICAgICB0dW5uZWxfaG9zdCwgdHVubmVsX3BvcnQs IHR1bm5lbF91c2VybmFtZSwgdHVubmVsX2F1dGhlbnRpY2F0aW9uLAorICAgICAgICB0dW5uZWxf aWRlbnRpdHlfZmlsZQorCisgICAgKSBTRUxFQ1QKKyAgICAgICAgaWQsIHVzZXJfaWQsIHNlcnZl cmdyb3VwX2lkLCBuYW1lLCBob3N0LCBwb3J0LCBtYWludGVuYW5jZV9kYiwKKyAgICAgICAgdXNl cm5hbWUsIHBhc3N3b3JkLCByb2xlLCBzc2xfbW9kZSwgY29tbWVudCwgZGlzY292ZXJ5X2lkLCBo b3N0YWRkciwKKyAgICAgICAgZGJfcmVzLCBwYXNzZmlsZSwgc3NsY2VydCwgc3Nsa2V5LCBzc2xy b290Y2VydCwgc3NsY3JsLAorICAgICAgICBzc2xjb21wcmVzc2lvbiwgYmdjb2xvciwgZmdjb2xv ciwgc2VydmljZSwgdXNlX3NzaF90dW5uZWwsCisgICAgICAgIHR1bm5lbF9ob3N0LCB0dW5uZWxf cG9ydCwgdHVubmVsX3VzZXJuYW1lLCB0dW5uZWxfYXV0aGVudGljYXRpb24sCisgICAgICAgIHR1 bm5lbF9pZGVudGl0eV9maWxlCisgICAgRlJPTSBzZXJ2ZXJfb2xkIiIiKQorCisgICAgIyBSZW1v dmUgb2xkIGRhdGEKKyAgICBkYi5lbmdpbmUuZXhlY3V0ZSgiRFJPUCBUQUJMRSBzZXJ2ZXJfb2xk IikKKworZGVmIGRvd25ncmFkZSgpOgorICAgIHBhc3MKZGlmZiAtLWdpdCBhL3dlYi9wZ2FkbWlu L21vZGVsL19faW5pdF9fLnB5IGIvd2ViL3BnYWRtaW4vbW9kZWwvX19pbml0X18ucHkKaW5kZXgg YzMxNzFjZS4uZGY4ODExNiAxMDA2NDQKLS0tIGEvd2ViL3BnYWRtaW4vbW9kZWwvX19pbml0X18u cHkKKysrIGIvd2ViL3BnYWRtaW4vbW9kZWwvX19pbml0X18ucHkKQEAgLTI5LDcgKzI5LDcgQEAg ZnJvbSBmbGFza19zcWxhbGNoZW15IGltcG9ydCBTUUxBbGNoZW15CiAjCiAjIyMjIyMjIyMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIwogCi1TQ0hFTUFfVkVSU0lPTiA9IDE1CitTQ0hFTUFfVkVSU0lPTiA9IDE2CiAKICMjIyMj IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj IyMjIyMjIyMjIyMjCiAjCkBAIC0xMTEsNyArMTExLDcgQEAgY2xhc3MgU2VydmVyKGRiLk1vZGVs KToKICAgICBob3N0YWRkciA9IGRiLkNvbHVtbihkYi5TdHJpbmcoMTI4KSwgbnVsbGFibGU9VHJ1 ZSkKICAgICBwb3J0ID0gZGIuQ29sdW1uKAogICAgICAgICBkYi5JbnRlZ2VyKCksCi0gICAgICAg IGRiLkNoZWNrQ29uc3RyYWludCgncG9ydCA+PSAxMDI0IEFORCBwb3J0IDw9IDY1NTM0JyksCisg ICAgICAgIGRiLkNoZWNrQ29uc3RyYWludCgncG9ydCA+PSAxIEFORCBwb3J0IDw9IDY1NTM0Jyks CiAgICAgICAgIG51bGxhYmxlPUZhbHNlKQogICAgIG1haW50ZW5hbmNlX2RiID0gZGIuQ29sdW1u KGRiLlN0cmluZyg2NCksIG51bGxhYmxlPVRydWUpCiAgICAgdXNlcm5hbWUgPSBkYi5Db2x1bW4o ZGIuU3RyaW5nKDY0KSwgbnVsbGFibGU9RmFsc2UpCg== --0000000000003c0177056dcdc5b3--