Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b1Cst-0001mr-7M for pgadmin-hackers@arkaria.postgresql.org; Fri, 13 May 2016 13:12:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b1Css-00070y-Qg for pgadmin-hackers@arkaria.postgresql.org; Fri, 13 May 2016 13:12:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b1Csr-0006zL-P4 for pgadmin-hackers@postgresql.org; Fri, 13 May 2016 13:12:01 +0000 Received: from mail-ig0-x231.google.com ([2607:f8b0:4001:c05::231]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1b1Cso-0004em-0v for pgadmin-hackers@postgresql.org; Fri, 13 May 2016 13:12:01 +0000 Received: by mail-ig0-x231.google.com with SMTP id s8so9969794ign.0 for ; Fri, 13 May 2016 06:11:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc; bh=uqV38nhFt0ni/vXhlmmyzUkBBvBputoagcEbK8COwuY=; b=E1gkCv4mqebZYyUFea3woL/qxvgdh/ghkbk/hCBfRX7zgja0lbFge11AqZLCGk+eRu Vx5Z3iC3j/bO8v3CikPiwZl3KqayDFSl0vgOVk2AQfbdDDcRQ76M3zas0xB3omQbShKP GvKZ90lbZwTzGaeOMYz2x74dDc0PxiirA4F/+TyQoCBgR8Fli6yPh1lMoICxU9+BYJzf eSsQh6rhM38Y6myMQuP5hPLLCqD3WL2paBST41KxxUokG50MEwUvPQiVwp14Ep041Qsh fsWdcQAhPjo1Ib9w1QuDPZjFepS5Z6Fl0cgQj8+VqOvqFsZ+CIj0VGYparPSdd9fbdit xQ7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=uqV38nhFt0ni/vXhlmmyzUkBBvBputoagcEbK8COwuY=; b=j7Ngvtua2DRNpD++nVcG6OYlyegfpFM2t/ziXjfcRd+n6uFYAnTNV562+/vIDVGwDP G00UKq1OjN59+dAxgeA1W99sgAirY3nRRiIw7qxw78IKCEp5WyUn46mbx2LHsDzzPaMa pxtkKPViT/2Nj7CouiH5SWQjLJyNyONxJr9x++nK3vY/W8QFHJ2gBkiqjOmE4bqDonmH du1bTUu5LgtwOAwodirb8dne/LrLgLcJhUt5k02P511TT0uftZh9KMCd4Yzm6XFdfa6Q v8ouIx/LlQl5/Ur1wmGo58Jm05qhYL8cj3yqlvIb32A+EbS5SiG6JGsMTCLwXQn1MU/+ ExAQ== X-Gm-Message-State: AOPr4FW+kQ77eBtycFpto0LgckLktipjkd7OoULRAuh3qy+F0tSsp7I79GAPE4SIrHP4yLfu/YX3nrNArLBupQ== MIME-Version: 1.0 X-Received: by 10.50.73.169 with SMTP id m9mr721187igv.11.1463145116262; Fri, 13 May 2016 06:11:56 -0700 (PDT) Received: by 10.64.34.236 with HTTP; Fri, 13 May 2016 06:11:56 -0700 (PDT) In-Reply-To: References: Date: Fri, 13 May 2016 14:11:56 +0100 Message-ID: Subject: Re: Patch for pgAdmin4 package on Mac OS X From: Dave Page To: Sandeep Thakkar Cc: pgadmin-hackers , Hamid Quddus Content-Type: text/plain; charset=UTF-8 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org On Fri, May 13, 2016 at 2:01 PM, Sandeep Thakkar wrote: > Thanks Dave. > > Please see inline. > > On Fri, May 6, 2016 at 9:03 PM, Dave Page wrote: >> >> Hi >> >> Thanks. I've applied the path fix patch. The second one needs a little >> work - I've attached an updated version to work from: >> >> - I've updated the README, and some of the default values. > > OK. The default values of PGDIR and QTDIR set by you is different than mine. > I installed them through macports. Right. I went with the default directories from the original projects. >> >> - I've removed the file type registration for .sql files. > > > OK. >> >> >> - Should we note that the user may need to run in a virtualenv? > > > No, we bundle private environment, right? I meant "the user building the package", not the end user. >> - Please move build-mac.sh to pkg/build.sh, and create a target in >> /Makefile to >> execute it, e.g. "make appbundle" > > > Sure. You mean move to pkg/mac/build.sh, right? Yes :-) >> - Extend the Makefile to add a "clean-appbundle" target, which should also >> be >> called by the "clean" target. >> > OK. >> >> - At present, it is bundling my pre-existing configuration database. It >> *must* >> create a new one and bundle that, without touching the existing one (I >> guess >> that may require a new command line option for setup.py). > > > No, it's not bundling the pgadmin4.db at all, I skipped it :). Paresh is > working on this. Oh - in that case it used my existing one. Which of course, it should not overwrite if already present (which reminds me - adding a todo item to auto-upgrade the database if needed on first run). >> - The online help is broken (are you building it)? I suggest adding a >> top-level >> Makefile target to do so. >> > Sorry, which online help? That which can be found in $SRC/doc - currently only for en_US. At present it's built with "cd doc/en_US && make -f Makefile.sphinx html", but I think we should have a top-level target to call that for us. The help can then be accessed from Help -> Online Help within pgAdmin. Obviously the files need to be put in the right place in the app bundle. >> - Working directories should be added to /.gitignore. Please ensure they >> don't >> clash with those used by pip (and ideally are in one place, e.g. >> mac-build/). >> > OK. > >> >> - I saw various errors in the build output, though the resulting DMG >> seemed to >> work fine; >> > Yeah, because I had libpq.dylib present in $PGDIR/ and may be yours present > in $PGDIR/lib/. I will be using the default values suggested by you and fix > this. Thanks! Right - please make sure the build fails in cases like this too. Thanks. >> ... >> cp: /usr/local/pgsql/libpq.5.dylib: No such file or directory >> libpq.5.dylib not found in /usr/local/pgsql >> Completing app: /Users/dpage/git/pgadmin4/pgAdmin4.app >> ... >> >> ... >> App: pgAdmin4.app: Post-processing: .//Contents/MacOS/pgAdmin4 >> App: pgAdmin4.app: Adding symlink: QtWebKitWidgets (because of: >> .//Contents/MacOS/pgAdmin4) >> cp: >> @rpath/QtWebKitWidgets.framework/Versions/5/../../../QtWebKitWidgets.framework: >> No such file or directory >> chmod: >> Contents/Frameworks/QtWebKitWidgets.framework/Versions/5/QtWebKitWidgets: >> No such file or directory >> Rewriting ID in >> Contents/Frameworks/QtWebKitWidgets.framework/Versions/5/QtWebKitWidgets >> to QtWebKitWidgets >> error: >> /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/install_name_tool: >> can't open file: >> Contents/Frameworks/QtWebKitWidgets.framework/Versions/5/QtWebKitWidgets >> (No such file or directory) >> Cleaning up >> ... >> >> >> On Mon, Apr 18, 2016 at 1:25 PM, Sandeep Thakkar >> wrote: >> > Hi Team, Dave, >> > >> > Attached herewith are two patches. >> > >> > pgadmin4-mac-bundle.patch - This includes scripts to build Mac app >> > bundle >> > and DMG for pgAdmin4. This is the tree of the generated app bundle: >> > >> > ---- >> > $ find pgAdmin4.app/ -maxdepth 3 -type d >> > pgAdmin4.app/ >> > pgAdmin4.app//ContentspgAdmin4.app//Contents/Frameworks >> > pgAdmin4.app//Contents/Frameworks/Python.framework >> > pgAdmin4.app//Contents/Frameworks/QtCore.framework >> > pgAdmin4.app//Contents/Frameworks/QtDBus.framework >> > pgAdmin4.app//Contents/Frameworks/QtGui.framework >> > pgAdmin4.app//Contents/Frameworks/QtMultimedia.framework >> > pgAdmin4.app//Contents/Frameworks/QtMultimediaWidgets.framework >> > pgAdmin4.app//Contents/Frameworks/QtNetwork.framework >> > pgAdmin4.app//Contents/Frameworks/QtOpenGL.framework >> > pgAdmin4.app//Contents/Frameworks/QtPositioning.framework >> > pgAdmin4.app//Contents/Frameworks/QtPrintSupport.framework >> > pgAdmin4.app//Contents/Frameworks/QtQml.framework >> > pgAdmin4.app//Contents/Frameworks/QtQuick.framework >> > pgAdmin4.app//Contents/Frameworks/QtSensors.framework >> > pgAdmin4.app//Contents/Frameworks/QtSql.framework >> > pgAdmin4.app//Contents/Frameworks/QtWebChannel.framework >> > pgAdmin4.app//Contents/Frameworks/QtWebKit.framework >> > pgAdmin4.app//Contents/Frameworks/QtWebKitWidgets.framework >> > pgAdmin4.app//Contents/Frameworks/QtWidgets.framework >> > pgAdmin4.app//Contents/MacOS >> > pgAdmin4.app//Contents/PlugIns >> > pgAdmin4.app//Contents/PlugIns/platforms >> > pgAdmin4.app//Contents/Resources >> > pgAdmin4.app//Contents/Resources/venv >> > pgAdmin4.app//Contents/Resources/web >> > --- >> > >> > pgadmin4-fixpath-mac.patch - This is for runtime/Server.cpp to fix the >> > path >> > where the runtime looks for web application path in app bundle. >> > >> > >> > Kindly review and suggest the changes required. Thanks. >> > >> > -- >> > Sandeep Thakkar >> > >> >> >> >> -- >> Dave Page >> Blog: http://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EnterpriseDB UK: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company > > > > > -- > Sandeep Thakkar > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers