Here is my setup script for pgadmin in server mode on Centos 7 using the docs
as a base.
It may or may not be useful
----------------------------------------------------------
#Install pgadmin
yum -y install pgadmin4-v1-web
yum -y install python-passlib
#Create user for pgadmin
useradd --create-home --home-dir /var/pgadmin --system --shell /sbin/nologin
pgadmin
#Allow apache access to the pgadmin home directory
semanage fcontext -a -t httpd_sys_rw_content_t "/var/pgadmin(/.*)?"
restorecon -R /var/pgadmin
#Allow pgadmin to connect to postgres
setsebool -P httpd_can_network_connect_db 1
#Overide SERVER_MODE (must be done BEFORE setup)
cat >> /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py << "EOF"
SERVER_MODE = True
EOF
#Add default username and password and setup database
su -s /bin/sh -c 'python
/usr/lib/python2.7/site-packages/pgadmin4-web/setup.py' pgadmin
#Add apache configuration
cat >> /etc/httpd/conf.d/pgadmin4-v1.conf << "EOF"
CustomLog "logs/pgadmin-access_log" combined
ErrorLog "logs/pgadmin-error_log"
LogLevel error
WSGIDaemonProcess pgadmin processes=1 threads=25 user=pgadmin group=pgadmin
WSGIScriptAlias /pgadmin4
/usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.wsgi
<Directory /usr/lib/python2.7/site-packages/pgadmin4-web>
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
Require all granted
</Directory>
EOF
#Open firewall for pgadmin
firewall-cmd --permanent --zone=public --add-port=80/tcp
firewall-cmd --permanent --zone=public --add-port=443/tcp
firewall-cmd --reload
#Start apache
systemctl enable httpd.service
systemctl start httpd.service
----------------------------------
From: Dave Page [mailto:dp...@pgadmin.org]
Sent: 19 July 2017 17:03
To: Mike Surcouf
Cc: pgadmin-supp...@postgresql.org
Subject: Re: Consider default SERVER_MODE =True for pgadmin4-v1-web
On Wed, Jul 19, 2017 at 4:54 PM, Mike Surcouf
<mi...@surcouf.co.uk<mailto:mi...@surcouf.co.uk>> wrote:
It would be nice if the pgadmin40v1-web package set the SERVER_MODE = True
I can't think why you would install the web package without this but there may
be a reason?
Yes, it would break the default installation mode (desktop).
The web package is "the web components of pgadmin", not "pgadmin to run in web
mode".
Also since the setup script does different things depending on this value if
you don't do it first you have to delete the config and sqllite database and
start again otherwise it will never work
Currently I have this in my setup script
#Overide SERVER_MODE (must be done BEFORE setup)
cat >> /usr/lib/python2.7/site-packages/pgadmin4-web/config_local.py << "EOF"
SERVER_MODE = True
EOF
I tend to just edit that setting in config_local.py as I need it, but then also
include:
# Use a different config DB for each server mode.
if SERVER_MODE == False:
SQLITE_PATH = os.path.join(
DATA_DIR,
'pgadmin4-desktop.db'
)
else:
SQLITE_PATH = os.path.join(
DATA_DIR,
'pgadmin4-server.db'
)
Anyway, to the main point - I've been trying to figure out a half-decent way of
being able to support both server and desktop modes out of the box; and have
yet to come up with anything that wouldn't be a tangled mess of config files. I
still have some ideas though, and hope to explore them some more tomorrow.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
