Re: browser disconnects from pgAdmin4 server

--0000000000005b46ee0596231c9e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Oct 30, 2019 at 11:58 AM Strauch, Sheldon <[email protected]>
wrote:

> Hello Gabriel!
>
> Are you using an Apple Mac as your laptop per chance? We encountered this
> issue at my workplace as well. it turns out that our infrastructure team
> needed to update our Ubuntu kernel to correct issues with the network
> stack. This didn't seem to bother our Windows users but regularly caused
> MacBook Pro running Mojave to drop network connections to the database
> server with great frequency:
>
>   [ Ubuntu: 4.15.0-66.75 ]
>     - tcp: fix tcp_ecn_withdraw_cwr() to clear TCP_ECN_QUEUE_CWR
>     - tcp: Reset send_head when removing skb from write-queue  <<<<<
>     - tcp: Don't dequeue SYN/FIN-segments from write-queue    <<<<<
>
>
>
I run Ubuntu 18.04 desktop on a Lenovo laptop, and it's up to date, but
perhaps it has the same issue.  Still, this doesn't happen with other
websites, as far as I can tell.


> HTH!
>
> On Wed, Oct 30, 2019 at 8:14 AM Gabriel S=C3=A1nchez <gabrielesanchez@gma=
il.com>
> wrote:
>
>> Hi all,
>>
>> I have pgAdmin4 server running on Ubuntu 18.04 server with Apache, and I
>> connect to it from my laptop using Firefox, which works well.  One
>> inconvenience is that my browser's session disconnects from the pgAdmin4
>> server after a long time, so usually if I leave work pending at night to=
 be
>> continued the next day, when I resume work in the morning pgAdmin can't =
be
>> used because it is not connected (and it won't reconnect).  My work-arou=
nd
>> is to copy any open queries to a text editor, refresh the page, sign in =
to
>> pgAdmin, and open new tabs and copy the queries back from my text editor=
.
>> Of course, any temporary tables are lost and I must also recreate them.
>> Does anyone in the community know how to make sessions last longer?
>> Perhaps there is a setting in one of the pgAdmin config files or Apache?
>>
>> Thanks,
>> Gabriel
>>
>>
>
> --
>
> Look after your data, and your database will look after you. -- Simon Rig=
gs
>
> Sheldon E. Strauch
> *Data Architect, Data Services *
> *O* 312-676-1556
> *M* 224-723-3878
>
> *Enova International, Inc.*
> *This transmission is confidential and may be privileged or proprietary.
> If you are not the intended recipient, you are not authorized to use the
> information in this transmission in any way. Please inform the sender
> immediately if you have received this transmission in error and permanent=
ly
> delete and destroy the original and any copies of the information.*
>

--0000000000005b46ee0596231c9e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"></div><br><div class=3D"gmail_quote"><div=
 dir=3D"ltr" class=3D"gmail_attr">On Wed, Oct 30, 2019 at 11:58 AM Strauch,=
 Sheldon &lt;<a href=3D"mailto:[email protected]">[email protected]</a>&g=
t; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0p=
x 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div d=
ir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Hello Gabriel!<div><br></div><=
div>Are you using an Apple Mac as your laptop per chance? We encountered th=
is issue at my workplace as well. it turns out that our infrastructure team=
 needed to update our Ubuntu kernel to correct issues with the network stac=
k. This didn&#39;t seem to bother our Windows users but regularly caused Ma=
cBook Pro running Mojave to drop network connections to the database server=
 with great frequency:</div><div><pre style=3D"box-sizing:inherit;margin-to=
p:4px;margin-bottom:4px;padding:8px;font-size:12px;line-height:1.50001;font=
-variant-ligatures:none;white-space:pre-wrap;word-break:normal;border-radiu=
s:4px;color:rgb(29,28,29);font-family:Monaco,Menlo,Consolas,&quot;Courier N=
ew&quot;,monospace"> =C2=A0[ Ubuntu: 4.15.0-66.75 ]<br style=3D"box-sizing:=
inherit"> =C2=A0 =C2=A0- tcp: fix tcp_ecn_withdraw_cwr() to clear TCP_ECN_Q=
UEUE_CWR<br style=3D"box-sizing:inherit"> =C2=A0 =C2=A0- tcp: Reset send_he=
ad when removing skb from write-queue =C2=A0&lt;&lt;&lt;&lt;&lt;<br style=
=3D"box-sizing:inherit"> =C2=A0 =C2=A0- tcp: Don&#39;t dequeue SYN/FIN-segm=
ents from write-queue =C2=A0 =C2=A0&lt;&lt;&lt;&lt;&lt;<br style=3D"box-siz=
ing:inherit"></pre></div><div><br></div></div></div></div></blockquote><div=
><br></div><div>I run Ubuntu 18.04 desktop on a Lenovo laptop, and it&#39;s=
 up to date, but perhaps it has the same issue.=C2=A0 Still, this doesn&#39=
;t happen with other websites, as far as I can tell.</div><div>=C2=A0</div>=
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=
=3D"ltr"><div dir=3D"ltr"><div></div><div>HTH!</div></div></div></div><br><=
div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Oct=
 30, 2019 at 8:14 AM Gabriel S=C3=A1nchez &lt;<a href=3D"mailto:gabrielesan=
[email protected]" target=3D"_blank">[email protected]</a>&gt; wrote:<=
br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"=
>Hi all,<div><br></div><div>I have pgAdmin4 server running on Ubuntu 18.04 =
server with Apache, and I connect to it from my laptop using Firefox, which=
 works well.=C2=A0 One inconvenience is that my browser&#39;s session disco=
nnects from the pgAdmin4 server after a long time, so usually if I leave wo=
rk pending at night to be continued the next day, when I resume work in the=
 morning pgAdmin can&#39;t be used because it is not connected (and it won&=
#39;t reconnect).=C2=A0 My work-around is to copy any open queries to a tex=
t editor, refresh the page, sign in to pgAdmin, and open new tabs and copy =
the queries back from my text editor.=C2=A0 Of course, any temporary tables=
 are lost and I must also recreate them.=C2=A0 Does anyone in the community=
 know how to make sessions last longer?=C2=A0 Perhaps there is a setting in=
 one of the pgAdmin config files or Apache?</div><div><br></div><div>Thanks=
,</div><div>Gabriel</div><div><br></div></div>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=
=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr">=
<div><div><p>Look after your data, and your database will look after you. -=
- Simon Riggs</p><p><span style=3D"font-weight:bold;font-size:11pt;font-fam=
ily:Arial;color:rgb(102,102,102)">Sheldon E. Strauch</span><b><span style=
=3D"font-size:11pt;font-family:Arial"><br></span></b><i><span style=3D"font=
-size:11pt;font-family:Arial;color:rgb(102,102,102)">Data Architect, Data S=
ervices=C2=A0</span></i><span style=3D"font-size:11pt;font-family:Arial"><b=
r>
</span><b><span style=3D"font-size:11pt;font-family:Arial;color:rgb(102,102=
,102)">O</span></b><span style=3D"font-size:11pt;font-family:Arial;color:rg=
b(102,102,102)">=C2=A0</span><span style=3D"color:rgb(51,51,51);font-family=
:Arial,sans-serif;font-size:14px;line-height:20px">312-676-1556</span><span=
 style=3D"font-size:11pt;font-family:Arial"><br>
