Re: Setting up pgAdmin4 as a web application

[Please keep the mailing list CC'd]

On Wed, Oct 19, 2016 at 3:32 PM, Derek Ealy <dealy663(at)gmail(dot)com> wrote:
> I had already tried something similar and it didn't work.
>
> I moved my stuff out of /var/www/.pgadmin to the directory locations you
> suggested and set ownership to the www-data user and group. After restarting
> apache I get exactly the same error message as before. The pgadmin4.db file
> is created in /var/lib/pgadmin4 and is set to: -rw-r--r-- 1 www-data
> www-data 0 Oct 19 07:25 pgadmin4.db. However the file remains at zero
> bytes. So there are enough permissions to create all of the files in the
> specified directories. But something is still preventing the actual writing
> to the DB file.
>
> Is there some way that the pgadmin python logic could be running as a
> different user than the apache http process?

Nothing in our code.

You could try the following:

1) Delete pgadmin4.db
2) Run setup.py as root
3) If that appears successful, "chown www-data:www-data pgadmin4.db"
4) See if it works

If not, please send a copy of your config files, and any logs or
screen output that may be relevant.

Thanks.

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

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