public inbox for [email protected]  
help / color / mirror / Atom feed
Experiencing issues
22+ messages / 4 participants
[nested] [flat]

* Experiencing issues
@ 2018-03-21 14:11 Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Dave Page <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  0 siblings, 2 replies; 22+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 14:11 UTC (permalink / raw)
  To: pgadmin-hackers

Hello Hackers,
Can anyone use the current master branch?
When I try to open a server I get a 428. Is that only me?

Thanks
Joao


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-21 14:16 ` Dave Page <[email protected]>
  1 sibling, 0 replies; 22+ messages in thread

From: Dave Page @ 2018-03-21 14:16 UTC (permalink / raw)
  To: Joao De Almeida Pereira <[email protected]>; +Cc: pgadmin-hackers

On Wed, Mar 21, 2018 at 2:11 PM, Joao De Almeida Pereira <
[email protected]> wrote:

> Hello Hackers,
> Can anyone use the current master branch?
> When I try to open a server I get a 428. Is that only me?
>

Both ssh and https seem to be working fine for me.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-21 14:16 ` Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Dave Page <[email protected]>
  1 sibling, 2 replies; 22+ messages in thread

From: Khushboo Vashi @ 2018-03-21 14:16 UTC (permalink / raw)
  To: Joao Pedro De Almeida Pereira <[email protected]>; +Cc: pgadmin-hackers

On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
[email protected]> wrote:

Hello Hackers,
Can anyone use the current master branch?
When I try to open a server I get a 428. Is that only me?

May be because of cookie changes.
Check your config.py and config_local.py if you have done changes related
to DEFAULT_SERVER in your config_local.py then you need to change other 2
cookie related variables also.

Thanks
Joao


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
@ 2018-03-21 14:25   ` Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  1 sibling, 1 reply; 22+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 14:25 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: pgadmin-hackers

Where can I find information about that?

On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
[email protected]> wrote:

>
>
> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
> [email protected]> wrote:
>
> Hello Hackers,
> Can anyone use the current master branch?
> When I try to open a server I get a 428. Is that only me?
>
> May be because of cookie changes.
> Check your config.py and config_local.py if you have done changes related
> to DEFAULT_SERVER in your config_local.py then you need to change other 2
> cookie related variables also.
>
> Thanks
> Joao
>
>
>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-21 14:29     ` Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:32       ` Re: Experiencing issues Dave Page <[email protected]>
  0 siblings, 2 replies; 22+ messages in thread

From: Murtuza Zabuawala @ 2018-03-21 14:29 UTC (permalink / raw)
  To: Joao De Almeida Pereira <[email protected]>; +Cc: Khushboo Vashi <[email protected]>; pgadmin-hackers

Yes, that's cookie related issue (RM#3197), To fix that I added below in my
config_local.py and it started working again,

DEFAULT_SERVER = '0.0.0.0'
COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER

Clear your browser cookies and server side sessions.


--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
[email protected]> wrote:

> Where can I find information about that?
>
> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
> [email protected]> wrote:
>
>>
>>
>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>> [email protected]> wrote:
>>
>> Hello Hackers,
>> Can anyone use the current master branch?
>> When I try to open a server I get a 428. Is that only me?
>>
>> May be because of cookie changes.
>> Check your config.py and config_local.py if you have done changes related
>> to DEFAULT_SERVER in your config_local.py then you need to change other 2
>> cookie related variables also.
>>
>> Thanks
>> Joao
>>
>>
>>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
@ 2018-03-21 14:31       ` Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:37         ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  1 sibling, 2 replies; 22+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 14:31 UTC (permalink / raw)
  To: Murtuza Zabuawala <[email protected]>; +Cc: Khushboo Vashi <[email protected]>; pgadmin-hackers

I tried that but still nothing. When i check in the inspector for cookies I
have none

On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <
[email protected]> wrote:

> Yes, that's cookie related issue (RM#3197), To fix that I added below in
> my config_local.py and it started working again,
>
> DEFAULT_SERVER = '0.0.0.0'
> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>
> Clear your browser cookies and server side sessions.
>
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
> [email protected]> wrote:
>
>> Where can I find information about that?
>>
>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>> [email protected]> wrote:
>>
>>>
>>>
>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>> [email protected]> wrote:
>>>
>>> Hello Hackers,
>>> Can anyone use the current master branch?
>>> When I try to open a server I get a 428. Is that only me?
>>>
>>> May be because of cookie changes.
>>> Check your config.py and config_local.py if you have done changes
>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>> other 2 cookie related variables also.
>>>
>>> Thanks
>>> Joao
>>>
>>>
>>>
>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-21 14:37         ` Murtuza Zabuawala <[email protected]>
  1 sibling, 0 replies; 22+ messages in thread

From: Murtuza Zabuawala @ 2018-03-21 14:37 UTC (permalink / raw)
  To: Joao De Almeida Pereira <[email protected]>; +Cc: Khushboo Vashi <[email protected]>; pgadmin-hackers

Have you cleared server side sessions?
rm -rf ~/.pgadmin/sessions/

Make sure to access it with same name as mentioned via DEFAULT_SERVER.

if you have DEFAULT_SERVER = '0.0.0.0'
then http://0.0.0.0:5050

and if you have DEFAULT_SERVER = '127.0.0.1'
then http://127.0.0.1:5050



--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Wed, Mar 21, 2018 at 8:01 PM, Joao De Almeida Pereira <
[email protected]> wrote:

> I tried that but still nothing. When i check in the inspector for cookies
> I have none
>
> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <murtuza.zabuawala@
> enterprisedb.com> wrote:
>
>> Yes, that's cookie related issue (RM#3197), To fix that I added below in
>> my config_local.py and it started working again,
>>
>> DEFAULT_SERVER = '0.0.0.0'
>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>
>> Clear your browser cookies and server side sessions.
>>
>>
>> --
>> Regards,
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>> [email protected]> wrote:
>>
>>> Where can I find information about that?
>>>
>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>> [email protected]> wrote:
>>>
>>>>
>>>>
>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>> [email protected]> wrote:
>>>>
>>>> Hello Hackers,
>>>> Can anyone use the current master branch?
>>>> When I try to open a server I get a 428. Is that only me?
>>>>
>>>> May be because of cookie changes.
>>>> Check your config.py and config_local.py if you have done changes
>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>> other 2 cookie related variables also.
>>>>
>>>> Thanks
>>>> Joao
>>>>
>>>>
>>>>
>>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-21 14:39         ` Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  1 sibling, 1 reply; 22+ messages in thread

From: Khushboo Vashi @ 2018-03-21 14:39 UTC (permalink / raw)
  To: Joao Pedro De Almeida Pereira <[email protected]>; +Cc: Murtuza Zabuawala <[email protected]>; pgadmin-hackers

On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
[email protected]> wrote:

I tried that but still nothing. When i check in the inspector for cookies I
have none

Share your config_local file.

On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <murtuza.zabuawala@
enterprisedb.com> wrote:

> Yes, that's cookie related issue (RM#3197), To fix that I added below in
> my config_local.py and it started working again,
>
> DEFAULT_SERVER = '0.0.0.0'
> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>
> Clear your browser cookies and server side sessions.
>
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
> [email protected]> wrote:
>
>> Where can I find information about that?
>>
>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>> [email protected]> wrote:
>>
>>>
>>>
>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>> [email protected]> wrote:
>>>
>>> Hello Hackers,
>>> Can anyone use the current master branch?
>>> When I try to open a server I get a 428. Is that only me?
>>>
>>> May be because of cookie changes.
>>> Check your config.py and config_local.py if you have done changes
>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>> other 2 cookie related variables also.
>>>
>>> Thanks
>>> Joao
>>>
>>>
>>>
>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
@ 2018-03-21 14:40           ` Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  0 siblings, 1 reply; 22+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 14:40 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: Murtuza Zabuawala <[email protected]>; pgadmin-hackers

Ok Murtuza you are right,
Now my question is I have the default server to 127.0.0.1 and I want to
access it using localhost as well. How can I do this?

On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
[email protected]> wrote:

>
>
> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
> [email protected]> wrote:
>
> I tried that but still nothing. When i check in the inspector for cookies
> I have none
>
> Share your config_local file.
>
> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <
> [email protected]> wrote:
>
>> Yes, that's cookie related issue (RM#3197), To fix that I added below in
>> my config_local.py and it started working again,
>>
>> DEFAULT_SERVER = '0.0.0.0'
>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>
>> Clear your browser cookies and server side sessions.
>>
>>
>> --
>> Regards,
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>> [email protected]> wrote:
>>
>>> Where can I find information about that?
>>>
>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>> [email protected]> wrote:
>>>
>>>>
>>>>
>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>> [email protected]> wrote:
>>>>
>>>> Hello Hackers,
>>>> Can anyone use the current master branch?
>>>> When I try to open a server I get a 428. Is that only me?
>>>>
>>>> May be because of cookie changes.
>>>> Check your config.py and config_local.py if you have done changes
>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>> other 2 cookie related variables also.
>>>>
>>>> Thanks
>>>> Joao
>>>>
>>>>
>>>>
>>
>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-21 14:55             ` Khushboo Vashi <[email protected]>
  2018-03-21 14:57               ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  0 siblings, 1 reply; 22+ messages in thread

From: Khushboo Vashi @ 2018-03-21 14:55 UTC (permalink / raw)
  To: Joao De Almeida Pereira <[email protected]>; +Cc: Murtuza Zabuawala <[email protected]>; pgadmin-hackers

On Wed, Mar 21, 2018 at 8:10 PM, Joao De Almeida Pereira <
[email protected]> wrote:

> Ok Murtuza you are right,
> Now my question is I have the default server to 127.0.0.1 and I want to
> access it using localhost as well. How can I do this?
>
> No, you can't.
Domain based cookie will work for that domain and it's sub-domains.

> On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
> [email protected]> wrote:
>
>>
>>
>> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
>> [email protected]> wrote:
>>
>> I tried that but still nothing. When i check in the inspector for cookies
>> I have none
>>
>> Share your config_local file.
>>
>> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <murtuza.zabuawala@
>> enterprisedb.com> wrote:
>>
>>> Yes, that's cookie related issue (RM#3197), To fix that I added below in
>>> my config_local.py and it started working again,
>>>
>>> DEFAULT_SERVER = '0.0.0.0'
>>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>>
>>> Clear your browser cookies and server side sessions.
>>>
>>>
>>> --
>>> Regards,
>>> Murtuza Zabuawala
>>> EnterpriseDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>>
>>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>>> [email protected]> wrote:
>>>
>>>> Where can I find information about that?
>>>>
>>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>>> [email protected]> wrote:
>>>>
>>>>>
>>>>>
>>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>>> [email protected]> wrote:
>>>>>
>>>>> Hello Hackers,
>>>>> Can anyone use the current master branch?
>>>>> When I try to open a server I get a 428. Is that only me?
>>>>>
>>>>> May be because of cookie changes.
>>>>> Check your config.py and config_local.py if you have done changes
>>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>>> other 2 cookie related variables also.
>>>>>
>>>>> Thanks
>>>>> Joao
>>>>>
>>>>>
>>>>>
>>>
>>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
@ 2018-03-21 14:57               ` Joao De Almeida Pereira <[email protected]>
  2018-03-21 15:00                 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  0 siblings, 1 reply; 22+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 14:57 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: Murtuza Zabuawala <[email protected]>; pgadmin-hackers

So what you are saying is that if I have a server, I need to do
DEFAULT_SERVER=0.0.0.0 and then set the real domain on the COOKIE domain?

On Wed, Mar 21, 2018 at 10:55 AM Khushboo Vashi <
[email protected]> wrote:

> On Wed, Mar 21, 2018 at 8:10 PM, Joao De Almeida Pereira <
> [email protected]> wrote:
>
>> Ok Murtuza you are right,
>> Now my question is I have the default server to 127.0.0.1 and I want to
>> access it using localhost as well. How can I do this?
>>
>> No, you can't.
> Domain based cookie will work for that domain and it's sub-domains.
>
>> On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
>> [email protected]> wrote:
>>
>>>
>>>
>>> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
>>> [email protected]> wrote:
>>>
>>> I tried that but still nothing. When i check in the inspector for
>>> cookies I have none
>>>
>>> Share your config_local file.
>>>
>>> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <
>>> [email protected]> wrote:
>>>
>>>> Yes, that's cookie related issue (RM#3197), To fix that I added below
>>>> in my config_local.py and it started working again,
>>>>
>>>> DEFAULT_SERVER = '0.0.0.0'
>>>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>>>
>>>> Clear your browser cookies and server side sessions.
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Murtuza Zabuawala
>>>> EnterpriseDB: http://www.enterprisedb.com
>>>> The Enterprise PostgreSQL Company
>>>>
>>>>
>>>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>>>> [email protected]> wrote:
>>>>
>>>>> Where can I find information about that?
>>>>>
>>>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>>>> [email protected]> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>> Hello Hackers,
>>>>>> Can anyone use the current master branch?
>>>>>> When I try to open a server I get a 428. Is that only me?
>>>>>>
>>>>>> May be because of cookie changes.
>>>>>> Check your config.py and config_local.py if you have done changes
>>>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>>>> other 2 cookie related variables also.
>>>>>>
>>>>>> Thanks
>>>>>> Joao
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:57               ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-21 15:00                 ` Khushboo Vashi <[email protected]>
  2018-03-21 15:57                   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  0 siblings, 1 reply; 22+ messages in thread

