clue/docker-adminer

Adminer docker image, a full-featured database management tool for the web

Hi there 👋

What have I been up to recently?

I've been working on some 100+ projects that total at over 100 Mio downloads. Here's an excerpt of some of my recent projects:

• Framework X
• ReactPHP
• GraPHP
• LeProxy
• and many more…

Sponsor my work

If you use any of my packages, please consider sponsoring me! Do you sponsor me on GitHub? Thank you for supporting sustainable open-source, you're awesome! ❤️ Enjoy exclusive early access to my projects! 🎉

Let's get in touch

Working with open source is both my passion and what I do professionally.

• Do you use any of my packages? Awesome! Say hello and send a message to @another_clue on Twitter.

• Looking for community support? Open a discussion in the respective repository, I'm happy to help!

• Schedule an appointment if you're looking for professional support.

Rock on 🤘

docker-adminer's Issues

extensive number of session files

Hi, I would like to report an issue with your docker image. PHP is creating extensive number of session files. Looks like it creates ~1 file per second, this goes to GBs and hundreds of thousands of files created which are not being cleaned up. I'm using your image without any modification. Adminer was installed through rancher UI on rancher OS through community catalog /env/1a5/catalog/community:adminer?catalogId=community.

root@xxx:/var/lib/docker/overlay/1598559164d0ed0e481fa50610f46631b1766aa95cad767808666948294076fb/upper/var/lib/php5# ls -la
total 524
drwx-wx-wt 2 root     root     4096 Mar 16 17:19 .
drwxr-xr-x 4 root     root     4096 Mar 16 17:17 ..
-rw------- 1 www-data www-data 8922 Mar 16 17:18 sess_182h1flv6ej7mb854gut6h1ho0
-rw------- 1 www-data www-data 8921 Mar 16 17:17 sess_193sm4oaq7o9497ki8t9c19dq7
...

