chorss/docker-pgadmin4

Docker image pgAdmin4

docker-pgadmin4's Issues

The password recovery does not work

When I'm trying recovery password, after email specifed opens error page "This page isn’t working" (ERR_EMPTY_RESPONSE).

anymore updates?

just wondering will this be updated to latest version?

Please upgrade to v4.5

thx

no Port Exposed

Hi ,
I am not sure if i am missing something
i cant see an EXPOSE line.
So there is no exposed port ? I see previous builds have EXPOSE
usually port 5050

Thanks

Integrate changes from https://github.com/sumpfgottheit/docker-pgAdmin4

Hi,

I don't want to make a pull request, because my changes change your concept, as I no longer use the USER directive, but start pgadmin via su-exec.

The README contains a list with changes to your version:

• Now uses pgAdmin4 v2.0
• Based on Python 3.6 / Alpine 3.6 (Alpine 3.6 is needed because the shadow packages, which contains usermod is not available in 3.4)
• New Variables: UID and GID - the pgadmin-user is changed to the UID/GID and /data is chowned on startup.
• Disables File-Logging to stdout: http://www.postgresql-archive.org/Unable-to-log-to-stdout-for-pgadmin4-in-python3-td5981864.html

I can of course make a pull request, if you want.

backup and restore

this image is awesome. but i got some difficulties when i want to executes backup and restore process.
fyi.
i successfully restore data manually in container db-engine
i use this image "centos/postgresql-94-centos7" as database-engine.
any advise how to setup the backup and restore process.
thanks

add pg binaries to local_config

Its a controlled environment, pg is in a controlled environment, so it seems like its a pretty safe thing to default.

login failed

image: chorss/docker-pgadmin4
    ports:
      - 8888:5050
    environment:
      - SERVER_MODE=true
      - [email protected]
      - PGADMIN_SETUP_PASSWORD=xxxxxx
    volumes:
      - ./pgadmin_data:/data 

this is my docker-compose.yml file, i start stack ,in browser i can open web page,but i input [email protected] / xxxxxx, login failed... what' wrong , your doc less of something ,,you know

Can you please update to version 3.5.

thanks

Container doesnt start because of unmet python dependencies

GID=50
UID=1000
usermod: no changes
Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py", line 67, in <module>
    app = create_app()
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/__init__.py", line 569, in create_app
    from flask_htmlmin import HTMLMIN
ModuleNotFoundError: No module named 'flask_htmlmin'

Fix required:

pip install flask_htmlmin

Confirmed using:

docker run -it --name saveit chorss/docker-pgadmin4 pip install flask_htmlmin
docker commit saveit chorss/docker-pgadmin4
docker run --rm -it chorss/docker-pgadmin4

Permission denied: '/data/config'

Using the command docker run -d -p 5050:5050 -v /home/user/data:/data chorss/docker-pgadmin4 I'm getting this error:

Traceback (most recent call last):
  File "./usr/local/lib/python2.7/site-packages/pgadmin4/pgAdmin4.py", line 55, in <module>
    exec(open(file_quote(setupfile), 'r').read())
  File "<string>", line 46, in <module>
  File "/usr/local/lib/python2.7/site-packages/pgadmin4/pgadmin/setup/data_directory.py", line 23, in create_app_data_directory
    _create_directory_if_not_exists(os.path.dirname(config.SQLITE_PATH))
  File "/usr/local/lib/python2.7/site-packages/pgadmin4/pgadmin/setup/data_directory.py", line 15, in _create_directory_if_not_exists
    os.mkdir(_path)
OSError: [Errno 13] Permission denied: '/data/config'

Version 4.2 build failed

I looks like version 4.2 was not build correctly as you can see here.

br

Please tag the image with 3.6 at hub.docker.com

At the docker hub the latest version is only tagged with latest; could you also please tag it with 3.6 ?

Thanks.

PermissionError when tryting to start container

Hi,

OS : openSUSE Leap 64 bits
Docker Version : 17.04.0-ce
CPU | 56
Memory | 135.1 GB