</span><b><span style=3D"font-size:11pt;font-family:Arial;color:rgb(102,102=
,102)">M</span></b><span style=3D"font-size:11pt;font-family:Arial;color:rg=
b(102,102,102)">=C2=A0</span><span style=3D"color:rgb(51,51,51);font-family=
:Arial,sans-serif;font-size:14px;line-height:20px">224-723-3878</span></p><=
p><span style=3D"font-size:12pt;font-family:Arial;color:rgb(17,85,204)"></s=
pan><span style=3D"font-size:12pt;font-family:Arial;color:rgb(17,85,204)"><=
/span><span style=3D"font-size:12pt;font-family:Arial;color:rgb(17,85,204)"=
></span><span style=3D"font-size:12pt;font-family:Arial;color:rgb(17,85,204=
)"></span><span style=3D"font-size:12pt;font-family:Arial;color:rgb(17,85,2=
04)"></span><span style=3D"font-size:12pt;font-family:Arial"></span></p>

<b><span style=3D"font-size:11pt;font-family:Arial;color:rgb(102,102,102)">=
Enova
International, Inc.</span></b><span style=3D"font-size:11pt;font-family:Ari=
al;color:rgb(102,102,102)"><br>
</span><i><span style=3D"font-size:11pt;font-family:Arial;color:rgb(127,127=
,127)">This
transmission is confidential and may be privileged or proprietary. If you a=
re
not the intended recipient, you are not authorized to use the information i=
n
this transmission in any way. Please inform the sender immediately if you h=
ave
received this transmission in error and permanently delete and destroy the
original and any copies of the information.</span></i>=C2=A0 =C2=A0=C2=A0<b=
r></div></div></div></div></div></div></div></div></div></div></div></div><=
/div></div></div></div>
</blockquote></div></div>

--0000000000005b46ee0596231c9e--