root@xxx:/var/lib/docker/overlay/1598559164d0ed0e481fa50610f46631b1766aa95cad767808666948294076fb/upper/var/lib/php5# cat sess_pmulh3lrk7ur7bs27r8ivvfp16
translations_version|i:944611216;translations|a:284:{i:0;s:13:"Are you sure?";i:1;s:6:"%.3f s";i:2;s:24:"Unable to upload a file.";i:3;s:33:"Maximum allowed file size is %sB.";i:4;s:20:"File does not exist.";i:5;s:1:",";i:6;s:10:"0123456789";i:7;s:5:"empty";i:8;s:8:"original";i:9;s:10:"No tables.";i:10;s:4:"Edit";i:11;s:6:"Insert";i:12;s:8:"No rows.";i:13;s:44:"You have no privileges to update this table.";i:14;s:4:"Save";i:15;s:22:"Save and continue edit";i:16;s:20:"Save and insert next";i:17;s:6:"Saving";i:18;s:6:"Delete";i:19;s:8:"Language";i:20;s:3:"Use";i:21;s:36:"Please use one of the extensions %s.";i:22;s:12:"File exists.";i:23;s:7:"Strings";i:24;s:10:"User types";i:25;s:7:"Numbers";i:26;s:13:"Date and time";i:27;s:6:"Binary";i:28;s:7:"Network";i:29;s:8:"Geometry";i:30;s:5:"Lists";i:31;s:6:"System";i:32;s:6:"Server";i:33;s:8:"Username";i:34;s:8:"Password";i:35;s:8:"Database";i:36;s:5:"Login";i:37;s:15:"Permanent login";i:38;s:88:"<a href="https://www.adminer.org/en/extension/"%s>Implement</a> %s method to use SQLite.";i:39;s:11:"Select data";i:40;s:14:"Show structure";i:41;s:10:"Alter view";i:42;s:11:"Alter table";i:43;s:8:"New item";i:44;s:8:"Warnings";i:45;a:2:{i:0;s:7:"%d byte";i:1;s:8:"%d bytes";}i:46;s:6:"Column";i:47;s:4:"Type";i:48;s:7:"Comment";i:49;s:14:"Auto Increment";i:50;s:13:"Default value";i:51;s:6:"Select";i:52;s:9:"Functions";i:53;s:11:"Aggregation";i:54;s:6:"Search";i:55;s:8:"anywhere";i:56;s:4:"Sort";i:57;s:10:"descending";i:58;s:5:"Limit";i:59;s:11:"Text length";i:60;s:6:"Action";i:61;s:15:"Full table scan";i:62;s:11:"SQL command";i:63;s:4:"open";i:64;s:4:"save";i:65;s:14:"Alter database";i:66;s:12:"Alter schema";i:67;s:13:"Create schema";i:68;s:15:"Database schema";i:69;s:10:"Privileges";i:70;s:6:"Import";i:71;s:6:"Export";i:72;s:12:"Create table";i:73;s:8:"database";i:74;s:2:"DB";i:75;s:6:"Schema";i:76;s:6:"select";i:77;s:3:"ltr";i:78;s:16:"You are offline.";i:79;s:6:"Logout";i:80;a:2:{i:0;s:53:"Too many unsuccessful logins, try again in %d minute.";i:1;s:54:"Too many unsuccessful logins, try again in %d minutes.";}i:81;s:40:"Invalid CSRF token. Send the form again.";i:82;s:18:"Logout successful.";i:83;s:61:"Thanks for using Adminer, consider <a href="%s">donating</a>.";i:84;s:36:"Session expired, please login again.";i:85;s:120:"Master password expired. <a href="https://www.adminer.org/en/extension/"%s>Implement</a> %s method to make it permanent.";i:86;s:32:"Session support must be enabled.";i:87;s:78:"The action will be performed after successful login with the same credentials.";i:88;s:12:"No extension";i:89;s:56:"None of the supported PHP extensions (%s) are available.";i:90;s:46:"Connecting to privileged ports is not allowed.";i:91;s:20:"Invalid credentials.";i:92;s:62:"Maximum number of allowed fields exceeded. Please increase %s.";i:93;s:67:"If you did not send this request from Adminer then close this page.";i:94;s:78:"Too big POST data. Reduce the data or increase the %s configuration directive.";i:95;s:64:"You can upload a big SQL file via FTP and import it from server.";i:96;s:12:"Foreign keys";i:97;s:9:"collation";i:98;s:9:"ON UPDATE";i:99;s:9:"ON DELETE";i:100;s:11:"Column name";i:101;s:14:"Parameter name";i:102;s:6:"Length";i:103;s:7:"Options";i:104;s:8:"Add next";i:105;s:7:"Move up";i:106;s:9:"Move down";i:107;s:6:"Remove";i:108;s:17:"Invalid database.";i:109;s:28:"Databases have been dropped.";i:110;s:15:"Select database";i:111;s:15:"Create database";i:112;s:12:"Process list";i:113;s:9:"Variables";i:114;s:6:"Status";i:115;s:39:"%s version: %s through PHP extension %s";i:116;s:13:"Logged as: %s";i:117;s:7:"Refresh";i:118;s:9:"Collation";i:119;s:6:"Tables";i:120;s:4:"Size";i:121;s:7:"Compute";i:122;s:8:"Selected";i:123;s:4:"Drop";i:124;s:15:"Invalid schema.";i:125;s:17:"Materialized view";i:126;s:4:"View";i:127;s:5:"Table";i:128;s:7:"Indexes";i:129;s:13:"Alter indexes";i:130;s:6:"Source";i:131;s:6:"Target";i:132;s:5:"Alter";i:133;s:15:"Add foreign key";i:134;s:8:"Triggers";i:135;s:11:"Add trigger";i:136;s:14:"Permanent link";i:137;s:6:"Output";i:138;s:6:"Format";i:139;s:8:"Routines";i:140;s:6:"Events";i:141;s:4:"Data";i:142;s:11:"Create user";i:143;s:33:"ATTACH queries are not supported.";i:144;s:14:"Error in query";i:145;s:5:"%d / ";i:146;a:2:{i:0;s:6:"%d row";i:1;s:7:"%d rows";}i:147;a:2:{i:0;s:35:"Query executed OK, %d row affected.";i:1;s:36:"Query executed OK, %d rows affected.";}i:148;s:23:"No commands to execute.";i:149;a:2:{i:0;s:21:"%d query executed OK.";i:1;s:23:"%d queries executed OK.";}i:150;s:7:"Execute";i:151;s:10:"Limit rows";i:152;s:11:"File upload";i:153;s:26:"File uploads are disabled.";i:154;s:11:"From server";i:155;s:17:"Webserver file %s";i:156;s:8:"Run file";i:157;s:13:"Stop on error";i:158;s:16:"Show only errors";i:159;s:7:"History";i:160;s:5:"Clear";i:161;s:8:"Edit all";i:162;s:22:"Item has been deleted.";i:163;s:22:"Item has been updated.";i:164;s:25:"Item%s has been inserted.";i:165;s:23:"Table has been dropped.";i:166;s:23:"Table has been altered.";i:167;s:23:"Table has been created.";i:168;s:10:"Table name";i:169;s:6:"engine";i:170;s:14:"Default values";i:171;s:8:"Drop %s?";i:172;s:12:"Partition by";i:173;s:10:"Partitions";i:174;s:14:"Partition name";i:175;s:6:"Values";i:176;s:26:"Indexes have been altered.";i:177;s:10:"Index Type";i:178;s:15:"Column (length)";i:179;s:4:"Name";i:180;s:26:"Database has been dropped.";i:181;s:26:"Database has been renamed.";i:182;s:26:"Database has been created.";i:183;s:26:"Database has been altered.";i:184;s:24:"Schema has been dropped.";i:185;s:24:"Schema has been created.";i:186;s:24:"Schema has been altered.";i:187;s:4:"Call";i:188;a:2:{i:0;s:41:"Routine has been called, %d row affected.";i:1;s:42:"Routine has been called, %d rows affected.";}i:189;s:29:"Foreign key has been dropped.";i:190;s:29:"Foreign key has been altered.";i:191;s:29:"Foreign key has been created.";i:192;s:132:"Source and target columns must have the same data type, there must be an index on the target columns and referenced data must exist.";i:193;s:11:"Foreign key";i:194;s:12:"Target table";i:195;s:6:"Change";i:196;s:10:"Add column";i:197;s:22:"View has been altered.";i:198;s:22:"View has been dropped.";i:199;s:22:"View has been created.";i:200;s:11:"Create view";i:201;s:23:"Event has been dropped.";i:202;s:23:"Event has been altered.";i:203;s:23:"Event has been created.";i:204;s:11:"Alter event";i:205;s:12:"Create event";i:206;s:5:"Start";i:207;s:3:"End";i:208;s:5:"Every";i:209;s:22:"On completion preserve";i:210;s:25:"Routine has been dropped.";i:211;s:25:"Routine has been altered.";i:212;s:25:"Routine has been created.";i:213;s:14:"Alter function";i:214;s:15:"Alter procedure";i:215;s:15:"Create function";i:216;s:16:"Create procedure";i:217;s:11:"Return type";i:218;s:26:"Sequence has been dropped.";i:219;s:26:"Sequence has been created.";i:220;s:26:"Sequence has been altered.";i:221;s:14:"Alter sequence";i:222;s:15:"Create sequence";i:223;s:22:"Type has been dropped.";i:224;s:22:"Type has been created.";i:225;s:10:"Alter type";i:226;s:11:"Create type";i:227;s:25:"Trigger has been dropped.";i:228;s:25:"Trigger has been altered.";i:229;s:25:"Trigger has been created.";i:230;s:13:"Alter trigger";i:231;s:14:"Create trigger";i:232;s:4:"Time";i:233;s:5:"Event";i:234;s:22:"User has been dropped.";i:235;s:22:"User has been altered.";i:236;s:22:"User has been created.";i:237;s:6:"Hashed";i:238;s:7:"Routine";i:239;s:5:"Grant";i:240;s:6:"Revoke";i:241;a:2:{i:0;s:27:"%d process has been killed.";i:1;s:30:"%d processes have been killed.";}i:242;s:5:"Clone";i:243;s:11:"%d in total";i:244;s:4:"Kill";i:245;a:2:{i:0;s:26:"%d item has been affected.";i:1;s:28:"%d items have been affected.";}i:246;s:35:"Ctrl+click on a value to modify it.";i:247;s:31:"File must be in UTF-8 encoding.";i:248;a:2:{i:0;s:25:"%d row has been imported.";i:1;s:27:"%d rows have been imported.";}i:249;s:26:"Unable to select the table";i:250;s:6:"Modify";i:251;s:9:"Relations";i:252;s:4:"edit";i:253;s:35:"Use edit link to modify this value.";i:254;s:14:"Load more data";i:255;s:7:"Loading";i:256;s:4:"Page";i:257;s:4:"last";i:258;s:12:"Whole result";i:259;s:27:"Tables have been truncated.";i:260;s:23:"Tables have been moved.";i:261;s:24:"Tables have been copied.";i:262;s:25:"Tables have been dropped.";i:263;s:27:"Tables have been optimized.";i:264;s:16:"Tables and views";i:265;s:21:"Search data in tables";i:266;s:6:"Engine";i:267;s:11:"Data Length";i:268;s:12:"Index Length";i:269;s:9:"Data Free";i:270;s:4:"Rows";i:271;s:6:"Vacuum";i:272;s:8:"Optimize";i:273;s:7:"Analyze";i:274;s:5:"Check";i:275;s:6:"Repair";i:276;s:8:"Truncate";i:277;s:22:"Move to other database";i:278;s:4:"Move";i:279;s:4:"Copy";i:280;s:9:"Sequences";i:281;s:8:"Schedule";i:282;s:13:"At given time";i:283;a:2:{i:0;s:24:"%d e-mail has been sent.";i:1;s:26:"%d e-mails have been sent.";}}token|i:113519;dbs|a:1:{s:6:"server";a:1:{s:0:"";a:1:{s:0:"";N;}}}

Tagged releases + update

Version of the docker image

Is it possible for you to tag the docker image ? The only version is latest.

Thanks,

Migrate to official php image

I see that instead of an official PHP base image this project uses a custom setup with nginx + php-fpm which requires supervisord to manage both services. So this is not in line with the recommended docker paradigm of one process per container.

It also seems to slow down the shutdown of this image. In a setup with 5 containers, it's always adminer that I have to wait for.

So would you consider a migration to the official apache based PHP image? It would make the Dockerfile simpler and take the burden of installing PHP from you. You still can tweak the PHP config though, if you want to.

support list of predefined DB connections shown in the UI

It would be nice to have an option for predefined list of DB connections, specified via environment variables on container start (or somehow), later shown in the UI on the login screen.

Similar to:

Support linking database and provide default login form

cannot access adminer

My guess is php-fpm is not working as intended

mathieu on ~ $ docker.io run -d -p 8082:80 clue/adminer
Unable to find image 'clue/adminer' locally
Pulling repository clue/adminer
7a19cce918dd: Download complete
511136ea3c5a: Download complete
9bad880da3d2: Download complete
25f11f5fb0cb: Download complete
ebc34468f71d: Download complete
2318d26665ef: Download complete
ba5877dc9bec: Download complete
b885cb87ad64: Download complete
fa964f21b12c: Download complete
01d2cbcbd446: Download complete
0ecceadc72dc: Download complete
8da2de154950: Download complete
3f4311917222: Download complete
50ad9ecb94cc: Download complete
dff99f6b0f61: Download complete
b2665a7c8e47: Download complete
2cef53d48ca0: Download complete
f2fd4df2bdc7: Download complete
c1e128afef1c: Download complete
06e0523ca164bc48787a41d0ed31bc2aace06dca1caf01b1c1304f9e482074da

mathieu on ~ $ wget http://localhost:8082/
--2014-07-31 10:11:14--  http://localhost:8082/
Resolving localhost (localhost)... 127.0.0.1
Connecting to localhost (localhost)|127.0.0.1|:8082... connected.
HTTP request sent, awaiting response... 404 Not Found
2014-07-31 10:11:14 ERROR 404: Not Found.

mathieu on ~ $ wget http://localhost:8082/index.php
--2014-07-31 10:13:19--  http://localhost:8082/index.php
Resolving localhost (localhost)... 127.0.0.1
Connecting to localhost (localhost)|127.0.0.1|:8082... connected.
HTTP request sent, awaiting response... 502 Bad Gateway
2014-07-31 10:13:19 ERROR 502: Bad Gateway.

No license provided - can we use it?

Hi!

I can't find any software license attached to this project. I would like to use / modify it. Under which conditions is this possible?

Thanks

switch to an Alpine based image

This is the official phpmyadmin Dockerfile that we can imitate:
https://github.com/phpmyadmin/docker/blob/master/Dockerfile

The image size is 55MB. While this Adminer image is 218MB.

Pass signals to supervisord to support stopping cleanly

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.

Unable to connect to PostgreSQL server: fe_sendauth: no password supplied

Hi,
when trying to connect to a postgres server using provided adminer, i get the following message:

Unable to connect to PostgreSQL server: fe_sendauth: no password supplied

The user I am loggin in with DOES have a password and works from other postgres clients (works also from locally running apache-hosted adminer)

Support SSH-tunneled databases

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Hi there,

Not sure if this is the right place but I can't seem to connect to mysql when using this image. This my compose file:

https-portal:
  image: steveltn/https-portal
  ports:
    - 80:80
    - 443:443
  links:
    - wordpress
  environment:
    STAGE: local
    DOMAINS: 'dev.drc.nl -> http://wordpress'
wordpress:
  image: wordpress:php7.1
  links:
    - db:mysql
  environment:
    MYSQL_ROOT_PASSWORD: admin
    MYSQL_DATABASE: wordpress
  volumes:
    - ${PWD}/html:/var/www/html
db:
  image: mysql:latest
  environment:
    MYSQL_ROOT_PASSWORD: admin
adminer:
      image: clue/adminer
      links:
        - db:mysql
      ports:
        - 8181:80

When trying to login i get Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Upload file size not increased to in Adminer

The defined setting for upload_max_filesize and post_max_size is only set to the command line. Under adminer (web interface) the upload limit is still "< 2 MB".

Support Oracle DB (OCI8, PDO_OCI)

Hello,

I'm using your image since a long time. I only tried with mysql and postgresql and it works well.

I just tried on an oracle database and I have this message :

None of the supported PHP extensions (OCI8, PDO_OCI) are available.

Do you know why ?

Thank you :)

Mongo Is Broken

Although there is a mongo in the list of available systems in the login screen, it doesn't work. When I try to log in and use mongo there is an error:
"None of the supported PHP extensions (mongo) are available."

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