timwolla / docker-adminer Goto Github PK

View Code? Open in Web Editor NEW

154.0 6.0 68.0 162 KB

Database management in a single PHP file

Home Page: https://hub.docker.com/_/adminer/

PHP 40.87% Shell 30.06% Dockerfile 29.07%

database-management docker-image adminer php

docker-adminer's Introduction

https://github.com/TimWolla/docker-adminer

Maintained by: Tim Düsterhus (of the Docker Community)

This is the Git repo of the Docker "Official Image" for adminer (not to be confused with any official adminer image provided by adminer upstream). See the Docker Hub page for the full readme on how to use this Docker image and for information regarding contributing and issues.

The full image description on Docker Hub is generated/maintained over in the docker-library/docs repository, specifically in the adminer directory.

See a change merged here that doesn't show up on Docker Hub yet?

For more information about the full official images change lifecycle, see the "An image's source changed in Git, now what?" FAQ entry.

For outstanding adminer image PRs, check PRs with the "library/adminer" label on the official-images repository. For the current "source of truth" for adminer, see the library/adminer file in the official-images repository.

Build	Status	Badges	(per-arch)

docker-adminer's People

Contributors

Stargazers

Watchers

docker-adminer's Issues

Adminer Theme Doesn't Show

Adding the ADMINER_DESIGN environment variable doesn't change the theme. Using this docker-compose.yml and dockerfile, where the dockerfile for adminer is just defaults, since env_file takes precedence.

Docker Compose

version: '2'

services:
  server:
    container_name: server
    build:
      context: .
      dockerfile: .docker/node.${APP_ENV}.dockerfile
    ports:
      - "${NODE_PORT}:3000"
    volumes:
      - ${NODE_SRC_PATH}:${NODE_CONTAINER_PATH}
    working_dir: ${NODE_WORKING_DIR}
    env_file:
      - ./.docker/env/node.${APP_ENV}.env
    depends_on:
      - db
    networks:
      - app-network

  db:
    container_name: db
    image: mysql
    build:
      context: .
      dockerfile: .docker/mysql.dockerfile
    ports:
      - "3306:3306"
    env_file:
      - ./.docker/env/mysql.${APP_ENV}.env
    networks:
      - app-network

  db_manager:
    container_name: db_manager
    image: adminer
    build:
      context: .
      dockerfile: .docker/adminer.dockerfile
    ports:
      - "8080:8080"
    env_file:
      - ./.docker/env/adminer.env
    networks:
      - app-network

networks:
  app-network:
    driver: bridge

Adminer Env

ADMINER_DESIGN=pepa-linha

Docker File

# Pull in image
FROM adminer:latest

MAINTAINER Source Reactor

# Provide environmental variables
# ---
# NOTE:
# Environment precedents is taken from the environment key, then the .env
# file, and finally from ENV entries in the dockerfile, which represent
# development defaults
# ---
ENV ADMINER_DESIGN=pepa-linha

Could you update the image documentation to include all of the environment variables and what they do?

This would make it much easier to get started with the container: A simple list of each environment variable, along with it's intended use.

Thanks

Can't load custom plugin

I want to load a custom plugin, but the container crashes everytime.

Here is my docker-compose

version: "3.7"

services:
  service-postgresql:
    container_name: container-postgresql
    image: postgres:latest
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_PASSWORD=my-pass
      - POSTGRES_USER=my-user
      - POSTGRES_DB=my-db

service-adminer:
    container_name: container-adminer
    image: adminer:fastcgi
    depends_on:
      - service-postgresql
    volumes:
      - ./my-path-to-folder/Adminer/plugins-enabled/login-servers.php:/var/www/html/plugins-enabled/login-servers.php:ro
    environment:
      - ADMINER_DEFAULT_SERVER=service-postgresql
      - ADMINER_PLUGINS=login-servers

service-nginx:
    container_name: container-nginx
    image: nginx
    depends_on:
      - service-adminer
    ports:
      - "80:80"
    volumes:
      - /my/path/conf.d:/etc/nginx/conf.d:ro

./my-path-to-folder/Adminer/plugins-enabled/login-servers.php

<?php
require_once('plugins/login-servers.php');

return new AdminerLoginServers([
	'PostgreSQL' => [
		'server' => $_ENV['ADMINER_DEFAULT_SERVER'],
		'driver' => 'pgsql'
	]
]);

Crash log

Unable to load plugin file "login-servers", because it has required parameters: servers
Create a file "/var/www/html/plugins-enabled/login-servers.php" with the following contents to load the plugin:

<?php
require_once('plugins/login-servers.php');

/** Set supported servers
	* @param array array($description => array("server" => , "driver" => "server|pgsql|sqlite|..."))
	*/
return new AdminerLoginServers(
	$servers = ???
);

Somebody can tell me what I'm doing wrong?

Thanks in advance!

Base URI or folder

Hi there,

is there any way to set a base URI or variable when deploying into a subfolder?

e.g. I have my docker running at http://localhost:8080, which is proxied using nginx to https://mysite.whatever.com/my_folder/

Now, I've noticed that this container redirects everything to /.
All links in the dashboard are absolute and point to https://mysite.whatever.com/?querystring instead of https://mysite.whatever.com/my_folder/?querystring

Is there any env variable or configuration that can fix this behavior? Or is this an application issue?

I add the nginx.conf workaround which works mostly for the login, but does not work for some links, i.e.

     location /my_folder/ {
        proxy_pass http://127.0.0.1:8080/;
        proxy_redirect / /my_folder/;
    }

This works for the login because it doesn't get redirected to /, but correctly to /my_folder/

Plugins support

Hi,
Can you modify the index.php to scan a ./plugin/ directory and enable all plugins in it? This way it can be mounted from the host, and anyone could use desired plugins.
If you work with Magento databases, the table filter plugin is a must.

fastcgi & container

Hello, how to make it work with the container docker-letsencrypt in fastcgi please I can not do it

How to define a new port?

My database is postgresql and the port is 9999.
Login Adminer4.7.7 report such error: "SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "postgresql" (120.240.95.33) and accepting TCP/IP connections on port 5432?".
I want to define the port:9999 in docker-compose.yml, how to do?

Allow configuring the DB host via an environment variable

Since the links key is deprecated in docker-compose and not present in docker stack deploy, there is no way to reference my db host container which is not named db. Please allow setting database host via an environment variable

Executable file not found

Hi !
I got a problem with actual Dockerfile.
I got this error when I docker compose :

ERROR: for adminer Cannot start service adminer: OCI runtime create failed: container_linux.go:345: starting container process caused "exec: "entrypoint.sh": executable file not found in $PATH": unknown

I have to fix the Dockerfile with this line :

RUN chmod +x /usr/local/bin/entrypoint.sh

Is this normal that actual Dockerfile doesn't set a chmod +x ?

error on docker run and docker-compose will not start

Hello all,
Please help us
I see that many others are having this issue with adminer
https://stackoverflow.com/questions/53078135/php-network-getaddresses-getaddrinfo-failed-error-in-dockers-adminer

docker run --publish 8085:8080 adminer

Warning: Unknown: php_network_getaddresses: getaddrinfo failed: Name does not resolve in Unknown on line 0

[Thu Apr 2 09:09:44 2020] Failed to listen on :::8080 (reason: php_network_getaddresses: getaddrinfo failed: Name does not resolve)

any idea why adminer container will not run??

thanks

ARM build issue introduced between 4.7.7 and 4.7.8

I'm unable to get adminer to load to the login screen for releases 4.7.8+ on a raspberry pi (ARM)

There's no error message, the browser just keeps trying to load. docker stats has the container maxing the CPU out at 100%.

To reproduce:
Use the docker-compose recommended by postgres (https://hub.docker.com/_/postgres) and visit <raspi-IP>:8080

# Use postgres/example user/password credentials
version: '3.1'

services:

  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_PASSWORD: example

  adminer:
     # image: adminer:4.7.6  # Works
    # image: adminer:4.7.7  # Works
    image: adminer:4.7.8  # FAILS
    restart: always
    ports:
      - 8080:8080

I can reproduce in Firefox, Chrome and Safari and via curl on the (raspi) localhost and remotely.

This does not seem to impact x86 releases.

Update to 4.7.0

And potentially automatically publish updates.

[php] variable via entrypoint/env

It would be nice to be able to change your default php setting (https://github.com/TimWolla/docker-adminer/blob/master/4/fastcgi/Dockerfile#L3-L7)

You should be able to handle them in the entrypoint by changing the /usr/local/etc/php/conf.d/0-upload_large_dumps.ini or put an example of how to to provide the param via the php cli php "$@

Connect to elastic search db

I have something like this:

    adminer:
        image: adminer
        ports:
          - ${ADMINER_PORT}:8080

    elasticsearch:
        build: docker/dockerfile/elasticsearch
        ports:
            - ${ELASTICSEARCH_PORT}:9200
        volumes:
            - elasticsearch_data:/usr/share/elasticsearch/data
            - elasticsearch_config:/usr/share/elasticsearch/config

and plus some mysql container. Everthing is fine, I can easily connect to mysql container, but I can't figure out how to explore elastic search db - does it need any special docker coniguration?

Multi Language Support?

Is this English-only version?
Can support multiple languages?

Theme error NGINX FastCGI

I'm having a problem setting the theme with NGINX and FastCGI... Adminer works totally fine, but adminer.css is not loading at all.

Here is my docker compose

version: "3.7"

services:
  service-postgresql:
    container_name: container-postgresql
    image: postgres:latest
    ports:
      - "5432:5432"
    environment:
      - POSTGRES_PASSWORD=my-pass
      - POSTGRES_USER=my-user
      - POSTGRES_DB=my-db

service-adminer:
    container_name: container-adminer
    image: adminer:fastcgi
    depends_on:
      - service-postgresql
    environment:
      - ADMINER_DEFAULT_SERVER=service-postgresql
      - ADMINER_DESIGN=galkaev

service-nginx:
    container_name: container-nginx
    image: nginx
    depends_on:
      - service-adminer
    ports:
      - "80:80"
    volumes:
      - /my/path/conf.d:/etc/nginx/conf.d:ro

And here is my nginx server conf

server {
    listen       80;
    server_name  localhost;

    location = /favicon.ico {
        log_not_found off;
        access_log off;
    }

    location = /robots.txt {
        allow all;
        log_not_found off;
        access_log off;
    }

    location / {
        # This is cool because no php is touched for static content.
        # include the "?$args" part so non-default permalinks doesn't break when using query string
        try_files $uri $uri/ /index.php?$args;
    }

    location ~ \.php$ {
        #NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini
        include fastcgi_params;
        fastcgi_intercept_errors on;
        fastcgi_param  SCRIPT_FILENAME /var/www/html/index.php;
        fastcgi_pass service-adminer:9000;
    }

    location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ {
        expires max;
        log_not_found off;
    }
}

Somebody can point me what I'm doing wrong?

Many thanks in advance.

How to add sqlserver extension ?

I try to add sql server extension.
I see that php-mssql (mssql_connect) on php5 and was removed in php7

So how can I do it on php7 ?

Regards

Add Ability To Change Ports

Please add the ability to change the listen ports on this image.

This could be done using environment variables i.e. WEB_PORT=12345 FASTCGI_PORT=67890

This would allow for easier spin-up and proxying of Adminer containers and would minimise port clashes.

Thanks!

Container is in an endless restart-loop

Hey, I just wanted to use adminer in a simple docker-compose.yml stack:

version: '3.7'

services:
    adminer_application:
        container_name: example-adminer
        hostname: adminer.application
        image: adminer:4
        ports:
            - 8080:8080
        restart: unless-stopped
    mysql_dbms:

        command: --default-authentication-plugin=mysql_native_password
        container_name: example-mysql
        environment:
            MYSQL_USER: foo
            MYSQL_PASSWORD: bar
            MYSQL_ROOT_PASSWORD: bar
        hostname: mysql.database
        image: mysql:8
        restart: unless-stopped
        volumes:
            - ./../../data/mysql:/var/lib/mysql

While the mysql container is running great, the adminer container is in an endless restart loop.

When I comment out the "restart: unless-stopped" and try to start it with:

docker container start -a example-adminer

I get this output:

[Wed Sep 19 09:57:41 2018] Failed to listen on :::8080 (reason: php_network_getaddresses: getaddrinfo failed: Name does not resolve)
<br />
<b>Warning</b>:  Unknown: php_network_getaddresses: getaddrinfo failed: Name does not resolve in <b>Unknown</b> on line <b>0</b><br />

Same output is produced when I start the container with:

docker container start -i example-adminer

sudo netstat -tulp | grep -c 8080

Returns "0".

What am I doing wrong?
I've also tried it with no container_name or no hostname definition in the docker-compose.yml.

Here are some specs about my environemnt:

#docker --version
Docker version 18.06.1-ce, build e68fc7a21
#docker-compose --version
docker-compose version 1.22.0, build unknown
#uname -a
Linux <hostname> 4.14.70-1-lts #1 SMP Sat Sep 15 16:47:42 CEST 2018 x86_64 GNU/Linux
#cat /etc/issue
Arch Linux \r (\l)

Thanks in advance and especially for your work so far,
Stev

Improve slow shutdown

I found, that the image has quite a long shutdown times for me of > 10 seconds. It's probably a similar issue as described here: clue/docker-adminer#17:

Current form of CMD does not passes signals to the supervisord and container can not be stopped via standard docker stop command. After a timeout, container is killed by Docker.

I know that supervisord is not used here, but maybe the same problem exists for php -S.

How to properly connect css in fastcgi mode?

I use adminer:fastcgi with caddy, both in docker containers and can't figure out how to properly connect adminer.css. The only way I managed to get it working is via volume but in that case the contents of the volume is not updated automatically when the adminer container is upgraded. What is the best practice to achieve this?

Here's my Caddyfile snippet:

redir /adminer /adminer/

route /adminer/* {
    uri strip_prefix /adminer

    php_fastcgi adminer:9000 {
        root /var/www/html
    }
}

Trying to solve the problem using volume I did like this:

Caddyfile:

redir /adminer /adminer/

  route /adminer/* {
      uri strip_prefix /adminer
      root * /adminer

      file_server @static

      php_fastcgi adminer:9000 {
          root /var/www/html
      }
  }

docker-compose.yml:

volumes:

  adminer:

services:

  caddy:
    image: caddy:2.3.0
...
    volumes:
      - adminer:/adminer:ro

 adminer:
    image: adminer:fastcgi
...
    volumes:
      - adminer:/var/www/html

Thanks in advance!

Reduce logging verbosity

Is there a way to configure adminer to not produce these constant log entries? Right now it's very verbose and makes it difficult to find relevant logs from other services

[::ffff:10.138.0.35]:36682 Accepted
[::ffff:10.138.0.35]:36682 [200]: GET /
[::ffff:10.138.0.35]:36682 Closing

Update Docker image with bugfix in Tables Filter plugin

Hi,

Can you update the Docker image anytime soon?
The image is built from the master branch of adminer, and sometimes there are not fixed bugs in it.
4 days ago a bug was fixed Tables Filter plugin vrana/adminer@2dcad1f and I use the plugin on daily basis.

Thanks.

adminer:fastcgi don't working in my stack with php-fpm

I have docker-compose for custom webserver with mariadb, nginx, php:7.4-fpm, adminer and some other nextra containers.

When I have setup like below everything works well and adminer is accessible in browser http://localhost:8080

version: '3.5'

services:

  mariadb:  
    image: mariadb
    .... some other settings ...
    networks:
      - internal

  adminer:
    image: adminer
    container_name: adminer
    depends_on:
      - mariadb
    environment:
      ADMINER_DEFAULT_SERVER: mariadb
      TZ: ${WORKSPACE_TIMEZONE}
    ports:
      - 8080:8080
    restart: always
    networks:
      - internal

  nginx:
    container_name: nginx
    build:
      context: ./nginx
    .... some other settings ...
    networks:
      - internal

  php:  
    container_name: php
    build:
      context: ./php  # FROM php:7.4-fpm
      args:
        PHPVERSION: "7.4"        # with php-7.4 compatible xdebug-2.9.1
        XDEBUGVERSION: "2.9.1"   # with php-7.3 compatible xdebug-2.7.1
    working_dir: /var/www
    environment:
      XDEBUG_CONFIG: "remote_host=192.168.220.1 remote_enable=1"
      PHP_IDE_CONFIG: "serverName=Docker"
      TZ: ${WORKSPACE_TIMEZONE}
    volumes:
      - ./.ssh:/home/www-data/.ssh
      - ${PROJECTS}:/var/www
    restart: always
    networks:
      - internal

networks:
  internal:
    name: webserver
    driver: bridge
    ipam:
      driver: default
      config:
        - subnet: 192.168.220.0/28

But when I change adminer to adminer:fastcgi then in http://localhost:9000 I have nothing

    image: adminer:fastcgi
    ports:
      - 9000:9000

Add more environment variables

Is it possible to set system and maybe also database using environment?
Defining server is very useful, but I use Postgres and it always defaults to MySQL.

Make max. upload size configurable via env variable

The current upload restriction of 2 MB is pretty low. I suggest to introduce another environment variable to configure the max. upload filesize.

I know that we can use the workaround shown in #17. But this is such an essential setting that you should not have to create a custom config file to change it. Users of this image don't want to mess around with PHP settings - all they want is a quick admin panel for their database.

build actual Dockerfile (4.3.0)

I tried to build this the new Adminer version (4.3.1) based on this official Dockerfile (to have the multi languages version), but it failed at line 21 "COPY index.php ." : lstat index.php: no such file or directory
(I changed ENV variables of version and sha256 checksum but I couldn't reach that part yet)
Is there a problem with this actual Dockerfile ? Or i missed something ?

Best regards.

[EDIT] I missed something, i found... (git clone -----)

Base php:7.4 not have mongodb plugin

I use root exec container shell, docker exec -it adminer -u root sh
and pecl install mongodb then it say Cannot find autoconf.
this image delete apt-get, how I install mongodb.so support.

Can you add pepa-linha-dark to the container?

Looks like it's missing within the container itself:

So, instead of just being able to do a:

    environment:
      - ADMINER_DESIGN="pepa-linha-dark"

We have to manually copy the adminer.css to the container, which may get lost(?) of container updates, or have to create a mount just for that .css file. It'd be a lot easier to just be able to use the environment variable. =)

None of the supported PHP extensions (mongo) are available.

how does one add PHP extensions when uding the official docker image?
tried to use mongodb but got this error

None of the supported PHP extensions (mongo) are available.

Thanks

Unable to load the login-password-less plugin

Hello !

We are trying to extend your image because we need to use the login-password-less plugin and it needs a custom file for the mandatory parameter.

Here is my Dockerfile :

FROM adminer:4.7.1-standalone
USER root
COPY login-password-less.php /var/www/html/plugins-enabled/login-password-less.php
USER adminer

And the content of login-password-less.php file :

<?php
require_once('plugins/login-password-less.php');

/** Set allowed password
	* @param string result of password_hash
	*/
return new AdminerLoginPasswordLess(
	$password_hash = "notthatvalue"
);

I set the env var ADMINER_PLUGINS to "login-password-less" but I still have this error on startup :

Unable to load plugin file "login-password-less", because it has required parameters: password_hash
Create a file "/var/www/html/plugins-enabled/login-password-less.php" with the following contents to load the plugin:

<?php
require_once('plugins/login-password-less.php');

/** Set allowed password
	* @param string result of password_hash
	*/
return new AdminerLoginPasswordLess(
	$password_hash = ???
);

Am I missing something ?

Include adminer designs

It would be great if the available adminer designs could be included into the image and activated by some environment flag, e.g. ADMINER_DESIGN='nicu'.

Of course we could also map our adminer.css into the image at runtime - but that's another step required when all we need is a quick admin interface for our DB.

Error when restarting a container with ADMINER_DESIGN set

When trying to restart a container with ADMINER_DESIGN set there's an error:

ln: ./adminer.css: File exists

Problem setting theme

Heyoo,

So I'm trying to set the theme to pepa-linha, and it just won't take.

Whether I create container with the environment var like this:

docker run -d --link mysql:db -p 90210:8080 --network=my-db -e ADMINER_DESIGN="pepa-linha" -e "ADMINER_PLUGINS=frames" --name adminer adminer

or try to brute force it by starting the container with the adminer.css file stored on the host machine like this:

docker run -d --link mysql:db -p 90210:8080 --network=my-db -e "ADMINER_PLUGINS=frames" --name adminer -v "/f/Sites/Web/.config/Adminer/adminer.css:/var/www/html/adminer.css" adminer

The logs just show this when I run the container:

/adminer/adminer.css - No such file or directory

Any ideas? TIA

None of the supported PHP extensions (mongo, mongodb) are available.

The mongo PHP module is not installed and the container runs as a non-root user so it's not possible to install it.

The WebUI provides a drop-down for mongo but the container image does not include the capability.

image: adminer:4.7.7-standalone

Default language

There is a way to select a different default language than English?

I searched here:
https://www.adminer.org/plugins/

But didn't find one to do that... there is a plugin or some workaround?

Thanks in advance!

how to connect sqlite db with adminer(docker version)

Is there a tutorial?

Cannot enter into container with bash

When I try docker exec <some_adminer_container> bash_, it prints:

OCI runtime exec failed: exec failed: container_linux.go:345: starting container process caused "exec: "bash_": executable file not found in $PATH": unknown

Boostrap bundled as a theme

Is there a possibility to add https://github.com/natanfelles/adminer-bootstrap-like not as an add-on but as a design option (or event as the default)?

can't connect fastcgi to nginx container

Hello,
I am using a docker composer file to use adminer fastcgi by using a nginx image but can't seem to figure it out as to why it is not working. Here is my docker composer file

#Use root/example as user/password credentials
version: '2.2'  
  web:
    image: nginx:latest
    ports:
        - "8000:80"
    volumes:
        # - ./code:/code
        - ./site.conf:/etc/nginx/conf.d/site.conf
    links:
        - adminer
  adminer:
     image: adminer:fastcgi
     ports:
        - 9000:9000

here is my site.conf file

server {
    index index.php;
    server_name 192.168.99.100;
    error_log  /var/log/nginx/error.log;
    access_log /var/log/nginx/access.log;

    location ~ \.php$ {
        try_files $uri =404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass adminer:9000;
        fastcgi_index index.php;
        include fastcgi_params;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        fastcgi_param PATH_INFO $fastcgi_path_info;
    }
}

what am i doing wrong?

adminer in docker - suddenly no connection possible

Hi,

I was using the adminer docker image on my raspberry pi for quite some time without any problem. At some point it was not possible to use access the adminer pagte anymore. It just loads and loads without coming to and result. When I restart the container I can load the page once, but it is stuck in the loading loop again immediatly after. It looks like, adminer is closing the connection after the POST...

In the docker log it looks like this:

[Sat Jul 11 15:59:36 2071] PHP 7.4.14 Development Server (http://[::]:8080) started
[Sat Jul 11 15:58:32 2071] [::ffff:192.168.178.30]:53227 Accepted
[Sat Jul 11 15:47:36 2071] [::ffff:192.168.178.30]:53227 [403]: GET /?server=mariadb&username=fhem&db=fhem&sql=
[Sat Jul 11 15:56:56 2071] [::ffff:192.168.178.30]:53227 Closing
[Sat Jul 11 15:58:32 2071] [::ffff:192.168.178.30]:53228 Accepted
[Sat Jul 11 15:58:32 2071] [::ffff:192.168.178.30]:53229 Accepted
[Sat Jul 11 15:47:36 2071] [::ffff:192.168.178.30]:53228 [304]: GET /?file=default.css&version=4.7.8
[Sat Jul 11 15:56:56 2071] [::ffff:192.168.178.30]:53228 Closing
[Sat Jul 11 15:58:32 2071] [::ffff:192.168.178.30]:53230 Accepted
[Sat Jul 11 15:47:36 2071] [::ffff:192.168.178.30]:53229 [304]: GET /?file=functions.js&version=4.7.8
[Sat Jul 11 15:56:56 2071] [::ffff:192.168.178.30]:53229 Closing
[Sat Jul 11 15:58:32 2071] [::ffff:192.168.178.30]:53226 Accepted
[Sat Jul 11 15:55:36 2071] [::ffff:192.168.178.30]:53230 [200]: GET /adminer.css?v=-416286184
[Sat Jul 11 15:58:08 2071] [::ffff:192.168.178.30]:53230 Closing
[Sat Jul 11 15:47:36 2071] [::ffff:192.168.178.30]:53226 [302]: POST /?server=mariadb&username=fhem&db=fhem&sql=
[Sat Jul 11 15:56:56 2071] [::ffff:192.168.178.30]:53226 Closing
[Sat Jul 11 15:58:32 2071] [::ffff:192.168.178.30]:53231 Accepted

This is how i deploy the adminer container from a docker-compose

version: '3'

services:
    adminer:
        image: adminer:latest
        container_name: adminer
        labels:
            -  com.centurylinklabs.watchtower.enable=true
        restart: unless-stopped
        ports:
            - 8082:8080
        networks:
            - fhem-network
        environment:
            - ADMINER_DESIGN=rmsoft
            - ADMINER_DEFAULT_SERVER=fhem

I also tested to deploy a docker-compose with only adminer. In this scenario I observe the same behavior.

Any ideas on this?

All the best

increase → Unable to upload a file. Maximum allowed file size is 2MB.

Solved!

I user this script inside Dockerfile:

# Store PHP Configs at /usr/local/etc/php/conf.d
RUN echo "upload_max_filesize = 500M" >> /usr/local/etc/php/conf.d/upload_large_dumps.ini \
    && echo "post_max_size = 500M"       >> /usr/local/etc/php/conf.d/upload_large_dumps.ini \
    && echo "memory_limit = -1"           >> /usr/local/etc/php/conf.d/upload_large_dumps.ini \
    && echo "max_execution_time = 0"      >> /usr/local/etc/php/conf.d/upload_large_dumps.ini

Regards,

Pass different port to adminer

Hello folks,

Thanks for a very nice product. Is there any possibility to define custom port for adminer? I'm using docker compose and internal port 8080 is already bound:

...microservice-catalog>docker-compose up
Creating network "microservice-catalog_default" with the default driver
Creating microservice-catalog_adminer_1 ...
Creating microservice-catalog_microcatalog_1 ...
Creating microservice-catalog_microcatalog_1 ... error
WARNING: Host is already in use by another container
Creating microservice-catalog_adminer_1      ... done
ERROR: for microservice-catalog_microcatalog_1  Cannot start service microcatalog: driver failed programming external connectivity on endpoint microservice-catalog_microcatalog_1 (ef2bdfa5426b8bb7f44Creating microservice-catalog_db_1           ... done
ERROR: for microcatalog  Cannot start service microcatalog: driver failed programming external connectivity on endpoint microservice-catalog_microcatalog_1 (ef2bdfa5426b8bb7f44af95f6eb47e91753035784e5346c2c3e18149b064de34): Bind for 0.0.0.0:8080 failed: port is already allocated
ERROR: Encountered errors while bringing up the project.

You can reproduce it via

version: '3.1'
services:
  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_PASSWORD: kEt#uR6M
  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:9080
  microcatalog:
    image: tillias/microcatalog
    restart: always
    environment:
      DB_HOST: db
      DB_PORT: 5432
      DB_NAME: postgres
      DB_PASSWORD: kEt#uR6M
      DB_USER: postgres
      CSP_IMAGE_SRC: '*'
    ports:
      - 8080:8080

CVE-2020-35186

Someone filed CVE-2020-35186 against your docker image. After looking at your dockerfile I do not think it is vulnerable and should be disputed.

Here is a blog I wrote on the subject.

MS SQL support instructions?

Hello
I could not make it work against MS SQL...
What I've tried was to update the module installation instructions as follows:

RUN     set -x \
&&      apk add --no-cache --virtual .build-deps \
        postgresql-dev \
        sqlite-dev \
        freetds-dev \
&&      docker-php-ext-install pdo_mysql pdo_pgsql pdo_sqlite pdo_dblib  \
&&      apk del .build-deps

The Docker build works fine but then when I run php, it complains with the following:

/usr/local/etc/php/conf.d $ php --ini
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_dblib.so' (tried: /usr/local/lib/php/extensions/no-debug-non-zts-20170718/pdo_dblib.so (Error loading shared library libsybdb.so.5: No such file or directory (needed by /usr/local/lib/php/extensions/no-debug-non-zts-20170718/pdo_dblib.so)), /usr/local/lib/php/extensions/no-debug-non-zts-20170718/pdo_dblib.so.so (Error loading shared library /usr/local/lib/php/extensions/no-debug-non-zts-20170718/pdo_dblib.so.so: No such file or directory)) in Unknown on line 0

I've tried also installing php-mssql with apk but this fails at install time with:

+ apk add --no-cache --virtual .build-deps postgresql-dev sqlite-dev freetds-dev php-mssql
fetch http://dl-cdn.alpinelinux.org/alpine/v3.6/main/x86_64/APKINDEX.tar.gz
fetch http://dl-cdn.alpinelinux.org/alpine/v3.6/community/x86_64/APKINDEX.tar.gz
ERROR: unsatisfiable constraints:
  .build-deps-0:
    masked in: cache
    satisfies: world[.build-deps]
  php-mssql (missing):
    required by:

I'm really not familiar with php so I'm not able to troubleshoot this properly (my objective using a ready-made Docker image was precisely to avoid fiddling too much with php :).

Can you give some directions?

Many thanks!

Preconfigured authoriziation

A nice feature would be if it was possible to pass server, username, password and database as parameters to the docker image.

In that way it would be very convenient to bundle adminer in a development stack docker-compose and provide a one-click access to the database.

I'm thinking that docker-compose.yml could look something like this:

adminer:
    image: adminer
    ports: 8080:8080
    environment:
    - ADMINER_SERVER=db
    - ADMINER_USER=root
    - ADMINER_PASSWORD=secret
    - ADMINER_DATABASE=mydatabase

This would make adminer either 1) just pre-fill the values in the form, or 2) auto-login.

I guess this request would also require changes in adminer itself though.

adminer does not start when IPv6 is not supported

when running adminer on a host that has IPv6 disabled, the container fails to start with

Failed to listen on :::8080 (reason: php_network_getaddresses: getaddrinfo failed: Name does not resolve)
Unknown: php_network_getaddresses: getaddrinfo failed: Name does not resolve in <b>Unknown</b> on line <b>0</b><br />

Expected: The container must start and listen to IPv4 0.0.0.0:8080

How to limit systems

I would like to run adminer as a container in a pod. So as the env is controlled I know the only system which is needed is e.g. PostgreSQL and the server is localhost.

would be great if we could filter out the systems which are not needed in login page and set a readonly value for Server.

Wdyt? Is this possible to support these cases?

How to configure a sub-URL ?

Hi,
Is it possible to use a sub-url path instead of only "/" root URL ?
I would like to usr a sub-URL . Example : https://mydomain/adminer/ instead of https://myadminer/

Regards

New version

Hey man, can you please bump this to 4.7.6?

Thanks!

timwolla / docker-adminer Goto Github PK

docker-adminer's Introduction

Maintained by: Tim Düsterhus (of the Docker Community)

See a change merged here that doesn't show up on Docker Hub yet?

docker-adminer's People

Contributors

Stargazers

Watchers

Forkers

docker-adminer's Issues

Recommend Projects

Recommend Topics

Recommend Org