From: Khushboo Vashi @ 2018-03-21 15:00 UTC (permalink / raw)
  To: Joao De Almeida Pereira <[email protected]>; +Cc: Murtuza Zabuawala <[email protected]>; pgadmin-hackers

On Wed, Mar 21, 2018 at 8:27 PM, Joao De Almeida Pereira <
[email protected]> wrote:

> So what you are saying is that if I have a server, I need to do
> DEFAULT_SERVER=0.0.0.0 and then set the real domain on the COOKIE domain?
>
> No I am saying, whatever you set as a DEFAULT_SERVER,  the app can be
accessible with that server.
As, we have explicitly set  DOMAIN in the cookie setting.

> On Wed, Mar 21, 2018 at 10:55 AM Khushboo Vashi <
> [email protected]> wrote:
>
>> On Wed, Mar 21, 2018 at 8:10 PM, Joao De Almeida Pereira <
>> [email protected]> wrote:
>>
>>> Ok Murtuza you are right,
>>> Now my question is I have the default server to 127.0.0.1 and I want to
>>> access it using localhost as well. How can I do this?
>>>
>>> No, you can't.
>> Domain based cookie will work for that domain and it's sub-domains.
>>
>>> On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
>>> [email protected]> wrote:
>>>
>>>>
>>>>
>>>> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
>>>> [email protected]> wrote:
>>>>
>>>> I tried that but still nothing. When i check in the inspector for
>>>> cookies I have none
>>>>
>>>> Share your config_local file.
>>>>
>>>> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <murtuza.zabuawala@
>>>> enterprisedb.com> wrote:
>>>>
>>>>> Yes, that's cookie related issue (RM#3197), To fix that I added below
>>>>> in my config_local.py and it started working again,
>>>>>
>>>>> DEFAULT_SERVER = '0.0.0.0'
>>>>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>>>>
>>>>> Clear your browser cookies and server side sessions.
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Murtuza Zabuawala
>>>>> EnterpriseDB: http://www.enterprisedb.com
>>>>> The Enterprise PostgreSQL Company
>>>>>
>>>>>
>>>>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Where can I find information about that?
>>>>>>
>>>>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>> Hello Hackers,
>>>>>>> Can anyone use the current master branch?
>>>>>>> When I try to open a server I get a 428. Is that only me?
>>>>>>>
>>>>>>> May be because of cookie changes.
>>>>>>> Check your config.py and config_local.py if you have done changes
>>>>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>>>>> other 2 cookie related variables also.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Joao
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:57               ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 15:00                 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
@ 2018-03-21 15:57                   ` Joao De Almeida Pereira <[email protected]>
  2018-03-21 16:01                     ` Re: Experiencing issues Dave Page <[email protected]>
  0 siblings, 1 reply; 22+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 15:57 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: Murtuza Zabuawala <[email protected]>; pgadmin-hackers

Sorry I did not understand what you said.
This configuration:

DEFAULT_SERVER = '0.0.0.0'
SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
COOKIE_DEFAULT_DOMAIN = DEFAULT_SERVER

If the application lives in the domain pgadmin.somedomain.com do I need to
have in config_local:
DEFAULT_SERVER = '0.0.0.0'
SESSION_COOKIE_DOMAIN = 'pgadmin.somedomain.com'
COOKIE_DEFAULT_DOMAIN = 'pgadmin.somedomain.com'
?

Does this mean that if for some reason I have a second domain like
pgadmin.somedomain2.com that I want to use I cannot?

The issue of 127.0.0.1 to localhost is very cumbersome, and somehow we
should be able to disable this, because when we are developing doesn't make
sense to not being able to use localhost and 127.0.0.1

Thanks
Joao
On Wed, Mar 21, 2018 at 11:01 AM Khushboo Vashi <
[email protected]> wrote:

> On Wed, Mar 21, 2018 at 8:27 PM, Joao De Almeida Pereira <
> [email protected]> wrote:
>
>> So what you are saying is that if I have a server, I need to do
>> DEFAULT_SERVER=0.0.0.0 and then set the real domain on the COOKIE domain?
>>
>> No I am saying, whatever you set as a DEFAULT_SERVER,  the app can be
> accessible with that server.
> As, we have explicitly set  DOMAIN in the cookie setting.
>
>> On Wed, Mar 21, 2018 at 10:55 AM Khushboo Vashi <
>> [email protected]> wrote:
>>
>>> On Wed, Mar 21, 2018 at 8:10 PM, Joao De Almeida Pereira <
>>> [email protected]> wrote:
>>>
>>>> Ok Murtuza you are right,
>>>> Now my question is I have the default server to 127.0.0.1 and I want to
>>>> access it using localhost as well. How can I do this?
>>>>
>>>> No, you can't.
>>> Domain based cookie will work for that domain and it's sub-domains.
>>>
>>>> On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
>>>> [email protected]> wrote:
>>>>
>>>>>
>>>>>
>>>>> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
>>>>> [email protected]> wrote:
>>>>>
>>>>> I tried that but still nothing. When i check in the inspector for
>>>>> cookies I have none
>>>>>
>>>>> Share your config_local file.
>>>>>
>>>>> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Yes, that's cookie related issue (RM#3197), To fix that I added below
>>>>>> in my config_local.py and it started working again,
>>>>>>
>>>>>> DEFAULT_SERVER = '0.0.0.0'
>>>>>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>>>>>
>>>>>> Clear your browser cookies and server side sessions.
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>> Murtuza Zabuawala
>>>>>> EnterpriseDB: http://www.enterprisedb.com
>>>>>> The Enterprise PostgreSQL Company
>>>>>>
>>>>>>
>>>>>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>>> Where can I find information about that?
>>>>>>>
>>>>>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>> Hello Hackers,
>>>>>>>> Can anyone use the current master branch?
>>>>>>>> When I try to open a server I get a 428. Is that only me?
>>>>>>>>
>>>>>>>> May be because of cookie changes.
>>>>>>>> Check your config.py and config_local.py if you have done changes
>>>>>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>>>>>> other 2 cookie related variables also.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Joao
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:57               ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 15:00                 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 15:57                   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-21 16:01                     ` Dave Page <[email protected]>
  2018-03-21 16:30                       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-23 06:17                       ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  0 siblings, 2 replies; 22+ messages in thread

From: Dave Page @ 2018-03-21 16:01 UTC (permalink / raw)
  To: Joao De Almeida Pereira <[email protected]>; +Cc: Khushboo Vashi <[email protected]>; Murtuza Zabuawala <[email protected]>; pgadmin-hackers

On Wed, Mar 21, 2018 at 3:57 PM, Joao De Almeida Pereira <
[email protected]> wrote:

> Sorry I did not understand what you said.
> This configuration:
>
> DEFAULT_SERVER = '0.0.0.0'
> SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
> COOKIE_DEFAULT_DOMAIN = DEFAULT_SERVER
>
> If the application lives in the domain pgadmin.somedomain.com do I need
> to have in config_local:
> DEFAULT_SERVER = '0.0.0.0'
> SESSION_COOKIE_DOMAIN = 'pgadmin.somedomain.com'
> COOKIE_DEFAULT_DOMAIN = 'pgadmin.somedomain.com'
> ?
>
> Does this mean that if for some reason I have a second domain like
> pgadmin.somedomain2.com that I want to use I cannot?
>
> The issue of 127.0.0.1 to localhost is very cumbersome, and somehow we
> should be able to disable this, because when we are developing doesn't make
> sense to not being able to use localhost and 127.0.0.1
>

+1. I didn't realise we'd added this restriction when I tested the patch.

Perhaps a better approach would be to leave the default cookie handling as
it was, and just expose the domain and path via config options that the
user can set if appropriate for their installation.



>
> Thanks
> Joao
>
> On Wed, Mar 21, 2018 at 11:01 AM Khushboo Vashi <
> [email protected]> wrote:
>
>> On Wed, Mar 21, 2018 at 8:27 PM, Joao De Almeida Pereira <
>> [email protected]> wrote:
>>
>>> So what you are saying is that if I have a server, I need to do
>>> DEFAULT_SERVER=0.0.0.0 and then set the real domain on the COOKIE domain?
>>>
>>> No I am saying, whatever you set as a DEFAULT_SERVER,  the app can be
>> accessible with that server.
>> As, we have explicitly set  DOMAIN in the cookie setting.
>>
>>> On Wed, Mar 21, 2018 at 10:55 AM Khushboo Vashi <
>>> [email protected]> wrote:
>>>
>>>> On Wed, Mar 21, 2018 at 8:10 PM, Joao De Almeida Pereira <
>>>> [email protected]> wrote:
>>>>
>>>>> Ok Murtuza you are right,
>>>>> Now my question is I have the default server to 127.0.0.1 and I want
>>>>> to access it using localhost as well. How can I do this?
>>>>>
>>>>> No, you can't.
>>>> Domain based cookie will work for that domain and it's sub-domains.
>>>>
>>>>> On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
>>>>> [email protected]> wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>> I tried that but still nothing. When i check in the inspector for
>>>>>> cookies I have none
>>>>>>
>>>>>> Share your config_local file.
>>>>>>
>>>>>> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>>> Yes, that's cookie related issue (RM#3197), To fix that I added
>>>>>>> below in my config_local.py and it started working again,
>>>>>>>
>>>>>>> DEFAULT_SERVER = '0.0.0.0'
>>>>>>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>>>>>>
>>>>>>> Clear your browser cookies and server side sessions.
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Regards,
>>>>>>> Murtuza Zabuawala
>>>>>>> EnterpriseDB: http://www.enterprisedb.com
>>>>>>> The Enterprise PostgreSQL Company
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>>> Where can I find information about that?
>>>>>>>>
>>>>>>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>>>>>>> [email protected]> wrote:
>>>>>>>>>
>>>>>>>>> Hello Hackers,
>>>>>>>>> Can anyone use the current master branch?
>>>>>>>>> When I try to open a server I get a 428. Is that only me?
>>>>>>>>>
>>>>>>>>> May be because of cookie changes.
>>>>>>>>> Check your config.py and config_local.py if you have done changes
>>>>>>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>>>>>>> other 2 cookie related variables also.
>>>>>>>>>
>>>>>>>>> Thanks
>>>>>>>>> Joao
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:57               ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 15:00                 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 15:57                   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 16:01                     ` Re: Experiencing issues Dave Page <[email protected]>
@ 2018-03-21 16:30                       ` Joao De Almeida Pereira <[email protected]>
  2018-03-22 02:57                         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  1 sibling, 1 reply; 22+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 16:30 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: Khushboo Vashi <[email protected]>; Murtuza Zabuawala <[email protected]>; pgadmin-hackers

Another thing when I do this configuration:

DEFAULT_SERVER = '127.0.0.1'
SESSION_COOKIE_DOMAIN = 'localhost'
COOKIE_DEFAULT_DOMAIN = 'localhost'

I get the following exception:
builtins.ValueError

ValueError: Setting 'domain' for a cookie on a server running localy (ex:
localhost) is not supportted by complying browsers. You should have
something like: '127.0.0.1 localhost dev.localhost' on your hosts file and
then point your server to run on 'dev.localhost' and also set 'domain' for
'dev.localhost'
And if you follow the instructions and change the hosts file it allows you
to start the application but when you try to open a database server you
will get the 428 error
Thanks
Joao


On Wed, Mar 21, 2018 at 12:01 PM Dave Page <[email protected]> wrote:

> On Wed, Mar 21, 2018 at 3:57 PM, Joao De Almeida Pereira <
> [email protected]> wrote:
>
>> Sorry I did not understand what you said.
>> This configuration:
>>
>> DEFAULT_SERVER = '0.0.0.0'
>> SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>> COOKIE_DEFAULT_DOMAIN = DEFAULT_SERVER
>>
>> If the application lives in the domain pgadmin.somedomain.com do I need
>> to have in config_local:
>> DEFAULT_SERVER = '0.0.0.0'
>> SESSION_COOKIE_DOMAIN = 'pgadmin.somedomain.com'
>> COOKIE_DEFAULT_DOMAIN = 'pgadmin.somedomain.com'
>> ?
>>
>> Does this mean that if for some reason I have a second domain like
>> pgadmin.somedomain2.com that I want to use I cannot?
>>
>> The issue of 127.0.0.1 to localhost is very cumbersome, and somehow we
>> should be able to disable this, because when we are developing doesn't make
>> sense to not being able to use localhost and 127.0.0.1
>>
>
> +1. I didn't realise we'd added this restriction when I tested the patch.
>
> Perhaps a better approach would be to leave the default cookie handling as
> it was, and just expose the domain and path via config options that the
> user can set if appropriate for their installation.
>
>
>
>>
>> Thanks
>> Joao
>>
>> On Wed, Mar 21, 2018 at 11:01 AM Khushboo Vashi <
>> [email protected]> wrote:
>>
>>> On Wed, Mar 21, 2018 at 8:27 PM, Joao De Almeida Pereira <
>>> [email protected]> wrote:
>>>
>>>> So what you are saying is that if I have a server, I need to do
>>>> DEFAULT_SERVER=0.0.0.0 and then set the real domain on the COOKIE domain?
>>>>
>>>> No I am saying, whatever you set as a DEFAULT_SERVER,  the app can be
>>> accessible with that server.
>>> As, we have explicitly set  DOMAIN in the cookie setting.
>>>
>>>> On Wed, Mar 21, 2018 at 10:55 AM Khushboo Vashi <
>>>> [email protected]> wrote:
>>>>
>>>>> On Wed, Mar 21, 2018 at 8:10 PM, Joao De Almeida Pereira <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Ok Murtuza you are right,
>>>>>> Now my question is I have the default server to 127.0.0.1 and I want
>>>>>> to access it using localhost as well. How can I do this?
>>>>>>
>>>>>> No, you can't.
>>>>> Domain based cookie will work for that domain and it's sub-domains.
>>>>>
>>>>>> On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>> I tried that but still nothing. When i check in the inspector for
>>>>>>> cookies I have none
>>>>>>>
>>>>>>> Share your config_local file.
>>>>>>>
>>>>>>> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>>> Yes, that's cookie related issue (RM#3197), To fix that I added
>>>>>>>> below in my config_local.py and it started working again,
>>>>>>>>
>>>>>>>> DEFAULT_SERVER = '0.0.0.0'
>>>>>>>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>>>>>>>
>>>>>>>> Clear your browser cookies and server side sessions.
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Regards,
>>>>>>>> Murtuza Zabuawala
>>>>>>>> EnterpriseDB: http://www.enterprisedb.com
>>>>>>>> The Enterprise PostgreSQL Company
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>>> Where can I find information about that?
>>>>>>>>>
>>>>>>>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>>>>>>>> [email protected]> wrote:
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>>>>>>>> [email protected]> wrote:
>>>>>>>>>>
>>>>>>>>>> Hello Hackers,
>>>>>>>>>> Can anyone use the current master branch?
>>>>>>>>>> When I try to open a server I get a 428. Is that only me?
>>>>>>>>>>
>>>>>>>>>> May be because of cookie changes.
>>>>>>>>>> Check your config.py and config_local.py if you have done changes
>>>>>>>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>>>>>>>> other 2 cookie related variables also.
>>>>>>>>>>
>>>>>>>>>> Thanks
>>>>>>>>>> Joao
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:57               ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 15:00                 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 15:57                   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 16:01                     ` Re: Experiencing issues Dave Page <[email protected]>
  2018-03-21 16:30                       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
