Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-20 Thread Fahar Abbas
All, I have not seen any issue in pgAdmin4 on MAC OS X(Python 3.5) Platform as well hence 1849 is resolved. Kind Regards, On Thu, Oct 20, 2016 at 1:35 PM, Fahar Abbas wrote: > Thanks pgAdmin4 Development team! > > User can launch pgAdmin4 with web browser with no issues with fresh setup, > i t

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-20 Thread Fahar Abbas
Thanks pgAdmin4 Development team! User can launch pgAdmin4 with web browser with no issues with fresh setup, i tried on Ubuntu 16.04 Linux 64(Python 3.5). Will also try on OS X with Python 3 and will let you know. On Thu, Oct 20, 2016 at 1:03 PM, Fahar Abbas wrote: > Thanks Ashesh for your step

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-20 Thread Fahar Abbas
Thanks Ashesh for your steps and will also test with new setup( on fresh machine) and our customers can face this problem with new setup and will update the status accordingly. On Thu, Oct 20, 2016 at 12:53 PM, Ashesh Vashi < ashesh.va...@enterprisedb.com> wrote: > You were missing the other plac

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-20 Thread Ashesh Vashi
You were missing the other places, before the function - do_setup(..) call, where we are generating the other keys automatically. I've checked-in the code. Fahar, If you want to test the issue properly, please follow the below steps: - git checkout c4f1b8eb112e99d228c40a412020fa616dbe44f6 This

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-20 Thread Ashesh Vashi
On Thu, Oct 20, 2016 at 1:00 PM, Fahar Abbas wrote: > Murtaza, > > Once i delete key table from pgAdmin4.db file then i can launch pgAdmin4 > with terminal as well as web browser for existing pgAdmin4 setup. > > > In case of fresh setup once we delete key table and apply latest patch > following

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-20 Thread Fahar Abbas
Murtaza, Once i delete key table from pgAdmin4.db file then i can launch pgAdmin4 with terminal as well as web browser for existing pgAdmin4 setup. In case of fresh setup once we delete key table and apply latest patch following message displayed: python pgAdmin4.py Traceback (most recent call

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Dave Page
I think you'll also need to set the version back to 13 in the version table. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL Company > On 20 Oct 2016, at 07:00, Murtuza Zabuawala > wrote: > > Could you del

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
I tried different variations and when launch pgAdmin4 with web browser still exception displayed when user deleted .pgadmin folder Here is the output: python pgAdmin4.py Starting pgAdmin 4. Please navigate to http://localhost:5050 in your browser. Exception in thread Threa

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Murtuza Zabuawala
Could you delete 'keys' table from pgadmin4.db file & try again? -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Thu, Oct 20, 2016 at 11:26 AM, Fahar Abbas wrote: > Murtaza, > > I have applied this patch and there is no success on new

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
Murtaza, I have applied this patch and there is no success on new pgAdmin4 setup as well as existing pgAdmin4 setup. On Thu, Oct 20, 2016 at 10:45 AM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > Hi, > > PFA patch to fix the issue for Pyhton3. > RM#1849 > > -- > Regards, > Mu

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Murtuza Zabuawala
Hi, PFA patch to fix the issue for Pyhton3. RM#1849 -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Thu, Oct 20, 2016 at 11:03 AM, Fahar Abbas wrote: > Hi Dave, > > I have reopened following RM: > > h

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
Hi Dave, I have reopened following RM: https://redmine.postgresql.org/issues/1849 On Wed, Oct 19, 2016 at 6:04 PM, Dave Page wrote: > Patch applied. > > On Wed, Oct 19, 2016 at 11:55 AM, Ashesh Vashi < > ashesh.va...@enterprisedb.com> wrote: > >> Hi Fahar, >> >>

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Dave Page
Thanks, applied. On Wed, Oct 19, 2016 at 1:39 PM, Sandeep Thakkar < sandeep.thak...@enterprisedb.com> wrote: > Here is the patch where we remove the config_local.py being created during > packaging. The mac build script missed creating config_distro.py earlier > and it has been take care of now.

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Dave Page
Patch applied. On Wed, Oct 19, 2016 at 11:55 AM, Ashesh Vashi < ashesh.va...@enterprisedb.com> wrote: > Hi Fahar, > > Please log the case on redmine. > Please find the attached patch, please apply it locally, and test it. > > And, please update the case, and this mail chain accordingly. > > -- >

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Dave Page
I assume that's an existing issue with Python 3.5? That file wasn't changed by this patch. On Wed, Oct 19, 2016 at 1:11 PM, Neel Patel wrote: > Hi, > > Just to update for Python 3. > It gives below error while running "pgAdmin4.py". > > # > > Traceback (most recent call last): > File "/usr

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
After applying this patch on Python 2.7.11 on Windows 2012 64bit, User can launch pgAdmin4 with python pgAdmin4.py without any error. Will also retest once the 1871 will be resolved On Wed, Oct 19, 2016 at 5:19 PM, Fahar Abbas wrote: > Yes Neel is Right. > > This issue is also reproducible with

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Sandeep Thakkar
Here is the patch where we remove the config_local.py being created during packaging. The mac build script missed creating config_distro.py earlier and it has been take care of now. Please review the attached patch. I'll also make the changes in the EDB packaging scripts where we bundle pgAdmin in

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
Yes Neel is Right. This issue is also reproducible with Python 3.5 when user Launch python with pgAdmin4.py python pgAdmin4.py Starting pgAdmin 4. Please navigate to http://localhost:5050 in your browser. Exception in thread Thread-1: Traceback (most recent call last): File "/usr/lib/python3.5/

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Neel Patel
Hi, Just to update for Python 3. It gives below error while running "pgAdmin4.py". # Traceback (most recent call last): File "/usr/lib/python3.4/threading.py", line 920, in _bootstrap_inner self.run() File "/usr/lib/python3.4/threading.py", line 868, in run self._target(*self._ar

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Dave Page
Great, thanks! On Wed, Oct 19, 2016 at 12:42 PM, Fahar Abbas wrote: > > > On Wed, Oct 19, 2016 at 4:03 PM, Fahar Abbas > wrote: > >> >> >> On Wed, Oct 19, 2016 at 3:55 PM, Ashesh Vashi < >> ashesh.va...@enterprisedb.com> wrote: >> >>> Hi Fahar, >>> >>> Please log the case on redmine. >>> >> htt

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
On Wed, Oct 19, 2016 at 4:03 PM, Fahar Abbas wrote: > > > On Wed, Oct 19, 2016 at 3:55 PM, Ashesh Vashi < > ashesh.va...@enterprisedb.com> wrote: > >> Hi Fahar, >> >> Please log the case on redmine. >> > https://redmine.postgresql.org/issues/1871 > >> Please find the attached patch, please apply

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Ashesh Vashi
Hi Fahar, Please log the case on redmine. Please find the attached patch, please apply it locally, and test it. And, please update the case, and this mail chain accordingly. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *htt

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Sandeep Thakkar
Hi Dave, On Wed, Oct 19, 2016 at 1:57 PM, Dave Page wrote: > Patch applied. > > Fahar, can you please test this thoroughly in desktop and server modes, > with both fresh and upgraded installations? > > https://redmine.postgresql.org/issues/1849 > > Packagers: This change means that packages are

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
On Wed, Oct 19, 2016 at 3:55 PM, Ashesh Vashi wrote: > Hi Fahar, > > Please log the case on redmine. > https://redmine.postgresql.org/issues/1871 > Please find the attached patch, please apply it locally, and test it. > > And, please update the case, and this mail chain accordingly. > > Sure Wil

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
Here is the output of if we copy config_local.py and execute python setup.py pgAdmin 4 - Application Initialisation == The configuration database - '/home/fahar/.pgadmin/pgadmin4.db' does not exist. Entering initial setup mode... NOTE: Configuring authenticatio

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
Dave, Testing Environment Ubuntu 16.04 Linux 64: pg-AdminIV Development Environment Setup for Ubuntu : 1) Install GIT sudo apt-get install git 2) Install pip3 sudo apt-get install python3-pip 3) Install virtualenv sudo pip3 install virtualenv 4) install

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Fahar Abbas
Sure, Will test this thoroughly after complete investigation. Kind Regards, On Wed, Oct 19, 2016 at 1:27 PM, Dave Page wrote: > Patch applied. > > Fahar, can you please test this thoroughly in desktop and server modes, > with both fresh and upgraded installations? > > https://redmine.postgresq

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-19 Thread Dave Page
Patch applied. Fahar, can you please test this thoroughly in desktop and server modes, with both fresh and upgraded installations? https://redmine.postgresql.org/issues/1849 Packagers: This change means that packages are no longer forced to create a config_local.py file, and there is no longer a

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-18 Thread Ashesh Vashi
Hi Dave, On Sat, Oct 15, 2016 at 8:02 AM, Dave Page wrote: > Hi > > > On Friday, October 14, 2016, Dave Page wrote: > >> Hi >> >> On Thursday, October 13, 2016, Ashesh Vashi < >> ashesh.va...@enterprisedb.com> wrote: >> >>> Hi Dave, >>> >>> On Tue, Oct 11, 2016 at 9:10 PM, Dave Page wrote: >>>

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-14 Thread Dave Page
Hi On Friday, October 14, 2016, Dave Page wrote: > Hi > > On Thursday, October 13, 2016, Ashesh Vashi > wrote: > >> Hi Dave, >> >> On Tue, Oct 11, 2016 at 9:10 PM, Dave Page wrote: >> >>> Hi Ashesh, >>> >>> Can you please review the attached patch, and apply if you're happy with >>> it? >>> >>

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-14 Thread Dave Page
Hi On Thursday, October 13, 2016, Ashesh Vashi wrote: > Hi Dave, > > On Tue, Oct 11, 2016 at 9:10 PM, Dave Page > wrote: > >> Hi Ashesh, >> >> Can you please review the attached patch, and apply if you're happy with >> it? >> > Overall the patch looked good to me. > But - I encounter an issue i

Re: [pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-13 Thread Ashesh Vashi
Hi Dave, On Tue, Oct 11, 2016 at 9:10 PM, Dave Page wrote: > Hi Ashesh, > > Can you please review the attached patch, and apply if you're happy with > it? > Overall the patch looked good to me. But - I encounter an issue in 'web' mode, which wont happen with 'runtime'. Steps for reproduction on

[pgadmin-hackers] RM1849: Auto-generating security keys

2016-10-11 Thread Dave Page
Hi Ashesh, Can you please review the attached patch, and apply if you're happy with it? The purpose is to auto-generate the various security keys that are currently in the configuration file, and store them in the SQLite database. This allows us to remove the checks for config_local.py and the ha