Re: [ANNOUNCE] pgAdmin 4 v1.0 Released!

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Tim Clarke <tim(dot)clarke(at)manifest(dot)co(dot)uk>, PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: [ANNOUNCE] pgAdmin 4 v1.0 Released!
Date: 2016-10-01 00:43:07
Message-ID: 9b3e0c5a-218e-6ba6-6234-ab8ff8eba345@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce pgsql-general

On 09/30/2016 11:32 AM, Tim Clarke wrote:
> On 30/09/16 18:35, Devrim Gündüz wrote:
>> These are the -devel packages that I installed to build pgadmin4 RPMs:
>> BuildRequires: mesa-libGL-devel
>> BuildRequires: gcc-c++
>> BuildRequires: qt5-qtbase-devel >= 5.1
>> BuildRequires: qt5-qtwebkit-devel
>> BuildRequires: qt-devel >= 4.6
>> BuildRequires: qtwebkit-devel
>> BuildRequires: python3-devel
>> BuildRequires: python-devel
>>
>> In your case, I think qt-devel and qtwebkit-devel packages are needed.
>>
>> Regards,
>>
>
> Many thanks for that list Devrim, I always get slightly irritated as a
> developer on many platforms that the build process isn't slightly more
> transport sometimes. Since I'm running Ubuntu here, for the benefit of
> others, I had to:
>
> sudo apt-get install qt4-dev-tools libqtwebkit-dev
>
> Now I've compiled it with only:
>
>> /usr/lib/x86_64-linux-gnu/qt4/bin/rcc -name pgAdmin4 pgAdmin4.qrc -o
>> qrc_pgAdmin4.cpp
>> g++ -c -m64 -pipe -I/usr/include/python2.7
>> -I/usr/include/x86_64-linux-gnu/python2.7 -O2 -Wall -W -D_REENTRANT
>> -DPYTHON2 -DQT_NO_DEBUG -DQT_WEBKIT_LIB -DQT_GUI_LIB -DQT_NETWORK_LIB
>> -DQT_CORE_LIB -DQT_SHARED -I/usr/share/qt4/mkspecs/linux-g++-64 -I.
>> -I/usr/include/qt4/QtCore -I/usr/include/qt4/QtNetwork
>> -I/usr/include/qt4/QtGui -I/usr/include/qt4/QtWebKit
>> -I/usr/include/qt4 -I. -I. -o qrc_pgAdmin4.o qrc_pgAdmin4.cpp
>> In file included from qrc_pgAdmin4.cpp:9:0:
>> qrc_pgAdmin4.cpp:4142:44: warning:
>> ‘qInitResources_pgAdmin4__init_variable__’ defined but not used
>> [-Wunused-variable]
>> Q_CONSTRUCTOR_FUNCTION(QT_MANGLE_NAMESPACE(qInitResources_pgAdmin4))
>> ^
>> /usr/include/qt4/QtCore/qglobal.h:941:21: note: in definition of macro
>> ‘Q_CONSTRUCTOR_FUNCTION0’
>> static const int AFUNC ## __init_variable__ = AFUNC();
>> ^
>> qrc_pgAdmin4.cpp:4142:1: note: in expansion of macro
>> ‘Q_CONSTRUCTOR_FUNCTION’
>> Q_CONSTRUCTOR_FUNCTION(QT_MANGLE_NAMESPACE(qInitResources_pgAdmin4))
>> ^
>> qrc_pgAdmin4.cpp:4142:24: note: in expansion of macro
>> ‘QT_MANGLE_NAMESPACE’
>> Q_CONSTRUCTOR_FUNCTION(QT_MANGLE_NAMESPACE(qInitResources_pgAdmin4))
>> ^
>
>
> for notes (which I don't think are a problem but I could be wrong), I get:
>
>> timc(at)tim-573P:~/dev/pgadmin4-1.0/runtime$ ./pgAdmin4 &
>> [1] 9195
>> timc(at)tim-573P:~/dev/pgadmin4-1.0/runtime$ Python path: "/usr/bin/python"
>> Python Home: ""
>> Webapp path: "/home/timc/dev/pgadmin4-1.0/web/pgAdmin4.py"
>> Traceback (most recent call last):
>> File "/home/timc/dev/pgadmin4-1.0/web/pgAdmin4.py", line 24, in <module>
>> from pgadmin import create_app
>> File "/home/timc/dev/pgadmin4-1.0/web/pgadmin/__init__.py", line 17,
>> in <module>
>> from flask import Flask, abort, request, current_app
>> ImportError: No module named flask
>> "Failed to launch the application server, server thread exiting."
>>
>> [1]+ Exit 1 ./pgAdmin4
>
>
> when I try to run it despite an attempt to recover by:
>
>> sudo apt-get ^Cstall python-flask

It's more complicated then that as I found out.

First you will need to go into ~/.pgadmin and move pgadmin4.db out of
the way.

Then follow the instructions here:

https://www.pgadmin.org/docs4/1.x/desktop_deployment.html#configuration

Before you run the python setup.py part you will then have to install a
lot of Flask dependencies:

Flask-Babel==0.11.1
Flask-Gravatar==0.4.2
Flask-Login==0.3.2
Flask-Mail==0.9.1
Flask-Principal==0.4.0
Flask-Security==1.7.5
Flask-SQLAlchemy==2.1
Flask-WTF==0.13

also:

django-htmlmin==0.9.1

Then run python setup.py.

Personally I would go this route:

https://www.pgadmin.org/download/pip4.php

>
> Sigh
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-announce by date

  From Date Subject
Next Message David Fetter 2016-10-02 23:16:34 == PostgreSQL Weekly News - October 02 2016 ==
Previous Message Adrian Klaver 2016-09-30 20:24:44 Re: [ANNOUNCE] pgAdmin 4 v1.0 Released!

Browse pgsql-general by date

  From Date Subject
Next Message Armand Pirvu (home) 2016-10-01 01:36:36 Re: executing os commands from a function
Previous Message raf 2016-09-30 22:56:25 Re: Frequent "pg_ctl status" removing(?) semaphores (unlikely)