Re: browser disconnects from pgAdmin4 server

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

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    <<<<<


HTH!

On Wed, Oct 30, 2019 at 8:14 AM Gabriel S=C3=A1nchez <gabrielesanchez@gmail=
.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 b=
e
> used because it is not connected (and it won't reconnect).  My work-aroun=
d
> is to copy any open queries to a text editor, refresh the page, sign in t=
o
> 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
>
>

--=20

Look after your data, and your database will look after you. -- Simon Riggs

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 permanently
delete and destroy the original and any copies of the information.*

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

<div dir=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 encounte=
red this issue at my workplace as well. it turns out that our infrastructur=
e team needed to update our Ubuntu kernel to correct issues with the networ=
k stack. This didn&#39;t seem to bother our Windows users but regularly cau=
sed MacBook Pro running Mojave to drop network connections to the database =
server with great frequency:</div><div><pre class=3D"gmail-c-mrkdwn__pre" s=
tyle=3D"box-sizing:inherit;margin-top:4px;margin-bottom:4px;padding:8px;fon=
t-size:12px;line-height:1.50001;font-variant-ligatures:none;white-space:pre=
-wrap;word-break:normal;border-radius:4px;color:rgb(29,28,29);font-family:M=
onaco,Menlo,Consolas,&quot;Courier New&quot;,monospace"> =C2=A0[ Ubuntu: 4.=
15.0-66.75 ]<br style=3D"box-sizing:inherit"> =C2=A0 =C2=A0- tcp: fix tcp_e=
cn_withdraw_cwr() to clear TCP_ECN_QUEUE_CWR<br style=3D"box-sizing:inherit=
"> =C2=A0 =C2=A0- tcp: Reset send_head 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-segments from write-queue =C2=A0 =C2=A0&lt;&=
lt;&lt;&lt;&lt;<br style=3D"box-sizing:inherit"></pre></div><div><br></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=A1n=
chez &lt;<a href=3D"mailto:[email protected]">gabrielesanchez@gmail=
.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex"><div dir=3D"ltr">Hi all,<div><br></div><div>I have pgAdmin4 server runn=
ing 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 disconnects from the pgAdmin4 server after a long time, so u=
sually if I leave work 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 co=
nnected (and it won&#39;t reconnect).=C2=A0 My work-around is to copy any o=
pen queries to a text editor, refresh the page, sign in to pgAdmin, and ope=
n 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 any=
one in the community know how to make sessions last longer?=C2=A0 Perhaps t=
here 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"=
 class=3D"gmail_signature"><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"l=
tr"><div><div dir=3D"ltr"><div><div><p>Look after your data, and your datab=
ase will look after you. -- Simon Riggs</p><p><span style=3D"font-weight:bo=
ld;font-size:11pt;font-family:Arial;color:rgb(102,102,102)">Sheldon E. Stra=
uch</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 Services=C2=A0</span></i><span style=3D"font-size:11=
pt;font-family:Arial"><br>
</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>

--000000000000fcfde5059622cd3d--