@ 2018-03-22 02:57                         ` Khushboo Vashi <[email protected]>
  0 siblings, 0 replies; 22+ messages in thread

From: Khushboo Vashi @ 2018-03-22 02:57 UTC (permalink / raw)
  To: Joao De Almeida Pereira <[email protected]>; +Cc: Dave Page <[email protected]>; Murtuza Zabuawala <[email protected]>; pgadmin-hackers

On Wed, Mar 21, 2018 at 10:00 PM, Joao De Almeida Pereira <
[email protected]> wrote:

> Another thing when I do this configuration:
>
> DEFAULT_SERVER = '127.0.0.1'
> SESSION_COOKIE_DOMAIN = 'localhost'
> COOKIE_DEFAULT_DOMAIN = 'localhost'
>
> I get the following exception:
> builtins.ValueError
>
> ValueError: Setting 'domain' for a cookie on a server running localy (ex:
> localhost) is not supportted by complying browsers. You should have
> something like: '127.0.0.1 localhost dev.localhost' on your hosts file and
> then point your server to run on 'dev.localhost' and also set 'domain' for
> 'dev.localhost'
> And if you follow the instructions and change the hosts file it allows you
> to start the application but when you try to open a database server you
> will get the 428 error
> Thanks
> Joao
>
> Right, many browser doesn't support localhost as a cookie domain.
The settings you did is not correct, your cookie will be stored as a
'localhost' domain and you trying to run the app as 127.0.0.1.
If we set a domain for the cookie than either that domain or sub-domains
can access that cookie.

In regards to your question of 2 domain names, this type of situation
arrives when any site is configured explicitly to divide the load. In case
of pgAdmin 4, this is not going to happen :).
It is always recommend to use cookie with domain settings, but as Dave
suggested we can leave that upto user. So, we will make it configurable and
user will decide to have it or not.


>
> On Wed, Mar 21, 2018 at 12:01 PM Dave Page <[email protected]> wrote:
>
>> On Wed, Mar 21, 2018 at 3:57 PM, Joao De Almeida Pereira <
>> [email protected]> wrote:
>>
>>> Sorry I did not understand what you said.
>>> This configuration:
>>>
>>> DEFAULT_SERVER = '0.0.0.0'
>>> SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>> COOKIE_DEFAULT_DOMAIN = DEFAULT_SERVER
>>>
>>> If the application lives in the domain pgadmin.somedomain.com do I need
>>> to have in config_local:
>>> DEFAULT_SERVER = '0.0.0.0'
>>> SESSION_COOKIE_DOMAIN = 'pgadmin.somedomain.com'
>>> COOKIE_DEFAULT_DOMAIN = 'pgadmin.somedomain.com'
>>> ?
>>>
>>> Does this mean that if for some reason I have a second domain like
>>> pgadmin.somedomain2.com that I want to use I cannot?
>>>
>>> The issue of 127.0.0.1 to localhost is very cumbersome, and somehow we
>>> should be able to disable this, because when we are developing doesn't make
>>> sense to not being able to use localhost and 127.0.0.1
>>>
>>
>> +1. I didn't realise we'd added this restriction when I tested the patch.
>>
>> Perhaps a better approach would be to leave the default cookie handling
>> as it was, and just expose the domain and path via config options that the
>> user can set if appropriate for their installation.
>>
>>
>>
>>>
>>> Thanks
>>> Joao
>>>
>>> On Wed, Mar 21, 2018 at 11:01 AM Khushboo Vashi <
>>> [email protected]> wrote:
>>>
>>>> On Wed, Mar 21, 2018 at 8:27 PM, Joao De Almeida Pereira <
>>>> [email protected]> wrote:
>>>>
>>>>> So what you are saying is that if I have a server, I need to do
>>>>> DEFAULT_SERVER=0.0.0.0 and then set the real domain on the COOKIE domain?
>>>>>
>>>>> No I am saying, whatever you set as a DEFAULT_SERVER,  the app can be
>>>> accessible with that server.
>>>> As, we have explicitly set  DOMAIN in the cookie setting.
>>>>
>>>>> On Wed, Mar 21, 2018 at 10:55 AM Khushboo Vashi <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> On Wed, Mar 21, 2018 at 8:10 PM, Joao De Almeida Pereira <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>>> Ok Murtuza you are right,
>>>>>>> Now my question is I have the default server to 127.0.0.1 and I want
>>>>>>> to access it using localhost as well. How can I do this?
>>>>>>>
>>>>>>> No, you can't.
>>>>>> Domain based cookie will work for that domain and it's sub-domains.
>>>>>>
>>>>>>> On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>> I tried that but still nothing. When i check in the inspector for
>>>>>>>> cookies I have none
>>>>>>>>
>>>>>>>> Share your config_local file.
>>>>>>>>
>>>>>>>> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>>> Yes, that's cookie related issue (RM#3197), To fix that I added
>>>>>>>>> below in my config_local.py and it started working again,
>>>>>>>>>
>>>>>>>>> DEFAULT_SERVER = '0.0.0.0'
>>>>>>>>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>>>>>>>>
>>>>>>>>> Clear your browser cookies and server side sessions.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Regards,
>>>>>>>>> Murtuza Zabuawala
>>>>>>>>> EnterpriseDB: http://www.enterprisedb.com
>>>>>>>>> The Enterprise PostgreSQL Company
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>>>>>>>>> [email protected]> wrote:
>>>>>>>>>
>>>>>>>>>> Where can I find information about that?
>>>>>>>>>>
>>>>>>>>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>>>>>>>>> [email protected]> wrote:
>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>>>>>>>>> [email protected]> wrote:
>>>>>>>>>>>
>>>>>>>>>>> Hello Hackers,
>>>>>>>>>>> Can anyone use the current master branch?
>>>>>>>>>>> When I try to open a server I get a 428. Is that only me?
>>>>>>>>>>>
>>>>>>>>>>> May be because of cookie changes.
>>>>>>>>>>> Check your config.py and config_local.py if you have done
>>>>>>>>>>> changes related to DEFAULT_SERVER in your config_local.py then you need to
>>>>>>>>>>> change other 2 cookie related variables also.
>>>>>>>>>>>
>>>>>>>>>>> Thanks
>>>>>>>>>>> Joao
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:57               ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 15:00                 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 15:57                   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 16:01                     ` Re: Experiencing issues Dave Page <[email protected]>
@ 2018-03-23 06:17                       ` Khushboo Vashi <[email protected]>
  2018-03-23 10:14                         ` Re: Experiencing issues Dave Page <[email protected]>
  1 sibling, 1 reply; 22+ messages in thread

From: Khushboo Vashi @ 2018-03-23 06:17 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: Joao De Almeida Pereira <[email protected]>; Murtuza Zabuawala <[email protected]>; pgadmin-hackers

Hi,

On Wed, Mar 21, 2018 at 9:31 PM, Dave Page <[email protected]> wrote:

>
>
> On Wed, Mar 21, 2018 at 3:57 PM, Joao De Almeida Pereira <
> [email protected]> wrote:
>
>> Sorry I did not understand what you said.
>> This configuration:
>>
>> DEFAULT_SERVER = '0.0.0.0'
>> SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>> COOKIE_DEFAULT_DOMAIN = DEFAULT_SERVER
>>
>> If the application lives in the domain pgadmin.somedomain.com do I need
>> to have in config_local:
>> DEFAULT_SERVER = '0.0.0.0'
>> SESSION_COOKIE_DOMAIN = 'pgadmin.somedomain.com'
>> COOKIE_DEFAULT_DOMAIN = 'pgadmin.somedomain.com'
>> ?
>>
>> Does this mean that if for some reason I have a second domain like
>> pgadmin.somedomain2.com that I want to use I cannot?
>>
>> The issue of 127.0.0.1 to localhost is very cumbersome, and somehow we
>> should be able to disable this, because when we are developing doesn't make
>> sense to not being able to use localhost and 127.0.0.1
>>
>
> +1. I didn't realise we'd added this restriction when I tested the patch.
>
> Perhaps a better approach would be to leave the default cookie handling as
> it was, and just expose the domain and path via config options that the
> user can set if appropriate for their installation.
>
> Please find the attached updated patch as discussed.

If one has to set cookie domain and path then below *config variables*
should be changed.

COOKIE_DEFAULT_PATH
COOKIE_DEFAULT_DOMAIN
SESSION_COOKIE_DOMAIN

Thanks,
Khushboo

>
>
>>
>> Thanks
>> Joao
>>
>> On Wed, Mar 21, 2018 at 11:01 AM Khushboo Vashi <
>> [email protected]> wrote:
>>
>>> On Wed, Mar 21, 2018 at 8:27 PM, Joao De Almeida Pereira <
>>> [email protected]> wrote:
>>>
>>>> So what you are saying is that if I have a server, I need to do
>>>> DEFAULT_SERVER=0.0.0.0 and then set the real domain on the COOKIE domain?
>>>>
>>>> No I am saying, whatever you set as a DEFAULT_SERVER,  the app can be
>>> accessible with that server.
>>> As, we have explicitly set  DOMAIN in the cookie setting.
>>>
>>>> On Wed, Mar 21, 2018 at 10:55 AM Khushboo Vashi <
>>>> [email protected]> wrote:
>>>>
>>>>> On Wed, Mar 21, 2018 at 8:10 PM, Joao De Almeida Pereira <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Ok Murtuza you are right,
>>>>>> Now my question is I have the default server to 127.0.0.1 and I want
>>>>>> to access it using localhost as well. How can I do this?
>>>>>>
>>>>>> No, you can't.
>>>>> Domain based cookie will work for that domain and it's sub-domains.
>>>>>
>>>>>> On Wed, Mar 21, 2018 at 10:39 AM Khushboo Vashi <
>>>>>> [email protected]> wrote:
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 21 Mar 2018 20:01, "Joao De Almeida Pereira" <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>> I tried that but still nothing. When i check in the inspector for
>>>>>>> cookies I have none
>>>>>>>
>>>>>>> Share your config_local file.
>>>>>>>
>>>>>>> On Wed, Mar 21, 2018 at 10:30 AM Murtuza Zabuawala <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>>> Yes, that's cookie related issue (RM#3197), To fix that I added
>>>>>>>> below in my config_local.py and it started working again,
>>>>>>>>
>>>>>>>> DEFAULT_SERVER = '0.0.0.0'
>>>>>>>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>>>>>>>
>>>>>>>> Clear your browser cookies and server side sessions.
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Regards,
>>>>>>>> Murtuza Zabuawala
>>>>>>>> EnterpriseDB: http://www.enterprisedb.com
>>>>>>>> The Enterprise PostgreSQL Company
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Mar 21, 2018 at 7:55 PM, Joao De Almeida Pereira <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>>> Where can I find information about that?
>>>>>>>>>
>>>>>>>>> On Wed, Mar 21, 2018 at 10:16 AM Khushboo Vashi <
>>>>>>>>> [email protected]> wrote:
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
>>>>>>>>>> [email protected]> wrote:
>>>>>>>>>>
>>>>>>>>>> Hello Hackers,
>>>>>>>>>> Can anyone use the current master branch?
>>>>>>>>>> When I try to open a server I get a 428. Is that only me?
>>>>>>>>>>
>>>>>>>>>> May be because of cookie changes.
>>>>>>>>>> Check your config.py and config_local.py if you have done changes
>>>>>>>>>> related to DEFAULT_SERVER in your config_local.py then you need to change
>>>>>>>>>> other 2 cookie related variables also.
>>>>>>>>>>
>>>>>>>>>> Thanks
>>>>>>>>>> Joao
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>


Attachments:

  [text/x-patch] RM_3197_cookie_domain_changes.patch (3.3K, 3-RM_3197_cookie_domain_changes.patch)
  download | inline diff:
diff --git a/web/config.py b/web/config.py
index 926a87b..ed28438 100644
--- a/web/config.py
+++ b/web/config.py
@@ -252,7 +252,6 @@ SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')
 
 SESSION_COOKIE_NAME = 'pga4_session'
 
-SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
 ##########################################################################
 # Mail server settings
 ##########################################################################
@@ -361,8 +360,8 @@ SHOW_GRAVATAR_IMAGE = True
 # Set cookie path
 ##########################################################################
 COOKIE_DEFAULT_PATH = '/'
-COOKIE_DEFAULT_DOMAIN = DEFAULT_SERVER
-
+COOKIE_DEFAULT_DOMAIN = None
+SESSION_COOKIE_DOMAIN = None
 ##########################################################################
 # Local config settings
 ##########################################################################
diff --git a/web/pgadmin/__init__.py b/web/pgadmin/__init__.py
index 2f27d07..4e57abf 100644
--- a/web/pgadmin/__init__.py
+++ b/web/pgadmin/__init__.py
@@ -541,13 +541,6 @@ def create_app(app_name=None):
         app.logger.info('Registering blueprint module: %s' % module)
         app.register_blueprint(module)
 
-    #########################################################################
-    # Set cookie path
-    #########################################################################
-    @app.before_first_request
-    def before_first_request():
-        from pgadmin.utils.paths import get_cookie_path
-        config.COOKIE_DEFAULT_PATH = get_cookie_path()
 
     ##########################################################################
     # Handle the desktop login
@@ -586,7 +579,8 @@ def create_app(app_name=None):
     def after_request(response):
         if 'key' in request.args:
             domain = dict()