When trying to start Docker with command like quickstart,
docker run -d -p 8000:5050 -v /srv/data/pgadmin4_data:/data chorss/docker-pgadmin4

starting failed, see log :

usermod: no changes
Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py", line 55, in <module>
    exec(open(file_quote(setupfile), 'r').read())
  File "<string>", line 46, in <module>
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/setup/data_directory.py", line 26, in create_app_data_directory
    _create_directory_if_not_exists(os.path.dirname(config.LOG_FILE))
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/setup/data_directory.py", line 15, in _create_directory_if_not_exists
    os.mkdir(_path)
PermissionError: [Errno 13] Permission denied: '/data/logs'

even with specify when I specify default OS user and associated group :

docker run -d -p 8000:5050 -e UID=1000 -e GID=100 -v /srv/data/pgadmin4_data:/data chorss/docker-pgadmin4

groupmod: GID '100' already exists
usermod: no changes
Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py", line 55, in <module>
    exec(open(file_quote(setupfile), 'r').read())
  File "<string>", line 46, in <module>
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/setup/data_directory.py", line 26, in create_app_data_directory
    _create_directory_if_not_exists(os.path.dirname(config.LOG_FILE))
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/setup/data_directory.py", line 15, in _create_directory_if_not_exists
    os.mkdir(_path)
PermissionError: [Errno 13] Permission denied: '/data/logs'

I'm quite new about Docker but it seems I've done right but on the same machine, i!'m running other docker such as portainer, postgis, etc.

Thanks for help ;)

Here is a Dockerfile which will build v3.5

Can't open a pull request, but this runs locally on my machine

FROM python:alpine3.8

LABEL maintainer="Kacper Czarczyński <[email protected]>"

ENV PGADMIN_VERSION 3.5
ENV UID             1000
ENV GID             50

ENV SERVER_MODE   false
ENV SERVER_PORT   5050
ENV MAIL_SERVER   mail.example.tld
ENV MAIL_PORT     465
ENV MAIL_USE_SSL  false
ENV MAIL_USE_TLS  false
ENV MAIL_USERNAME username
ENV MAIL_PASSWORD password
ENV MAIL_DEBUG    false

# Metadata
LABEL   org.label-schema.name="pgAdmin4" \
        org.label-schema.description="Docker image pgAdmin4" \
        org.label-schema.url="https://www.pgadmin.org" \
        org.label-schema.license="PostgreSQL" \
        org.label-schema.version=${PGADMIN_VERSION} \
        org.label-schema.vcs-url="https://github.com/Chorss/docker-pgAdmin4"

RUN apk add --no-cache --virtual .run-deps postgresql postgresql-libs libffi-dev openssl shadow sudo su-exec bash linux-headers
RUN apk add --no-cache --virtual .build-deps make gcc musl-dev openssl postgresql-dev \
 && pip3 --no-cache-dir install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v${PGADMIN_VERSION}/pip/pgadmin4-${PGADMIN_VERSION}-py2.py3-none-any.whl \
 && apk del .build-deps \
 && rm -rf /root/.cache

RUN addgroup -g ${GID} -S pgadmin \
 && adduser -D -S -h /pgadmin -s /sbin/nologin -u ${UID} -G pgadmin pgadmin \
 && mkdir -p /data/config /data/logs /data/storage /data/sessions /data/misc \
 && chown -R ${UID}:${GID} /data \
 && rm -rf /root/.cache

COPY config_local.py /usr/local/lib/python3.7/site-packages/pgadmin4/
COPY entrypoint /
RUN chmod 0775 /entrypoint

VOLUME /data
EXPOSE ${SERVER_PORT}
ENTRYPOINT ["/entrypoint"]

CMD ["su-exec", "pgadmin", "python", "/usr/local/lib/python3.7/site-packages/pgadmin4/pgAdmin4.py"]

Change password doesn't work

When logged into server mode, change password does not work, any idea why?

SSL

When I use your sample to run the container, it only works on a http connection not on a https connection... any suggestions ?