-            if config.COOKIE_DEFAULT_DOMAIN != 'localhost':
+            if config.COOKIE_DEFAULT_DOMAIN and\
+                    config.COOKIE_DEFAULT_DOMAIN != 'localhost':
                 domain['domain'] = config.COOKIE_DEFAULT_DOMAIN
             response.set_cookie('PGADMIN_KEY', value=request.args['key'],
                                 path=config.COOKIE_DEFAULT_PATH,
diff --git a/web/pgadmin/browser/__init__.py b/web/pgadmin/browser/__init__.py
index 34d0c86..724e677 100644
--- a/web/pgadmin/browser/__init__.py
+++ b/web/pgadmin/browser/__init__.py
@@ -799,7 +799,8 @@ def index():
         language = user_languages.get() or 'en'
 
     domain = dict()
-    if config.COOKIE_DEFAULT_DOMAIN != 'localhost':
+    if config.COOKIE_DEFAULT_DOMAIN and\
+            config.COOKIE_DEFAULT_DOMAIN != 'localhost':
         domain['domain'] = config.COOKIE_DEFAULT_DOMAIN
 
     response.set_cookie("PGADMIN_LANGUAGE", value=language,
diff --git a/web/pgadmin/preferences/__init__.py b/web/pgadmin/preferences/__init__.py
index 9c14cc2..6358841 100644
--- a/web/pgadmin/preferences/__init__.py
+++ b/web/pgadmin/preferences/__init__.py
@@ -200,7 +200,8 @@ def save(pid):
         language = user_languages.get() or language
 
     domain = dict()
-    if config.COOKIE_DEFAULT_DOMAIN != 'localhost':
+    if config.COOKIE_DEFAULT_DOMAIN and\
+            config.COOKIE_DEFAULT_DOMAIN != 'localhost':
         domain['domain'] = config.COOKIE_DEFAULT_DOMAIN
 
     setattr(session, 'PGADMIN_LANGUAGE', language)


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:31       ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:39         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:40           ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:55             ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:57               ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 15:00                 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 15:57                   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 16:01                     ` Re: Experiencing issues Dave Page <[email protected]>
  2018-03-23 06:17                       ` Re: Experiencing issues Khushboo Vashi <[email protected]>
@ 2018-03-23 10:14                         ` Dave Page <[email protected]>
  0 siblings, 0 replies; 22+ messages in thread

From: Dave Page @ 2018-03-23 10:14 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: Joao De Almeida Pereira <[email protected]>; Murtuza Zabuawala <[email protected]>; pgadmin-hackers

On Fri, Mar 23, 2018 at 6:17 AM, Khushboo Vashi <
[email protected]> wrote:

> Hi,
>
> On Wed, Mar 21, 2018 at 9:31 PM, Dave Page <[email protected]> wrote:
>
>>
>>
>> On Wed, Mar 21, 2018 at 3:57 PM, Joao De Almeida Pereira <
>> [email protected]> wrote:
>>
>>> Sorry I did not understand what you said.
>>> This configuration:
>>>
>>> DEFAULT_SERVER = '0.0.0.0'
>>> SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>> COOKIE_DEFAULT_DOMAIN = DEFAULT_SERVER
>>>
>>> If the application lives in the domain pgadmin.somedomain.com do I need
>>> to have in config_local:
>>> DEFAULT_SERVER = '0.0.0.0'
>>> SESSION_COOKIE_DOMAIN = 'pgadmin.somedomain.com'
>>> COOKIE_DEFAULT_DOMAIN = 'pgadmin.somedomain.com'
>>> ?
>>>
>>> Does this mean that if for some reason I have a second domain like
>>> pgadmin.somedomain2.com that I want to use I cannot?
>>>
>>> The issue of 127.0.0.1 to localhost is very cumbersome, and somehow we
>>> should be able to disable this, because when we are developing doesn't make
>>> sense to not being able to use localhost and 127.0.0.1
>>>
>>
>> +1. I didn't realise we'd added this restriction when I tested the patch.
>>
>> Perhaps a better approach would be to leave the default cookie handling
>> as it was, and just expose the domain and path via config options that the
>> user can set if appropriate for their installation.
>>
>> Please find the attached updated patch as discussed.
>
> If one has to set cookie domain and path then below *config variables*
> should be changed.
>
> COOKIE_DEFAULT_PATH
> COOKIE_DEFAULT_DOMAIN
> SESSION_COOKIE_DOMAIN
>

Thanks, applied.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
@ 2018-03-21 14:32       ` Dave Page <[email protected]>
  2018-03-21 14:36         ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:37         ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  1 sibling, 2 replies; 22+ messages in thread

From: Dave Page @ 2018-03-21 14:32 UTC (permalink / raw)
  To: Murtuza Zabuawala <[email protected]>; +Cc: Joao De Almeida Pereira <[email protected]>; Khushboo Vashi <[email protected]>; pgadmin-hackers

On Wed, Mar 21, 2018 at 2:29 PM, Murtuza Zabuawala <
[email protected]> wrote:

> Yes, that's cookie related issue (RM#3197), To fix that I added below in
> my config_local.py and it started working again,
>
> DEFAULT_SERVER = '0.0.0.0'
> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>

I haven't had to do that - and the 3.0 packages I just built for Windows
and Mac worked fine on fresh VMs without anything like that being needed.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:32       ` Re: Experiencing issues Dave Page <[email protected]>
@ 2018-03-21 14:36         ` Khushboo Vashi <[email protected]>
  1 sibling, 0 replies; 22+ messages in thread

From: Khushboo Vashi @ 2018-03-21 14:36 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: Murtuza Zabuawala <[email protected]>; Joao Pedro De Almeida Pereira <[email protected]>; pgadmin-hackers

On 21 Mar 2018 20:02, "Dave Page" <[email protected]> wrote:



On Wed, Mar 21, 2018 at 2:29 PM, Murtuza Zabuawala <murtuza.zabuawala@
enterprisedb.com> wrote:

> Yes, that's cookie related issue (RM#3197), To fix that I added below in
> my config_local.py and it started working again,
>
> DEFAULT_SERVER = '0.0.0.0'
> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>

I haven't had to do that - and the 3.0 packages I just built for Windows
and Mac worked fine on fresh VMs without anything like that being needed.

These changes required when you change DEFAULT_SERVER in config_local.py

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
  2018-03-21 14:25   ` Re: Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:29     ` Re: Experiencing issues Murtuza Zabuawala <[email protected]>
  2018-03-21 14:32       ` Re: Experiencing issues Dave Page <[email protected]>
@ 2018-03-21 14:37         ` Joao De Almeida Pereira <[email protected]>
  1 sibling, 0 replies; 22+ messages in thread

From: Joao De Almeida Pereira @ 2018-03-21 14:37 UTC (permalink / raw)
  To: Dave Page <[email protected]>; +Cc: Murtuza Zabuawala <[email protected]>; Khushboo Vashi <[email protected]>; pgadmin-hackers

Also when I see the request I get a different cookie session id for each
request

See the the attachments. I am using Ubuntu machine


On Wed, Ma[image: Screenshot from 2018-03-21 10-33-36.png]r 21, 2018 at
10:32 AM Dave Page <[email protected]> wrote:

> On Wed, Mar 21, 2018 at 2:29 PM, Murtuza Zabuawala <
> [email protected]> wrote:
>
>> Yes, that's cookie related issue (RM#3197), To fix that I added below in
>> my config_local.py and it started working again,
>>
>> DEFAULT_SERVER = '0.0.0.0'
>> COOKIE_DEFAULT_DOMAIN = SESSION_COOKIE_DOMAIN = DEFAULT_SERVER
>>
>
> I haven't had to do that - and the 3.0 packages I just built for Windows
> and Mac worked fine on fresh VMs without anything like that being needed.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>


Attachments:

  [image/png] Screenshot from 2018-03-21 10-33-36.png (50.5K, 3-Screenshot%20from%202018-03-21%2010-33-36.png)
  download | view image

  [image/png] Screenshot from 2018-03-21 10-33-54.png (56.4K, 4-Screenshot%20from%202018-03-21%2010-33-54.png)
  download | view image

^ permalink  raw  reply  [nested|flat] 22+ messages in thread

* Re: Experiencing issues
  2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
  2018-03-21 14:16 ` Re: Experiencing issues Khushboo Vashi <[email protected]>
@ 2018-03-21 14:25   ` Dave Page <[email protected]>
  1 sibling, 0 replies; 22+ messages in thread

From: Dave Page @ 2018-03-21 14:25 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: Joao Pedro De Almeida Pereira <[email protected]>; pgadmin-hackers

On Wed, Mar 21, 2018 at 2:16 PM, Khushboo Vashi <
[email protected]> wrote:

>
>
> On 21 Mar 2018 19:41, "Joao De Almeida Pereira" <
> [email protected]> wrote:
>
> Hello Hackers,
> Can anyone use the current master branch?
> When I try to open a server I get a 428. Is that only me?
>
> May be because of cookie changes.
> Check your config.py and config_local.py if you have done changes related
> to DEFAULT_SERVER in your config_local.py then you need to change other 2
> cookie related variables also.
>

Oh, I thought Joao meant he was having problems using the master branch on
the git server :-)



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

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


^ permalink  raw  reply  [nested|flat] 22+ messages in thread


end of thread, other threads:[~2018-03-23 10:14 UTC | newest]

Thread overview: 22+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-03-21 14:11 Experiencing issues Joao De Almeida Pereira <[email protected]>
2018-03-21 14:16 ` Dave Page <[email protected]>
2018-03-21 14:16 ` Khushboo Vashi <[email protected]>
2018-03-21 14:25   ` Joao De Almeida Pereira <[email protected]>
2018-03-21 14:29     ` Murtuza Zabuawala <[email protected]>
2018-03-21 14:31       ` Joao De Almeida Pereira <[email protected]>
2018-03-21 14:37         ` Murtuza Zabuawala <[email protected]>
2018-03-21 14:39         ` Khushboo Vashi <[email protected]>
2018-03-21 14:40           ` Joao De Almeida Pereira <[email protected]>
2018-03-21 14:55             ` Khushboo Vashi <[email protected]>
2018-03-21 14:57               ` Joao De Almeida Pereira <[email protected]>
2018-03-21 15:00                 ` Khushboo Vashi <[email protected]>
2018-03-21 15:57                   ` Joao De Almeida Pereira <[email protected]>
2018-03-21 16:01                     ` Dave Page <[email protected]>
2018-03-21 16:30                       ` Joao De Almeida Pereira <[email protected]>
2018-03-22 02:57                         ` Khushboo Vashi <[email protected]>
2018-03-23 06:17                       ` Khushboo Vashi <[email protected]>
2018-03-23 10:14                         ` Dave Page <[email protected]>
2018-03-21 14:32       ` Dave Page <[email protected]>
2018-03-21 14:36         ` Khushboo Vashi <[email protected]>
2018-03-21 14:37         ` Joao De Almeida Pereira <[email protected]>
2018-03-21 14:25   ` Dave Page <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox